use space as a delimiter?

#1

I want to use DTS to have a quote delimited, space separated text file for
meeting the requiremenst for one of our vendors for data format.

I've been doing quoted, vertical bar separated, running the DTS, opening the
txt file output, and doing a Search->Replace All "|" with " "

is there a way to specify a custom delimiter character?

#2

Yep

Coping with text files and abnormal column or row delimiters
(http://www.sqldts.com/default.aspx?257)

"Bob" <someone (AT) somewhere (DOT) com> wrote

Quote:

I want to use DTS to have a quote delimited, space separated text file for

meeting the requiremenst for one of our vendors for data format.

I've been doing quoted, vertical bar separated, running the DTS, opening
the
txt file output, and doing a Search->Replace All "|" with " "

is there a way to specify a custom delimiter character?

#3

thank you!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

Yep

Coping with text files and abnormal column or row delimiters
(http://www.sqldts.com/default.aspx?257)

"Bob" <someone (AT) somewhere (DOT) com> wrote

I want to use DTS to have a quote delimited, space separated text file
for

meeting the requiremenst for one of our vendors for data format.

I've been doing quoted, vertical bar separated, running the DTS, opening
the
txt file output, and doing a Search->Replace All "|" with " "

is there a way to specify a custom delimiter character?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

use space as a delimiter?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

use space as a delimiter? - 02-17-2005 , 11:55 AM

Re: use space as a delimiter? - 02-17-2005 , 01:17 PM

Re: use space as a delimiter? - 02-17-2005 , 05:35 PM