Groups | Blog | Home
all groups > sql server data mining > january 2004 >

sql server data mining : data in single cell / field of record has multiple rows


dave
1/21/2004 11:10:21 AM
data in single cell / field of record has multiple rows.

We are exporting data to text, however, there is a row
delimeter within cell and it carries into the text.

This of course is messing up the text file which needs to
be tab delimited with one {cr}{LF} per record.

Any ideas as to how to identify the 'row' delimieter with
Dave
1/21/2004 12:19:52 PM

multiple rows in single cell / field of record

We are exporting data to text, however, there is a row
delimeter within cell and it carries into the text.

This of course is messing up the text file which needs to
be tab delimited with one {cr}{LF} per record.

[quoted text, click to view]
within a cell / field within a record?????<<<
AddThis Social Bookmark Button