Hello,
I was hoping someone could lead me in the right direction here. I am trying to split up this long column of text and am having some issues. I have marked how this column needs to split up in the first row, and as you can see I have successfully pulled out some of the information I need. I think pulling the first three words of the description is satisfactory enough if there isn't an easier way to pull all of the text into a new column. Could someone give me tips on how to pull the second date and both values out of this text column into separate columns?
Thanks!
Solved! Go to Solution.
You have the correct idea of using RegEx to parse this out! Essentially, you need to delimit based on the patterns. In your case, you can tell Alteryx the first field is letters, the second is a date, the third is a date, etc.
Are you able to post a sample of the data to work with?
Phillip thank you So much!!!
That will work perfectly for me!
Thank you!