How to find AlphaNumeric character from a string

[aarnkalle]

Hi

I am trying to find out AlphaNumeric from a below string. The data is very huge. I tried KeepChar and PurgeChar functions but getting only numbers and not the exact result i am looking for. Please refer below examples and i am trying to find out the AlfaNumbers which is in red bold (Note - in the original data it is not in red bold)

1. Transaction Type - HPH INV SELF-PAY  Transaction Number P122304  Transaction Document Number  credited by Credit Memo Application
2. Receipt Application to Transaction Type - HPH INV SELF-PAY  Transaction Number P448608  Transaction Document Number
3. Credit Memo Application to Transaction Type - HPH INV SELF-PAY PH  Transaction Number P124039PH  Transaction Document Number
4. Transaction Type - HPH INV SELF-PAY PH  Transaction Number P124039PH Transaction Document Number  credited by Credit Memo Application

Thanks in advance.

Regards,

Abhiit.

[thi_pham · Accepted solution]

TextBetween(yourField, 'Transaction Number', 'Transaction Document Number')

Or Regex can support for more complex case: Regular expression [A-Z] *

[aarnkalle]

Hi

Great !!! It's working perfectly.

Thanks a lot.

With Best Regards,

Abhijit.

[thi_pham]

Great! Then, please mark it as correct answer.