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

Icon for Qrew Legend rank

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
Mark, Thanks, "\n" did the trick....

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