We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

reading a text

Ekta
8 - Asteroid

Hello, 

 

I am working on extracting the data from pdf, but sometimes due to readability issue , text is not captured correctly for eg -

 

AB12C -> this should be A812C

 

Rule is - 1st and last letter are always alphabet's and middle 3 are always numbers.

 

Please help me with the formula so i can put a logic , if middle numbers have B then it is 8 or I then it is 1.

 

Thank you in advance

4 REPLIES 4
trettelap
8 - Asteroid

Hello,

 

I would try using the tokenize regex tool to get each character in a separate column. Then use a formula tool to use a replace function to replace the characters that you want. Then you can concatenate the columns back into one. Hopefully that helps!

Qiu
20 - Arcturus
20 - Arcturus

@Ekta 
we can also try this way.

1110-Ekta.PNG

Ekta
8 - Asteroid

@Qiu Thanks so much for the workflow

Qiu
20 - Arcturus
20 - Arcturus

@Ekta 
Glad to help. and would appreciate you would also mark my solution as accept.

Labels