I have a set of records with a specific code field. ex: 123221321
I would like to be able to create a field with a flag that is set to a specific value based on the value of the characters in one or more of the specific positions of the code field.
ie: flag = 1 if the first character is '1' and the fourth character is '2'
or flag = 2 if the first character is '2' and the fourth, fifth, and sixth character string is '221'
How would I go about doing this?
Please sign in to leave a comment.