I'm importing some old data from windows. The data is exported from msAccess97 and some of the text fields have a carriage return of some sort in the middle. The same character seems to be used by access as the end of line for each record, so when I try and import it, I'm getting a truncated line, which then mucks up the next line
I wondered how one could check this eg: If I look at the file in a text editor with line numbers: 1 Doe|john|01/02/1950|some text in here saying something 2 Smith|Peter|19/02/1944|also some text 3 but is split onto a new line so the parser crashes 3 Brown|Michael|17/05/1966|but this line is ok ie: there is a character in there that here I've designated as [xx] which is intrepreted as a new line 1 Doe|john|01/02/1950|some text in here saying something 2 Smith|Peter|19/02/1944|also some text [xx] 3 but is split onto a new line so the parser crashes 3 Brown|Michael|17/05/1966|but this line is ok So my quesitoni is 'how to discover what the character is ?chr$(10)(13) and how to eliminate those before parsing. Thanks in anticipation. richard ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
