Forum Discussion

DiePic's avatar
DiePic
Resolver II
3 years ago
Solved

Duplicate a column with text replace

Hi all I have a table that is imported from dynamics 365 sales. I need to duplicate a column but I must cancel the suffix of the code .... this is the example: NrOpportunity = "OPP-0001" NewColum...
  • Mikelytics's avatar
    3 years ago

    Hi DiePic 

     

    base data

     

    define delimiter -> you can also use OPP-

    Results

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.