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

7 Replies

Related Content

Join multi-line text field to one line

Working with Text Multi Line Field

Exchange Templates Removed?

Multi-line text field on an exact form

API call to put text in a multi-line text field

Recent Discussions

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting