Removing "*" in transformer stage

[Childrensmn]

Hello:

I have a varchar column: GradeValue and the source data has "*" <asterisk> in some rows.
Example:
145*
12*
9*
I want to remove that "*" sign in the transformer stage. I am using FTP stage to get the source records and do some validation in the transformer stage. What function do I use to remove the "*" character?

Thank You!!

[chulett]

Use the Convert() function to replace that character with an empty string which removes it.

Code: Select all

Convert("*","",YourField)

[Childrensmn]

Thanks!!