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 INPUTREPLACE INPUTStevens, LouisLouis StevensStevens, Louis JLouis StevensStevens, Louis (he/his/him)Louis Stevens How can i successfully map these over to append fields to the data? Thanks.

2 data inputs. How to map {Last Name, First Name} to {First Name Last Name}

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.

Custom Tools

Accepted answers

Prometheus

@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.

Parse out name.PNG

Concat Name.PNG

Parse Name.yxmd

All comments

Prometheus

Parse out name.PNG

Concat Name.PNG

Parse Name.yxmd

wonka1234

@Prometheus thank this works! i forgot another scenario..

Stevens Sal, Louis John (he/him/his) --> Louis Stevens

Prometheus

@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 (.*).

Quick Links

This months top contributors

FláviaB 262

caltang 177

DanM 167

IraWatt 157

gawa 157