Extracting a Name from a .txt file

[Cfdiaz2103]

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!

[Felipe_Ribeir0 · Accepted 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:

[Cfdiaz2103]

Hi @Felipe_Ribeir0 

Thanks for your response. I was struggling with this and that's because of the Input Data Tool's configuration.

Thanks a lot!