Forum Discussion
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
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- AymanHanash4 years agoQrew Trainee
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__You4 years ago
Qrew Legend
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
------------------------------ - AustinK4 years agoQrew CommanderI would take a look at the website below. The 0x0 and 0x1 remind me of bytes so I figured you are getting some really raw form of a character there. You can try to find the other characters mentioned here and maybe it will help?
https://en.cppreference.com/w/cpp/language/escape-------------------------------------------
Original Message:
Sent: 03-28-2022 09:43
From: Ayman Hanash
Subject: How To remove carriage return from Multi-Line text field
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