Trim
Removes
all leading and trailing spaces and tabs.
A Remove
all occurrences of stripchar.
B Remove
both leading and trailing occurrences of stripchar.
D Remove
leading, trailing, and redundant white-space characters.
E Remove
trailing white-space characters.
F Remove
leading white-space characters.
L Remove
all leading occurrences of stripchar.
R Remove
leading, trailing, and redundant occurrences of stripchar.
T Remove all trailing occurrences of stripchar.
Tags
Datastage
I want to remove numbers from a mixed col.. ie 1FD5 The trim function seems to have issues when I put more than 2 characters o strip.. is Trim(Field_A,'1','2','3', A) it is ok if I put '1','2' but more than that it fails
ReplyDelete