DSXchange

I shared useful and related information links.If sharing links is not accepted,I will not do that.

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.

LastRowInGroup Function can be used more than once,This case occurs when we want to use LastRowInGroup function for more than one field.But Before using this function the fields used in this function should be sorted. See the below link for better understanding http://www.idatastage.com/lastrowingro...

Hi,

Use convert function twice to remove the junk characters or extended characters.

See the below links information,this may help you

http://www.idatastage.com/junk-characte ... datastage/

http://www.idatastage.com/junk-characte ... datastage/