Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Text.PositionOfAny

I'm using the text function "Text.PositionOfAny([Assistência], {"S"}, Occurrence.All)" to get the sequence of S from a string field.   This is the string field "NNNNNNNNNSNNSNNNNNNNNNNNNNNNNNNNNNN...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    This M code works

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "Custom", each List.Transform(Text.PositionOf([Text], "S", Occurrence.All), each Number.From(_) + 1)),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), "-"), type text})
in
    #"Extracted Values"

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "Custom", each List.Transform(Text.PositionOf([Text], "S", Occurrence.All), each Number.From(_) + 1)),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), "-"), type text})
in
    #"Extracted Values"

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Ashish_Mathur Thank you for your help,
The step where I do this validation I cannot call the source, in the previous step I make a line filter, as I adapted the source to start the previous step,

 

Solution

List.Transform(Text.PositionOf([Assistência], "S", Occurrence.All), each Number.From(_) + 1)

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    I cannot understand your message.