Skip to Content
0
Former Member
Feb 17, 2006 at 12:46 PM

how to split these file

17 Views

hi,

i need to split the flat file. the flat file is a csv format. i will show u one example of the test data for the flat file. I know for csv file we can split it using comma but the real problem is that the text <b>'To, existing plumbing and mechanical engineering installations Take off gutter of any size; securely refix brackets; refix existing gutter, remaking joints metal gutter</b>

contains , ; into it, that is where i am facing a problem.

eg for the flat file:

50000283 112B To, existing plumbing and mechanical engineering installations Take off gutter of any size; securely refix brackets; refix existing gutter, remaking joints metal gutter 1 m 12/1/2005 6.04

how to seperate this these flat file