I hope all is well.
May you please help if you have a solution around this? I know this was a covered on the below link, however, using the IDEA functions (@Left,@Right,@Split, @Simplsplit, @Mid, @JustNumbers) described, do not work for my currect situation. There are a lot of characters and segments, so trying to use IDEA functions is not effecient:
Here is my current situation:
From the abave i need to segment each part in its own column (see attachment if the above screenshot is not showing). SS -> column 1, 0.875% -> column 2, (0-200m) -> column 3, 0.85% -> column 4 and so on. Now this is achived quickly in Excel or Power BI, by using a space as a delimiter. I have about 16 000 lines of different numbers and lengnths, delimited by space as shown above. Is there a way to acheive this IDEA without exporting my data to Excel to separate the field into multiple fields or do the separation before import into IDEA?
Believe me I have tried the IDEA functions and nothing provided the results in the manner that I needed, after spending a lot of time, other data tools have a quick solution around this.