Forum Discussion
Resolver IQuery data from unstructured text file (*.txt)
Community ChampionYou should have "Split Column by Positions" - this is a very old Split transformation and RS should have it.
If not, the Table.SplitColumn is surely available even if not via the UI.
= Table.SplitColumn(#"Filtered Rows", "Image", Splitter.SplitTextByPositions({4, 9, 20}), {"Image.1", "Image.2", "Image.3"})That is splitting the table #"Filtered Rows" (the previous step) column [Image] into 3 new columns (Image.1/2/3) at postions 4, 9, and 20.
With that info you can manually create your step if that menu option isn't there.
Resolver IThx edhans! I was able to figure it out prior to receiving your reply. First a big thank you.
The split column by position option is not avialable in PBI Report Server. What I did do though is I split the column by number of characters. Then I hacked at the M-Query code to expand it. In essence I replicated the by position option but through the M-Query code. I don't know M-Query so I HACKED! HACKED! HACKED! HACKED! until I got it.
Again big thank you for your time and response!
Rich Ard