DSXchange

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

Try

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

Thanks
Sanjay

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

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

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

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

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.