In this case, Either we would require all the characters that are to be removed from the String or we could go for a more general approach using Regex as already mentioned. The Assign Activity would be updated like below :
Hi @supermanPunch could you please help me in modification of below query if i want to extract only units like kg, cm, mm from $12kg, @123cm, #23mm etc.
CurrentRow(“Height”) = String.Join(“,”,Split(CurrentRow(“Height”).ToString,“,”).Select(Function(x)System.Text.RegularExpressions.Regex.Match(x,“[\d.]+”).Value.ToString).ToArray)