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
AymanHanash's avatar
AymanHanash
Qrew Trainee
4 years ago

I have used a combo of Trim with Search& replace, but no luck,

Pasted the results into notepad, comes out like this (with a line in between, if hit delete button,  IE0WW(10) will go next to the first line,

IE0WU (5)


IE0WW (10)

Other lines come out fine, but it happens randomly

IE0X0 (8)IE0X1 (7)

Any other suggestions?  :-) 



------------------------------
Ayman Hanash
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Sorry, I have no ideas what that means,  it does not even seem to come up in a google search.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------