Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aarnkalle
New Contributor II

How to find AlphaNumeric character from a string

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.


1 Solution

Accepted Solutions
thi_pham
Contributor

Re: How to find AlphaNumeric character from a string

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

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

3 Replies
thi_pham
Contributor

Re: How to find AlphaNumeric character from a string

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

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

aarnkalle
New Contributor II

Re: How to find AlphaNumeric character from a string

Hi

Great !!! It's working perfectly.

Thanks a lot.

With Best Regards,

Abhijit.

thi_pham
Contributor

Re: How to find AlphaNumeric character from a string

Great! Then, please mark it as correct answer.