Hi,
I have a file I want to import the date from, but the column splitting method of the “File Reader” node does not work the way I want it.
Here is a sample of formatted data (downloadable with the link below):
data.txt (1.3 KB)
All the data are written based on a specific number of characters and spaces as displayed below.
I am looking to find two different ways to separate the columns :
- Split the columns based on the number of characters (1st column : first 13 characters, 2nd column : following 14 characters, 3rd column : following 14 characters, …)
- All the columns are separated by at least 2 space character, and there is no blank value so I would like to split by column all the values that are separated by at least 2 space character.
I thought I would find plenty of similar topics on this forum as it corresponds to the first step of data processing but I could not find any of these solutions, maybe they are too basic for everyone 
.
When I import the data with a comma as a column separator, this is what I obtain (columns are not split) :
But when I use a (or multiple) space as a separator, I obtain a large number of empty columns, so I don’t think this is the solution :
Maybe “regex split” node can be helpful, I am exploring it.
Does anyone have ideas for the two ways to split the column data ?
Thank you.
