Re: Trying to fix Invalid CSV File

2008-08-06 Thread Roel Schroeven
Ryan Rosario schreef: Next time I am going to be much more careful. Tab delimited is probably better for my purpose, but I can definitely see there being issues with invisible tab characters and other weirdness. No matter which delimiter you use, there will always be data that includes that d

Re: Trying to fix Invalid CSV File

2008-08-05 Thread Ryan Rosario
On Aug 4, 1:56 pm, Larry Bates <[EMAIL PROTECTED]> wrote: > Ryan Rosario wrote: > > On Aug 4, 8:30 am, Emile van Sebille <[EMAIL PROTECTED]> wrote: > >> John Machin wrote: > >>> On Aug 4, 6:15 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > On Aug 4, 1:01 am, John Machin <[EMAIL PROTECTED]> wrot

Re: Trying to fix Invalid CSV File

2008-08-05 Thread John Machin
On Aug 5, 6:56 am, Larry Bates <[EMAIL PROTECTED]> wrote: > Ryan Rosario wrote: > > On Aug 4, 8:30 am, Emile van Sebille <[EMAIL PROTECTED]> wrote: > >> John Machin wrote: > >>> On Aug 4, 6:15 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > On Aug 4, 1:01 am, John Machin <[EMAIL PROTECTED]> wrot

Re: Trying to fix Invalid CSV File

2008-08-04 Thread Larry Bates
Ryan Rosario wrote: On Aug 4, 8:30 am, Emile van Sebille <[EMAIL PROTECTED]> wrote: John Machin wrote: On Aug 4, 6:15 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: On Aug 4, 1:01 am, John Machin <[EMAIL PROTECTED]> wrote: On Aug 4, 5:49 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: Thanks Emile!

Re: Trying to fix Invalid CSV File

2008-08-04 Thread Ryan Rosario
On Aug 4, 8:30 am, Emile van Sebille <[EMAIL PROTECTED]> wrote: > John Machin wrote: > > On Aug 4, 6:15 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > >> On Aug 4, 1:01 am, John Machin <[EMAIL PROTECTED]> wrote: > > >>> On Aug 4, 5:49 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > Thanks Emile!

Re: Trying to fix Invalid CSV File

2008-08-04 Thread Emile van Sebille
John Machin wrote: On Aug 4, 6:15 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: On Aug 4, 1:01 am, John Machin <[EMAIL PROTECTED]> wrote: On Aug 4, 5:49 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: Thanks Emile! Works almost perfectly, but is there some way I can adapt this to quote fields that

Re: Trying to fix Invalid CSV File

2008-08-04 Thread John Machin
On Aug 4, 6:15 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > On Aug 4, 1:01 am, John Machin <[EMAIL PROTECTED]> wrote: > > > On Aug 4, 5:49 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > > > > Thanks Emile! Works almost perfectly, but is there some way I can > > > adapt this to quote fields that con

Re: Trying to fix Invalid CSV File

2008-08-04 Thread Ryan Rosario
On Aug 4, 1:01 am, John Machin <[EMAIL PROTECTED]> wrote: > On Aug 4, 5:49 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > > > > > Thanks Emile! Works almost perfectly, but is there some way I can > > adapt this to quote fields that contain a comma in them? > > You originally said "I have a very larg

Re: Trying to fix Invalid CSV File

2008-08-04 Thread John Machin
On Aug 4, 5:49 pm, Ryan Rosario <[EMAIL PROTECTED]> wrote: > > Thanks Emile! Works almost perfectly, but is there some way I can > adapt this to quote fields that contain a comma in them? > You originally said "I have a very large CSV file that contains double quoted fields (since they contain co

Re: Trying to fix Invalid CSV File

2008-08-04 Thread Ryan Rosario
On Aug 3, 10:38 pm, Emile van Sebille <[EMAIL PROTECTED]> wrote: > Ryan Rosario wrote: > > I have a very large CSV file that contains double quoted fields (since > > they contain commas). Unfortunately, some of these fields also contain > > other double quotes and I made the painful mistake of forg

Re: Trying to fix Invalid CSV File

2008-08-03 Thread Emile van Sebille
Ryan Rosario wrote: I have a very large CSV file that contains double quoted fields (since they contain commas). Unfortunately, some of these fields also contain other double quotes and I made the painful mistake of forgetting to escape or double the quotes inside the field: 123,"Here is some, t

Trying to fix Invalid CSV File

2008-08-03 Thread Ryan Rosario
I have a very large CSV file that contains double quoted fields (since they contain commas). Unfortunately, some of these fields also contain other double quotes and I made the painful mistake of forgetting to escape or double the quotes inside the field: 123,"Here is some, text "and some quoted t