samedi 25 avril 2015

Import custom text format without separators


I would like import this .txt file format to SQL Server Table or to convert each block of text to pipe separated line.

Which tools or C# solution suggests you to resolve this issue?

Any suggestions would be appreciated.

Thank You.

=================
INPUT (.txt file)
=================
ID: 37
Name: Josephy Murphy
Email: jmurphy@email.com
Description: bla, bla, bla, bla...

ID: 38
Name: Paul Newman
Email: pnewman@email.com
Description: bla, bla, bla, bla...

:
:

=========================
OUTPUT (SQL Server Table)
=========================

ID | Name           | Email             | Description  
37 | Josephy Murphy | jmurphy@email.com | bla, bla, bla, bla...
38 | Paul Newman    | pnewman@email.com | bla, bla, bla, bla...

:
: 


Aucun commentaire:

Enregistrer un commentaire