Hi,
I have pulled a PDF into Alteryx with Intelligence suite. I have narrowed down to the 1 column I need the details for. I have been trying to Regex and/or split the column but I get null or the thousands get removed. I need the figures in 1 column and the letter in another column. Below is what it currently looks like now.
Thanks for you assistance.
I need it to be
118.00 L
51.77 L
1672.92 L
3.00 EA
You can use the RegEx tool set to Output Method - Parse to separate them. One they are separated you can do whatever you want with them. The parenthesis around the code creates groups and each group gets its own Field or Column. First part of the code looks for any non Letter characters (includes numbers and punctuation) and the second part of code looks only for letters.
([^a-zA-Z]+)([a-zA-Z]+)