Hi, I have the following data that needs to be entered in 5 columns:
How can a Regex be used to do this?
Thanks.
Résolu ! Accéder à la solution.
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
H/i, @fmvizcaino.
sorry, the data is incomplete, not all strings are the same length. I updated the data.
Thank you for your help!
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
It worked perfectly, thanks!