<div>
HI<br />
<br />
I didn't understand what you are trying to achieve?<br />
Are you just want to convert this file to a file with different delimiter for row and column?<br />
<br />
Do you intend to import it to SQL Servre?
</div>


<div>
HA! i guess that would have been helpful. Yes - trying to import the data into SQL 2k5 vis SSIS 2k5 ... here's a snippet of what the data looks like. If you copy and paste it out there's no line feeds or anything to break the data with except for those 12 colum headings.<br />
<br />
Thanks again!<br />

<pre><code class="code-10 nolinks" id="code-120302"><span>SMR_SEQ_NUM^SONAR_DATE^NEXT_SONAR_DATE^MIPT_DATE^NEXT_MIPT_DATE^CASING_INSPECTION_DATE^CAVERN_VOLUME^CAVERN_VOLUMEDUMMY^CREATE_DATE^CREATE_USERNAME^UPDATE_DATE^UPDATE_USERNAME^WELL_S</span>
<span>ERIAL_NUM^</span>
<span> </span>
<span>4125^19-MAR-1981^^^^^688583^688583^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972073^</span>
<span>4126^17-NOV-1987^^^^^718854^718854^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972073^</span>
<span>4127^10-NOV-1996^01-APR-2001^20-NOV-1996^01-APR-2001^09-NOV-1996^849731^849731^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972073^</span>
<span>4128^26-MAY-1981^^^^^762623^762623^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972074^</span>
<span>4129^13-NOV-1987^^^^^791063^791063^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972074^</span>
<span>4130^11-NOV-1996^01-APR-2001^20-NOV-1996^01-APR-2001^09-NOV-1996^897781^897781^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972074^</span>
<span>4131^26-MAR-1995^^^^^2489709^2489709^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972485^</span>
<span>4132^12-JUL-1995^^30-JUL-1995^01-APR-2000^^3410592^3410592^28-APR-1999^CONVALL^28-APR-1999^CONVALL^972485^</span>
<span>4133^^^10-NOV-2000^10-NOV-2005^^^^28-APR-1999^CONVALL^22-APR-2002^JOEB^972485^</span>
</code></pre>
</div>


<div>
can you upload the file , so I can convert it ?
</div>


<div>
You are going to have to manually add some row delimiter before you import. &nbsp;Or just rollup your sleeves and write some code to import using something like the Split function.
</div>


<div>
<div class="content wysiwyg-content">
I have a flat files and both the column and row delimiters are the same. Column headings are in the &quot;first&quot; line and then the row starts after that.<br />
<br />
pretty much there's 12 columns and a ^ inbetween each one - i'm trying to make it useful.<br />
<br />
anyone seen this before and if you did how did you fix it?<br />
<br />
thanks!<br />

</div>
</div>


I have a flat files and both the column and row delimiters are the same. Column headings are in the "first" line and then the row starts after that.

pretty much there's 12 columns and a ^ inbetween each one - i'm trying to make it useful.

anyone seen this before and if you did how did you fix it?

thanks!


Column &amp; Row Delimiters the same in a file

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Column &amp; Row Delimiters the same in a file

Column & Row Delimiters the same in a file