Parsing lines in a text file by character position

[Nicholas_Kierstead]

I want to parse a text file, so the data can be put into a table. Each line of the file is a long string with no regular delimiters. My thought was to use regex to tell Alteryx to parse out each line using ranges of character positions, for example (0-3), (4-10), (14-20), etc. ; but I can't seem to strip the string properly. 

If the line is: abc2lsdd22___eori38r 

<In the above example  '_' = space>

The string should end up parsed into the following blocks:

abc

2lsdd22

eori38r

Thx!

[Emil_Kos]

Hi @Nicholas_Kierstead,

I have used a combination of left + substrings to make it work:

[marcusblackhill]

Hey @Nicholas_Kierstead !

Don't know if you have many ranges but if at least these ranges don't change, you can work creating columns per range using formula tool with the formula SUBSTRING. Create one column for each range with the respective substring then you can do what you need with the data.

It's a way to do without regex at least.

Hope that helps!

[Nicholas_Kierstead]

Thanks!

[danilang]

Hi @Nicholas_Kierstead 

If the format is the same for each line , i.e. always 0-3, 4-10, 14-20, etc., you can import the file as a txt file and specify the columns in the input tool.  See this post for details.

Dan