Forum Discussion

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

Qrew 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

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
------------------------------

MarkShnier__You
Qrew Legend
4 years ago
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
  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
    Qrew 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
    ------------------------------

Forum Discussion

How To remove carriage return from Multi-Line text field

Related Content

Join multi-line text field to one line

Working with Text Multi Line Field

Removing Blank Input Type

Multi-line text field on an exact form

Removing \r\n from field