On 09/02/12 17:03, Israel, John R. wrote:
I always read in the file and convert known problem characters to null then
process the file row by row.
Except if you do that *here* you won't be able to convert it row by row
... you'll have all the data in just one row !!!
Cheers,
Wol
On 09/02/12 16:55, Charlie Noah wrote:
Hi Josh,
I'd be happy to share my routines with you, if they would be of any use.
I have a program I use to load a csv file, and a subroutine which
converts back and forth between csv, dynamic and fixed width, either a
line at a time or an entire flat
On 09/02/12 16:47, Charlie Noah wrote:
I'm exporting from Excel and importing into jBASE. DCOUNTing on the
header line is an excellent idea. I'll give that a try. Since I'm using
a convert routine, if that fixes the problem, it will be fixed for any
spreadsheet I import.
It may very well be
Hi Wol,
Yes, many people have written their own routines, and the ones on
Pickwiki do most of the things mine do. Different strokes...
Regards,
Charlie
On 02-11-2012 5:22 AM, Wols Lists wrote:
On 09/02/12 16:55, Charlie Noah wrote:
Hi Josh,
I'd be happy to share my routines with you, if
Yes, parsing csv is a pain. So far it may just be easier to default
format the column, at least until I can get my distributor to fix the
spreadsheet. I save as tab delimited, and as long as I remember to
format first, everything is OK.
Thanks,
Charlie
On 02-11-2012 5:27 AM, Wols Lists
Windows uses a CR LF where UNIX uses just one (I forget which as I sit at
home). The other is converted to a FM. Stripping off the offending character
from Windows will still leave the file in a traditional FM delimited structure
that is easy to manipulate. We do this all the time with
On 11/02/12 15:38, Israel, John R. wrote:
Windows uses a CR LF where UNIX uses just one (I forget which as I sit at
home). The other is converted to a FM. Stripping off the offending
character from Windows will still leave the file in a traditional FM
delimited structure that is easy to