Use If In Assign don't seem to work

Help Studio
1

Hi

I have a variable auto_name = xxx.1, or xxx.2,… xxx.12

Each of the last digit denote the mth. Eg 1=Jan, 2=Feb…

I want to create a new variable for the mth. I did a quick test with the below, but it doesn’t work.

Even when auto_name = xxx.1, Name_Mth = “Sep”. It can’t seem to read the condition

Name_Mth = IF(RIGHT(auto_name,1)=“1”,“Jan”, “Sep”)

2

If auto_name.Substring(auto_name.Length-1)=“1”
then
assign Name_Mth=“Jan”

3

Are you using it as formula

4

Hi

I am using the below on the RIGHT side of the Assign:

IF(RIGHT(auto_name,1)=“1”,“Jan”, “Sep”)

Thank you

5

Hi

I don’t want to use the IF-ELSE-THEN activity.

Thank you

6

You can use **

switch

** for all month

7

I know what is wrong. There are blank spaces on the right of my variable auto_name, so it is not reading in the last digit.