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"})
You will need to use Table.ReplaceValue for this.
= Table.ReplaceValue(#"Columna duplicada",each [Results],each Text.AfterDelimiter([Results], ",", [CommaJump] ),Replacer.ReplaceValue,{"Results"})Genius! Thanks 🙂
