Trim Function Not Working In Datastage at Theodore Talbert blog

Trim Function Not Working In Datastage.  — use the trim function to remove unwanted characters in expression.  — i have an input string column which is something like 1/9/2013 0:00 “”. My desired output is ““1/9/2013” in string. For trimming spaces or a char from a string can be done in modify stage. In transform stage we can use. The job is puling data from mainframe and it is putting some. If only expression is specified, multiple.  — i am using trim function in user variable activity in ds 7.5 trim(trim(excmd_emailrepttype.$commandoutput,*,l),#,t).  — in the transformer i am using the transformation len(trim(column1)) where column1 is having datatype char2.  — i am not able to trim the value from a char column.  — i am trying to remove leading and trailing spaces in datastage.  — string_trim[character,direction,justify](string) this function can be used to trim.

 — i am trying to remove leading and trailing spaces in datastage. My desired output is ““1/9/2013” in string.  — in the transformer i am using the transformation len(trim(column1)) where column1 is having datatype char2.  — i am using trim function in user variable activity in ds 7.5 trim(trim(excmd_emailrepttype.$commandoutput,*,l),#,t). The job is puling data from mainframe and it is putting some.  — string_trim[character,direction,justify](string) this function can be used to trim.  — i am not able to trim the value from a char column. If only expression is specified, multiple. In transform stage we can use. For trimming spaces or a char from a string can be done in modify stage.

Trim Function Example In Datastage at Sharon Haas blog

Trim Function Not Working In Datastage For trimming spaces or a char from a string can be done in modify stage. If only expression is specified, multiple.  — in the transformer i am using the transformation len(trim(column1)) where column1 is having datatype char2.  — i am not able to trim the value from a char column.  — i have an input string column which is something like 1/9/2013 0:00 “”.  — i am using trim function in user variable activity in ds 7.5 trim(trim(excmd_emailrepttype.$commandoutput,*,l),#,t). For trimming spaces or a char from a string can be done in modify stage. In transform stage we can use.  — use the trim function to remove unwanted characters in expression.  — string_trim[character,direction,justify](string) this function can be used to trim. The job is puling data from mainframe and it is putting some. My desired output is ““1/9/2013” in string.  — i am trying to remove leading and trailing spaces in datastage.