Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I need to pull all the single words out of the sentence.
I mean I should have just been words without numbers or any other symbol!
I use the following formula:
Table.AddColumn (# "Changed Type", "Custom", each Text.Remove ([name], {"!", "@", "#", "$", "%", "^", "& "," * "," (",") "," - "," _ "," + "," = "," {","} "," [","] "," | ", "\", "/", "~", "` ","? ",": ",". "," <","> "," 0 "," 1 "," 2 "," 3 "," 4 "," 5 "," 6 "," 7 "," 8 "," 9 "}))
The problem is I can't quite clear everything and there are many more symbols left between the words. Of course, it is not possible to manually search for any icon and delete it.
Does anyone know a way to deal with this problem?
Solved! Go to Solution.
Hi @Galat,
I searched and found this:
Text.Select([name],{"a".."z","A".."Z","0".."9"," "})
By the way, I found that on this thread:
Hope this helps!
try
TextEncoding.Utf8
TextEncoding.Unicode
=D
For another situation I had built a function that removes "non-standard" characters from a text. I think it could be for you.
let
fnCngNotStndCharsToDef = (str_in as text, stndChrs as list, optional defChar as text) =>
Text.Combine(
List.Transform(
Splitter.SplitTextByRepeatedLengths(1)(str_in),
each Record.FieldOrDefault(Record.FromList(stndChrs, stndChrs), _, defChar)
)
)
in
fnCngNotStndCharsToDef
an example of use:
PS
Actually the function has a slightly more general extension, being able to replace non-standard characters with a chosen default character.
If this is omitted, the result is to remove unwanted characters.
Hi @Galat,
I searched and found this:
Text.Select([name],{"a".."z","A".."Z","0".."9"," "})
By the way, I found that on this thread:
Hope this helps!