3 Replies Latest reply: Jul 17, 2018 9:28 AM by Thi Pham RSS

    How to find AlphaNumeric character from a string

    Abhijit Arankalle

      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.