Forum Discussion
power query - data cleaning and analysis
i am talking about the fixed width feature as shown belowSergeiBaklan
I did that by couple of iteration and approximately, since we use TRIM() exact position most probably is not required.
However, if you are on Excel with dynamic arrays you add in couple of cells one under another
=SEQUENCE(,LEN(A2),0)
and
=MID(A2,SEQUENCE(,LEN(A2)),1)It looks like
Positions start from 0 and each next position is first space after the previous field. That's one time job if only your system generates the file always in exactly the same format.
If format is different from time time I guess removing of excess spaces could be done by Power Query but that will require M-script coding.
in later versions.
Actually that is much more powerful Table.SplitColumn() function which could be called from here
i am talking about the fixed width feature as shown belowSergeiBaklan
In your case it's not very needed. As variant, you may select Split from Non-digit to digit and in formula bar change
on
Result will be the same as you split by positions the sample we discussed.