Hi there,
I am trying to create a new variable base on a combination of the characters in an existing value. For example, Var1 has a value "ABCDEFG" and I would like to create a Var2 which should look like "ABC__F".
I tried substring(ltrim(rtrim(Var1,1,3))) to get "ABC" part. However, I don't know how to get "__F" part.
Could someone please help?
Thank you
I am trying to create a new variable base on a combination of the characters in an existing value. For example, Var1 has a value "ABCDEFG" and I would like to create a Var2 which should look like "ABC__F".
I tried substring(ltrim(rtrim(Var1,1,3))) to get "ABC" part. However, I don't know how to get "__F" part.
Could someone please help?
Thank you