Hi Team,
I have an excel file with following data. I have 2 requirement as listed below.
Requirement 1 - There is a column "Special Characters" which has a few values. Requirement here is I except for $, I would like to remove rest all special characters from output. If there is some alphabet or numeral, then I could like to keep that as is. Please refer column "Expected Output - Requirement 1" in table below.
Requirement 2 - Slight modification from the requirement 1. Except for $ and #, I would like to remove rest all special characters from output. If there is some alphabet or numeral, then I could like to keep that as is. Please refer column "Expected Output - Requirement 2" in table below.
I tried achieving this through RegEx tool, but could not. Any help in this regard is highly appreciated.
Thanks in advance.
Special Characters | Expected Output - Requirement 1 | Expected Output - Requirement 2 |
$%$% | $$ | $$ |
%^%^ | ||
&(*^(^ | ||
#$%#&%&* | $ | #$# |
@$%#^56 | $56 | $#56 |
%&*&^ | ||
123&*& | 123 | 123 |
vsg45%#^ | vsg45 | vsg45# |
ddfr66# | ddfr66 | ddfr66# |
Regards
Solved! Go to Solution.
Thanks a ton for the quick response, Mark. This works for me.