DSXchange

remove unnecessary character from First Names(Cominf from source). Valid characters are 0-9, A-Z, ^-_^.,!& ''
All other characters are considered invalid and should be replaced with ' '"

need replace command to use in tranformation logic

There is no replace command. There is, however, a Convert() function. Convert all non-required characters to "".

Tip: initialize a stage variable to contain a full list of non-required characters.

... or store the valid characters (if smaller) and do the "double convert" that's been posted here before.

I tried to do this stage variables,the field populating empty

Convert('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ!&^-_\,','',upcase(LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)) - StageVar1

Convert(StageVar1,str(' ',len(StageVar1)),LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

Remove the str function in second convert.

I tried to do this stage variables,the field populating empty

Convert('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ!&^-_\,','',upcase(LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)) - StageVar1

Convert(StageVar1,LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

Convert requires three arguments.

I tried to do this stage variables,the field populating empty

Convert('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ!&^-_\,','',upcase(LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)) - StageVar1

Convert(StageVar1,(' ',len(StageVar1)),LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

Bejeebus, kind of like a broken record. If it didn't work before, why would it suddenly start working now?

What happens if you use this as your derivation:

Convert(StageVar1,"",LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

By asking you to remove the str function, I meant to change it with the character which must replace your "special characters".

If you want them to be replaced by blank space, use ' '.