Text.PositionOfAny

[Anonymous]

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

"NNNNNNNNNSNNSNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN"

This is the return of the function

List

Extract values ​​and then add dash separator

9-12

How do I make this function start from 1, today it starts from 0, so my answer would be 10-13?

[Ahmedx]

pls try this

Text.Combine(
     List.Transform(
       Text.PositionOfAny("W"&[Assistência], {"S"},     Occurrence.All), Text.From),
       "-")

[Ashish_Mathur · Accepted solution]

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]

@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]

I cannot understand your message.