Forum Discussion
Solved
Text Paring with a "\n" New line char
Dear Experts,
In the attached sheet, I have data in Column "A" as below:-
So, each cell has items separated by a "\n", I want to parse it in a way that all the items with a new line should be separate in separate columns,
Thanks in Advance,
Br,
Anupam
Table it and load into PowerQuery.
Choose to split column on delimiter like this:
#(lf) is for line feed. If you click Insert special character PQ will put in the #(lf) for you.
3 Replies
Here's my approach:
- Replace New Lines with Another Character:
- Press Ctrl + H to open Find and Replace.
- In "Find what," press Ctrl + J (represents a newline).
- In "Replace with," enter a delimiter like a slash ( / ).
- Click Replace All.
- Use Text to Columns with your chosen delimiter to split the text.
Ctrl+J works directly in Text to Columns (at least on Windows) if enter in Other on second step.
- Replace New Lines with Another Character:
Table it and load into PowerQuery.
Choose to split column on delimiter like this:
#(lf) is for line feed. If you click Insert special character PQ will put in the #(lf) for you.
