7 Replies Latest reply on Jan 16, 2020 5:06 AM by Shashikant Gagare

    How to extract the numbers before and after alphabet/s given in the string ?

    Shashikant Gagare New Member

      Hi All,


      Let say, I have data like '1234K987' and I need to extract and load this data into 2 separate output fields like below -


      Input - '1234K987'


      Output Field1 - '1234'

      Output Field2 -'987'


      Could you please let me know how to achieve this ?


      Thank you.