reading a text

[Ekta]

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

[trettelap]

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]

@Ekta 
we can also try this way.

[Ekta]

@Qiu Thanks so much for the workflow

[Qiu]

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