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

     

     

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

Got error

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.

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

    I used this for another purpose but I am getting an error message when the cells does not contain a value or is null.  How can I adjust this accordingly for a null value scenario.

     

    est StringExpected Result
    232 אאוטלט מול הריםנוף הגליל IL213IL213
    null0
    227 אדידס אאוטלט ביג ירכא IL208IL208
    235 IL216 זכרון יעקבIL216
    235 IL216 זכרון יעקבIL216
    250 אאוטלט חוצות המפרץ חיפה IL225IL225
    222 אדידס אאוטלט בילו IL204IL204