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!
Solved! Go to Solution.
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 : )
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?
Many thanks!
Happy to help : ) @Savannah
Cheers and have a nice day!
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!
Perfect! Many thanks! 🙂
Happy to help : ) @Savannah
Cheers and have a nice day!