Forum Discussion
import text file
I have multiple text files I want to import into tables. They say it is ASCII format, but there are no delimiters. The way it was setup is the first row has a number dashes and then a space, the spac...
I'd try the following:
Select the first record (Source{0}) and add a column: Text.PositionOf([Column1], " ", Occurrence.All)
This should return a list with all positions of blanks. Fill in this stepname as a variable into the Csv.Document call (instead of the list with the hardcoded numbers)