Hi Everyone,

How can i format my source string data and trim ONLY
the "carriage return"?
The trim embedded white space Trimming option in Trim
String Transformation Properties box removes any white
space embedded in the source string data but i need to
leave the spaces.

Thanks in advance for your help!

Mitra

In message <938c01c43391$c01395c0$a401280a (AT) phx (DOT) gbl>, mitra fatolahi
<anonymous (AT) discussions (DOT) microsoft.com> writes
You could use an ActiveX Script transform and write your own function to
remove trailing Cr characters, or replace any Cr character found with an
empty string.

Check the syntax, but something like this-

DTSDestination("ColX").Value = Replace(DTSSource("ColX").Value, vbCr,
"")



--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org