Yes, my file has many rows (file has about 3 GB). Each row is separated (ended) by "VrVrVo". Each field (but last one) within one row is separated by "StVlRy". No other delimiters, escapers etc are used. Regards, Stepan
On Jan 31, 11:22 am, Thomas Mueller <[email protected]> wrote: > Hi, > > I don't understand. Your CSV file does have multiple rows, right? How > are those rows separated? > > Regards, > Thomas > > On Fri, Jan 30, 2009 at 7:00 PM, t603 <[email protected]> wrote: > > > Hello, > > > Although CSVWRITE supports lineSeparatorString, CSVREAD does not > > support it. Can I ask You to add it? I am usimg Sybase (or Microsoft) > > BCP command line utility, which does not support quoting of string > > values. So in case there is newline in string value, I have to use > > weird field and line separators like "SrVlRy" and "VrVrVo" - in other > > words combination of characters, which really do not appear anywhere > > in the outputed CSV file. But, in this case I am not able to load such > > file into H2, because CSVREAD does not support lineSeparatorString. I > > have to translate these CSV files using gAWK scripts for example > > before loading into H2. > > > Thank You for understanding. Stepan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
