How to remove special characters only when not followed by strings

[Sifur]

Hi,

i am trying to remove special characters only when they are not part of a lead unique identifier.

For instance it would look like this:

Converted From Qualified Lead	Converted From Qualified Lead
-
-
Lead-292915	Lead-292915
Lead-214853	Lead-214853
-
Lead-316569	Lead-316569
-
Lead-176302	Lead-176302
Lead-214641	Lead-214641

Anyone knows how to do that? when exporting files from SFDC the nulls come up with a dash and I would like to return them null again.

thanks

[kelsey_kincaid · Accepted solution]

Hi @Sifur ,

You could use an IF statement to replace anything that is only a dash with Null().

IF [Converted From Qualified Lead] = '-' THEN
Null()
ELSE
[Converted From Qualified Lead]
ENDIF

[Sifur]

Perfect! Thanks for your help! 🙂