Forum Discussion

radoslaw85's avatar
radoslaw85
Regular Visitor
3 years ago
Solved

Finding position of list items within specific text

Hello. Im trying to do following. In specific row of data in Table I have a text: "A   B C        D     E" if I manualy count the positions of which each letter starts (counting from 0) i get...
Need Help
  • radoslaw85's avatar
    radoslaw85
    3 years ago

    yeah after remembring something from BI Gorilla It worked:

    = Table.AddColumn(
    Table.FirstN(
    Table.SelectColumns( Custom1, "Column1"),1),"Positions", each
    List.Transform(Custom2, (STR) => Text.PositionOf([Column1], STR ) ) )

radoslaw85's avatar
radoslaw85
Regular Visitor
3 years ago

yeah after remembring something from BI Gorilla It worked:

= Table.AddColumn(
Table.FirstN(
Table.SelectColumns( Custom1, "Column1"),1),"Positions", each
List.Transform(Custom2, (STR) => Text.PositionOf([Column1], STR ) ) )