Replace Special Characters

1

Are you able to recommend a rule that would replace the following values from a field?

~
!
@
$
%
^
&
*
(
)

_

{
[
}
]

|
;
:

"
<
,

.
?

2

Usually, you would have a two-column lookup table in which the 1st column is the characters to replace, and the 2nd column is the replacement characters. This lookup table can be defined externally (e.g. in a spreadsheet or a text file), or internally, using the "Create list" action.

Then apply the "Replace with lookup" action.