Trim Function

rajikarthick · Post by **rajikarthick** » Fri Sep 05, 2014 4:17 am

Can anyone explain what does the below function do exactly?

Trim(Col1,"",'T')

qt_ky · Post by **qt_ky** » Fri Sep 05, 2014 5:51 am

Test it to find out.

priyadarshikunal · Post by **priyadarshikunal** » Fri Sep 05, 2014 6:16 am

read page 658 of parallel job developer guide.

chulett · Post by **chulett** » Fri Sep 05, 2014 7:11 am

As noted, read the documentation. This was posted as a Server function so best to check either the Server Job Developer's Guide pdf manual or use the built-in help system. It's all there.

ps. 'T' is for Trailing.

prahul4all · Post by **prahul4all** » Wed Sep 10, 2014 12:53 am

Hi,

The above function trims the trailing characters,Let's see an example below

Source Field Data : 'DatastageNNN'

Trim('DatastageNNN','N','T')

It will give output as 'Datastage'

After using the trim function it deletes all the Trailing 'N' characters.

priyadarshikunal · Post by **priyadarshikunal** » Wed Sep 10, 2014 2:44 am

Well with this answer he got what he wanted but next time he will come back if he finds trim(col1." ",'B'). Unless he reads the documentation.

So, I would suggest to read the documentation to know about the other option, even if you can't remember, you will know where to find it when you need.

DSXchange

Trim Function

Trim Function

Re: Trim Function