New line within the same cell

[Savannah]

Hello 

I have been trying to look at other posts for this topic, but was unable to find a solution. 

I have text in one Excel cell:

01/01/22: knioaivneioiekiadfnkdhi iofnenwoij oiehfeinfeio idioem
2/1/22: cimkcibm eknkgoeg fkeing
3/1/22: ckkmvkeg eifknke

I want it to stay in that format. Now, Alteryx just takes all the text in one string and doesn't divide it up. 

I've attached sample Excel file. 

Many thanks for any suggestions! 

[Savannah]

Hello 

I have been trying to look at other posts for this topic, but was unable to find a solution. 

I have text in one Excel cell:

01/01/22: knioaivneioiekiadfnkdhi iofnenwoij oiehfeinfeio idioem
2/1/22: cimkcibm eknkgoeg fkeing
3/1/22: ckkmvkeg eifknke

I want it to stay in that format. Now, Alteryx just takes all the text in one string and doesn't divide it up. 

I've attached sample Excel file. 

Many thanks for any suggestions! 

[atcodedog05]

Hi @Savannah 

Here is how you can do it.

Make sure to set the input tool as First row contains data.

Then split to new lines in regex

Hope this helps : )

[Savannah]

Hi!

Sorry, I was unclear, I need the lines to stay within the same cell and not split into three cells. How can i do this?

[atcodedog05 · Accepted solution]

Hi @Savannah 

Just reading in will give you the data in single cell.

Workflow:

Hope this helps : )

[Savannah]

Many thanks! 

[atcodedog05]

Happy to help : ) @Savannah 

Cheers and have a nice day!

[Savannah]

Hi!

Looking at my workflow, I can see that it's the Basic Table Tool that eliminates the lines in a cell and puts them all on the same line. Would you know how I can separate them into separate lines again?

Thanks! 

[atcodedog05]

Hi @Savannah 

That happens with reporting tools. Try this post.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Working-with-wanted-line-breaks-and-th...

Hope this helps : )

[Savannah]

Perfect! Many thanks!

[atcodedog05]

Happy to help : ) @Savannah 

Cheers and have a nice day!