Forum Discussion
Solved
Text.AfterDelimiter tricky
Hi! I have to extract some text from a field after N commas (","), so I use Text.AfterDelimiter with optional index to specify hoy many of those characters commas I want to jump. The tricky part ...
You will need to use Table.ReplaceValue for this.
= Table.ReplaceValue(#"Columna duplicada",each [Results],each Text.AfterDelimiter([Results], ",", [CommaJump] ),Replacer.ReplaceValue,{"Results"})
I don't think you can use Table.TransformColumns for this. Probably have to add a custom column