Trim in Modify stage

[zulfi123786]

I have tried as posted, its triming only the leading spaces but the trailing spaces still remain untrimmed. please suggest............

[sanjay]

Try

n3:string[max=20] = string_trim[" ",end,begin](n1)

Thanks
Sanjay

I have tried as posted, its triming only the leading spaces but the trailing spaces still remain untrimmed. please suggest............

[abbss_guri]

I myself tried few things but nothing seems to be working
All the functions mentioned in the post , none of them works for me
space=String_Trim[" "](ABC)
space=String_Trim(ABC)
space=String_Trim[" ",end,begin](ABC)
.
.
.
. list goes on but always i get the same output
Peek_292,0: space: 4
with trim_leading_trailing and strip_white_spaces, the job aborts.
any idea where i am wrong

[sathesh.ss]

Can Somebody still help me , how we would trim the char field in modify stage

[chulett]

If you literally mean char rather than varchar and you're trying to trim trailing spaces, you cannot. Anywhere. Nature of the beast.

[ray.wurlod]

Technically you can trim a Char data type but it is padded before being transferred to the output link. The pad character is defined using the environment variable APT_STRING_PADCHAR. A Char field has a constant size on an output link.