Forum Discussion
Query data from unstructured text file (*.txt)
You 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.
Hi DAXRichArd
Try selecting the column first. In the PBI RS the ribbon changes quite a bit depending on the context.
Kind regards,
JB
You 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.
Thx 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
