HI

I'm importing to sql from some spreadsheets.

I'm saving the data as tab delimited as going straight from the excel sheet was causing many issues.

My problem is that some data cells contain a lot of text. This displays ok in excel with formatting new lines etc. But when I save as tab delimited all that formatting is lost and I wanted to save each line a s a separate note.

Any ideas on how I can save that formatting or split up the text. (here's an example with formatting )

26/02/16 JP RE said get surveyor or Steve to inspect and report back.
25/02/16 JP Emailed KM to ask if the fencers have put in their report
25/02/16 JP Kerrie emailed: cannot re-band if council say no. Her best chance is MX and there's a 2 bed ground floor flat in xxxx she could go for. Kerrie suggested speaking to Jemma or Sally as they'll know her band and where's she's coming on the bidding list.


Any way I can split on the date string pattern ?


Thanks