How To remove carriage return from Multi-Line text field

Question

Hello,
I have searched for this subject and found 1 post with 0 responses.&nbsp;&nbsp;
I'm pulling in info from QB using Power Query, a Multi-line text field is not pulling at all when there
are multiple lines created using a carriage return / line feed.&nbsp; Is there a function similar to CLEAN (instead of TRIM)? or how can I replace the non visible carriage return using another text formula field (without taking the table down clean it and re-uploading)
thanks,------------------------------Ayman Hanash------------------------------

markshnier__you · Answer

Try this as a formula text field.SearchAndReplace([My multi line text field], "
", " ")That says to replace any carriage returns with a space.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

aymanhanash · Answer

Mark, Thanks,&nbsp; "
" did the trick....------------------------------Ayman Hanash------------------------------

aymanhanash · Answer

Hey Mark,

the "
" helped with some lines, but other lines power query didn't pickup, are there any other invisible&nbsp;
characters aside from the carriage return?&nbsp;&nbsp;------------------------------Ayman Hanash------------------------------

markshnier__you · Answer

You might try to copy and paste the result into some kind of notepad type app (not Word) to try to see what is really there.

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

aymanhanash · Answer

I have used a combo of Trim with Search&amp; replace, but no luck,
Pasted the results into notepad, comes out like this (with a line in between, if hit delete button,&nbsp; 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?&nbsp; :-)&nbsp;------------------------------Ayman Hanash------------------------------

Forum Discussion

How To remove carriage return from Multi-Line text field