DSXchange

check out this,may helps u.

http://dsxchange.com/viewtopic.php?t=11 ... bebd3cc7f7

it wl work....
Convert(Char(26),' ',In.ColumnName)
or
Convert(Char(26),Space(1),In.ColumnName)

This could help you...

Convert(Char(26),' ',In.ColumnName)

Hi, first one working fine and im getting the desired output
link.columnname[1,Len(link.columnname)-13]
Thanks

but second solution in stage variable showing the error
that VARIABLE 'Oconv' not defined

could u explain what is ment by ' Go_' in the logic,what it actually do?

Hi DS Gurus, im getting the source data from the sybase as ODVAdsti_20060913.csv TRANSdsti_Trn_20060913.csv like that... now i want the output like ODVAdsti TRANSdsti_Trn i dont want _20060913.csv i have to implement the logic in Transformation i tried Field function n substring functions,but not su...