AymanHanash
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: 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 ------------------------------5Views0likes2CommentsRe: How To remove carriage return from Multi-Line text field
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 ------------------------------49Views0likes4CommentsHow 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 lines created using a carriage return / line feed. 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 ------------------------------59Views1like7Comments