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