Forum Discussion
RokuCap
Helper I
Helper ISplitting Columns by Tab Delimiter for Variable Tab Sizes in a Text File
I have a text file that has text separated by different tab lengths (Refer to the example below). I want to clean up the data by separating each grouped string into their own columns. In the example,...
Hi RokuCap - it would be nice to have a sample file to play with. Could you upload one?
Otherwise this is what I am thinking. I would keep the rows in 1 column. I would apply a Trim function to align the A and B to left. I might try the following function, Splitter.SplitTextByCharacterTransition - PowerQuery M | Microsoft Docs. The idea here is to find the transition from Character to Tab. Another Option it to split for column1 and remainder, then split column2 and remainder, and column 3 and remainder etc... Another option is to split the rows into group A and group B, then split each group according then Append (Table.Combine) back together again.
I hope this helps you think of some different approaches.