To avoid leading spaces in the results, add a whitespace character \s* to the end. This will remove everything before the first colon and trim any spaces right after it: Pattern: ^[^:]*:\s* =RegExpReplace(A5, "^[^:]*:\s*", "") Tip.Besides regular expressions, Excel has its ...
trim11 < 0.5ms < 0.5ms Note 1: The comparison is based on trimming the Magna Carta (over 27,600 characters) with a bit of leading and trailing whitespace 20 times on my personal system. However, the data you're trimming can have a major impact on performance, which is detailed below....
$formatted_email =~ s/\Q$address\E.*$//; $name = $formatted_email; $name = trim($name); $name =~ s/^\"|\"$//g; # If there's a name left after stripping spaces and # leading quotes, and the address doesn't have both # leading and trailing angl...
Assuming "value" is the original token name and "validationResult" becomes the new token, the code below will remove leading and trailing spaces, and remove double quotes. <eval token="validationResult">trim(replace($value$, "\"", "")</eval> 1 Karma Reply zacksoft_wf Contributor ...