Forum Discussion

aury_lola's avatar
aury_lola
Frequent Visitor
1 year ago
Solved

Power Query: Extract string from one column based on another column in the same table

Hi everyone,   I have a table with 2 columns where one is the combination of the other one plus some characters. As you can see in the image below, neither the "Prefix" nor the characters I'm tryin...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    aury_lola 

    is this what you want?

     

    =Text.End([Combination],Text.Length([Combination])-Text.Length([Prefix]))

ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

aury_lola 

is this what you want?

 

=Text.End([Combination],Text.Length([Combination])-Text.Length([Prefix]))

  • aury_lola's avatar
    aury_lola
    Frequent Visitor
    1 year ago

    That's exactly what I was looking for! Thank you very much!

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      1 year ago

      you are welcome