Stripping a 'TAB' from a text field

#1

Hello

I'd like to thank everyone who has helped me in that past. You guys have
been great.

I am outputting various fields from a table to a tab delimited text file.
(Thats the vendor requirement). One of those fields is a varchar field that
appears to have a 'tab' buried in the data...at least an extra 'tab' appears
in the out put file for some of the exported data. Is there a way I can
strip this 'tab' either as part of the DTS package - or by just running an
update statement against the database that cleans out the tab before the DTS
package runs?

Thank you.

#2

Maybe try something like:
update YourTable
set YourTextCol = replace(YourTextCol, Char(9), '')

-Sue

On Tue, 22 Mar 2005 17:15:29 -0600, "Steve"
<pezguy (AT) mn (DOT) rr.com> wrote:

Quote:

Hello

I'd like to thank everyone who has helped me in that past. You guys have
been great.

I am outputting various fields from a table to a tab delimited text file.
(Thats the vendor requirement). One of those fields is a varchar field that
appears to have a 'tab' buried in the data...at least an extra 'tab' appears
in the out put file for some of the exported data. Is there a way I can
strip this 'tab' either as part of the DTS package - or by just running an
update statement against the database that cleans out the tab before the DTS
package runs?

Thank you.

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

Stripping a 'TAB' from a text field

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

Stripping a 'TAB' from a text field - 03-22-2005 , 05:15 PM

Re: Stripping a 'TAB' from a text field - 03-22-2005 , 10:01 PM