Hello dear community,
I am working on a workflow where I am looking to separate the information in a .txt file by columns. However, inside the file there are names that can be composed from 1 word to many, and as each part of the name is separated by a space, the Text to Columns tool seems not to be the best option.
Attached you will find an example of the .txt file I am working on.
What I want to achieve is to extract the name with some pattern using the Regex Tool, and that name is in a new column.
Example
New Name Column
BRUNO DIAZ
STATE BANK S.A.
CARLOS'S BAKERY S. A.
HEALTHCARE INSTITURE LTDA
After that, I want to replace in the Field_1 column what is within the New Name Column Field by "", that way I can easily separate the information using the Text to Columns Tool.
I would appreciate any help, as I have not been able to find any other way.
Thank you very much!
Solved! Go to Solution.
Hi @Cfdiaz2103
You do not need to use regex for that, just input the file like this and you will have your name column:
Thanks for your response. I was struggling with this and that's because of the Input Data Tool's configuration.
Thanks a lot!