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

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