Regex Expression/Join based on Condition

[Cgandhi0794]

Hi everyone,

I have a question and I apologize if this is an easy solution. I have two files and I need to join based on two fields. For example

Field1 (In File 1)                                      Field 5 (In File 2)

123456                                                    L123456-Test Case ABC

I need to join based on the common values within both fields. In this case, '123456'.

Would I need a regex expression to remove the other characters from Field 5 (In File 2)? If so, not sure how to write that expression.

I would really appreciate any help to find a solution. Thank you so much!

[messi007 · Accepted solution]

@Cgandhi0794,

Please see below:

I used a Regex tool in order to get 6 digit from Field 5 (In File 2)

Then I used the join too based in the extract field.

Attached the workflow,

Hope this helps,

Regards,

[Cgandhi0794]

Thank you! This worked perfectly!