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.