Forum Discussion
Splitter.SplitTextByDelimiter using ENTER as the delimiter character
Hey guys.
I want to use Splitter.SplitTextByDelimiter using ENTER as the delimiter character.
Using the Power Query interface I was able to do this using the comma and in particular it was useful because it gives the option of separating values into ROWS and not just columns.
I need this but using ENTER as a limiting character.
Any ideas?
Try using "#(lf)" or "#(cr)" as the delimiter. These stand for "Line Feed" and "Carriage Return" and are the typical new line characters.
3 Replies
Try using "#(lf)" or "#(cr)" as the delimiter. These stand for "Line Feed" and "Carriage Return" and are the typical new line characters.
"#(cr)" is the code for this. Example below
Splitter.SplitTextByDelimiter("#(cr)")([Column1])
#(lf) worked fine to me!
Thank you everyone for your help
