Finding patterns in a string and setting value in a field

Question

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

ComField Value AB010CD010FF120DK130IU890PP111ABI31CDI41EF151GHI61

jrgo · Accepted Answer

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

messi007 · Accepted Answer

@Abhii2658,

Please see below

Attached the workflow.

Hope this helps!

Regards

atcodedog05 · Accepted Answer

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 : )