Forum Discussion
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
"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?
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.
4 Replies
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 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)
I cannot understand your message.
pls try this
Text.Combine( List.Transform( Text.PositionOfAny("W"&[Assistência], {"S"}, Occurrence.All), Text.From), "-")
