locked
Power Query get value RRS feed

  • Question

  • Hi,

    As you can see i've got a table with a column "Mantis" And "Tests" and in the column "Tests" there is value "ATRAQ-XXX" and i would like to only get the number after each ATRAQ-.

    For example if i've got the test "ATRAQ-150" i want only the number "150"

    Thanks,

    Friday, May 17, 2019 7:33 AM

Answers

  • Hi LitSin

    Add a Custom Column, name it "Test_Numbers" and copy the following formula:

    = Text.Replace(Text.Replace([Tests], "ATRAQ-","")," ","")

    You'll get a new column named "Test_Numbers" with a text string just with the numbers and commas.

    If you want a list of all the numbers, add another Custom Column, name it "Test_List" and use this formula:

    = try Text.Split([Test_Numbers],",") otherwise null

    No you have a new column with a list (not a string) of the numbers, that you can expand (doble row icon at the right side of the column's name).

    Daniel

    Friday, May 17, 2019 8:36 AM