Finding patterns in a string and setting value in a field

[Abhii2658]

I have the following data. 

In the Com column, wherever there is an "I" in the third place of the data the value is set to 1. 

EF"I"5 - becomes 1 

Com	Field Value
AB01	0
CD01	0
FF12	0
DK13	0
IU89	0
PP11	1
ABI3	1
CDI4	1
EF15	1
GHI6	1

[jrgo · Accepted solution]

IF REGEX_MATCH([Com], '^..I.*$')
THEN 1
ELSE 0
ENDIF

[messi007 · Accepted solution]

@Abhii2658,

Please see below 

Attached the workflow.

Hope this helps!

Regards

[atcodedog05 · Accepted solution]

Hi @Abhii2658 

I am bit confused what is the character ? I am taking it as i and 1 please let me know.

Workflow:

Can you please clarify what is the character 😅

Hope this helps : )

[atcodedog05]

Happy to help : ) @Abhii2658 

Cheers and have a nice day!