Re: Text file with abnormal delimiters

#1

Originally posted by Don

Quote:

Hi,
the text file is pasted below. The fields are between {: :} and i
need all
of them. Is there a way to take the only part between the
delimiters into
sql server.

{1:F01PTSATRE02XXX0000000000}{2:I999CKKBTRISXXXXN} {4:
:20:MICHAEL1906102024
:79:VSVSVSVSVSVSVS
-}{5:{TNG:}}

A solution I can recommend is to put the delimiters yourself, by looking
at the data layout of the text file. The way to do this is to choose the
TextFile as Source. In the properties. choose the Fixed field format n
hit next. Here you can place delimiters urself.
I hope this helps.

--
Posted via http://dbforums.com

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

Re: Text file with abnormal delimiters

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

Re: Text file with abnormal delimiters - 06-30-2003 , 08:01 PM