Istudent Rana

Istudent Rana

  • 1.4k
  • 340
  • 83.6k

How do I read csv file which has data with line break.

Mar 27 2023 2:25 PM

How do i read and import piple delimited files to the database. File has data which has line break. 

I tried SQL Sever File Import wizzard as well as CSV Helper Library. Could you please help me how do I read the data successfully which has line break. 

example,

unique_id|name|notes
123|John|Subject: Meet the new interns
Dear team,
I'm happy to inform you of the commencement of our summer internship program. We recruited 10 interns
456|Rit|Subject: Meet the new interns
Dear team,
I'm happy to inform you of the commencement of our summer internship program. We recruited 10 interns


Answers (4)