hello, i understand that i could do the name transformation using REGEX, but how do i create the new name format as an extra column instead of replacing the original column?
Have you thought about just cloning the original column and then doing the regex on the new column? Attached an example of what I was thinking
I would recommend using a formula tool.
@mpennington Thank you for showing the sample of placeholders of RegEx.just one question is $2 necessary in this case? 😁
@Morgan_ThomasThank you for the example! i wasn't aware that the formula tool could be used to generate a new column, that is exactly what i needed to know!
@mpennington Thank you! I was going to use the regex tool, but using the same formula tool that created the column is a great idea.
I used this regex string to remove the middle initial. You're right that this set of names contains first and last names with spaces in them
