Forum Discussion
Text Forced Enter/Return
Actually after many tries over 3 days, I finally found a solution to my issue, so I am here to share:
In Query Editor:
Value to Find: _x000D_
Replace With: #(cr) --> Special Character for Carriage Return
Actually after many tries over 3 days, I finally found a solution to my issue, so I am here to share:
In Query Editor:
Value to Find: _x000D_
Replace With: #(cr) --> Special Character for Carriage Return
Hi Anonymous
I couldn't understand how it solved the problem.
My data has "_x000D_ written at the end.
Can you help me?Hi Anonymous
In the Query Editor, select the column with the special characters. Then under the Transform tab, select Replace Value.
A menu pops up, and at the bottom of the menu, expand "Advanced Options", and select "Replace using Special Characters".
Then follow the solution post in this thread.
Hope this helps.
Thank you so much Anonymous !!!!!! You saved my life 😀