Forum Discussion

AymanHanash's avatar
AymanHanash
Qrew Trainee
4 years ago

How To remove carriage return from Multi-Line text field

Hello, I have searched for this subject and found 1 post with 0 responses.   I'm pulling in info from QB using Power Query, a Multi-line text field is not pulling at all when there are multiple...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Try this as a formula text field.

SearchAndReplace([My multi line text field], "\n", " ")

That says to replace any carriage returns with a space.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
AymanHanash's avatar
AymanHanash
Qrew Trainee
4 years ago

Hey Mark,

the "\n" helped with some lines, but other lines power query didn't pickup, are there any other invisible 

characters aside from the carriage return?  



------------------------------
Ayman Hanash
------------------------------