Replace command

[edison]

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

[ray.wurlod]

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.

[chulett]

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

[edison]

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)

[Sainath.Srinivasan]

Remove the str function in second convert.

[edison]

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)

[chulett]

Convert requires three arguments.

[edison]

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)

[chulett]

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)

[Sainath.Srinivasan]

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 ' '.