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