Hi,
I am trying to find replace to append fields. I am trying to find the correct configuration with find replace tool.. maybe data manipluation has to be done before find replace tool?
FIND INPUT | REPLACE INPUT |
Stevens, Louis | Louis Stevens |
Stevens, Louis J | Louis Stevens |
Stevens, Louis (he/his/him) | Louis Stevens |
How can i successfully map these over to append fields to the data?
Thanks.
解決済! 解決策の投稿を見る。
@wonka1234 I used a RegEx tool to parse out the values in "FIND INPUT" and FirstName and LastName, then used a Formula tool to concatenate those fields with a space in between to create the full name in REPLACE INPUT. If you're trying to identify patterns, I suggest taking a look at www.regex101.com. It's super helpful and intuitive.
@Prometheus thank this works! i forgot another scenario..
Stevens Sal, Louis John (he/him/his) --> Louis Stevens
@wonka1234 Change the expression in the RegEx tool to this and you should be good to go: (^[A-Za-z]+)\s*.*\,\s([A-Za-z]+)
Everything in parentheses becomes its own field, so between ")" and "(" I just had to add the possibility of a space occurring before the comma zero to infinity times (\s*), and any other characters after that space and before the comma from zero to infinity times (.*).
hi @Prometheus , I have the same scenario with @wonka1234 but in my case the input is all capital letters (SUAR,JOCEL PILAPIL) no spaces in between comma and I need the "PILAPIL" to be in the Middlename column. Thanks in advance
@PassION_es I like to use www.regex101.com to help me with my regular expressions. You'll find it's easy to learn when you use it all the time. I used this expression to parse out your data into three columns (Last, First, and Middle): ^([A-Z]+),([A-Z]+)\s([A-Z]+). Please see the attached workflow. Thanks
Thank you @Prometheus