Forum Discussion
Splitting Text on multiple delimiters with DAX
I have a table with 10 million+ records. One table contains a text field with multiple sentences in each cell. My goal is to let the user select one record, and then split its sentences by a spec...
Hi Anonymous ,
have a look at the solution in the attached file.
Hi Anonymous ,
try this
Thank you mwegener! This method almost solved my problem. I need to do one additional thing.
Now the sentences are all on new lines, however I also need them in different cells. Something like this:
I have to put the sentences in different records. Is there an on the fly function for this?
Hi Anonymous ,
have a look at the solution in the attached file.
Thank you very much! 🙂