Forum Discussion

khisla's avatar
khisla
Icon for Helper II rankHelper II
1 year ago
Solved

Extract part of text string

I have a column with a text sting that I need to extract the store number   Test String Expected Result 232 אאוטלט מול הריםנוף הגליל IL213 IL213 232 אאוטלט מול הריםנוף הגליל IL213 IL213...
  • techies's avatar
    techies
    1 year ago

    Hi khisla please try this custom column in power query editor

     

    = if Text.Contains([Test String], "IL")
    then Text.Middle([Test String], Text.PositionOf([Test String], "IL"), 5)
    else null

  • techies's avatar
    techies
    1 year ago

    Hi khisla please check this

     

     

techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

Hi khisla please check this

 

 

khisla's avatar
khisla
Icon for Helper II rankHelper II
1 year ago

Thanks!!! This worked perfectly.