Regex to parse numbers and text

[wellington_costa]

Hi, I have the following data that needs to be entered in 5 columns:

How can a Regex be used to do this?

Thanks.

[fmvizcaino]

Hi @wellington_costa ,

This is a fixed width file problem so you can open your txt file as a .flat file and select the 'fixed width text file' as image below.

Then after confirming, it will open a layout pop-up where, by clicking, you decide where to cut your columns.

I'm sharing an example with you. To open the file layout, see image below.

Best,

Fernando Vizcaino

[wellington_costa]

H/i, @fmvizcaino.

sorry, the data is incomplete, not all strings are the same length. I updated the data.

Thank you for your help!

[fmvizcaino · Accepted solution]

Hi @wellington_costa ,

As I'm looking at it, I will still use a bit of fixed width for the first 2 columns and them regex for the last 3.

Example attached.

Best,

Fernando Vizcaino

[wellington_costa]

It worked perfectly, thanks!

[terry10]

Using the attached workflow cleans your data up nicely. The trick was to RegEx it from both ends, leaving the remainder in column 2, and then removing the contents of  3,4, and 5 from Column 2. Is this helpful?