Forum Discussion
Solved
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 us...
Try using "#(lf)" or "#(cr)" as the delimiter. These stand for "Line Feed" and "Carriage Return" and are the typical new line characters.
#(lf) worked fine to me!
Thank you everyone for your help