Update fildes based on info in other fieldes

[withoutaclue]

I am trying to run some queries to assign/update an empty field called “useridTYPE” with some values based on the contents of another field called Userid.

However the Userid fieled consits of a mixture of user information. (inputs from other fields like, forname,surname,initial)

The userid field was not automatically created, it was typed in by the user at the time.
Therefore I need to create a query/or something, that can read the data in the userid field, determine what it is and assign a type value to it in the Usertype filde

Ie
If user id =
Forname.surname = type1
Initalsurname = type 2
Initial_surname = type 3

(I have about 16 types)
can anyone help

 

[JOLESEN]

Which forum does this question belong to ??

/JOlesen

 

[codeaddict]

you can create a code list and access it through the special rule or use the extended rule of the first file assign the value after the conditions are met then assign it to a temp field then link the temp field.