Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex Everything After Last Letter

andrewmcateer
6 - Meteoroid

Hi, 

 

I was wondering if anyone had any ideas for parsing everything in a string after the last letter? 

 

I'm working with a PDF extraction and the string before the number I need to parse is very changeable that I can't put in any patterns that work on the whole field consistently, the only certainty is that there will be a final letter, and then numbers and punctuation afterwards with varying whitespace. e.g.

"P     2,431,772.43   )

 

 

Any help is appreciated - thank you. 

 

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @andrewmcateer 

 

Are you looking for something like this.

atcodedog05_0-1641556713311.png

 

Hope this helps : )

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

 

andrewmcateer
6 - Meteoroid

Thanks @atcodedog05 , that worked perfectly - appreciate the help. 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @andrewmcateer 

Cheers and have a nice day!

Labels