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
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 we
On 10/02/12 01:02, Lunt, Bruce wrote:
> If you mean: ] that doesn't seem to work.
Probably depends on your emulator - in my new job (yes I've got a new
job!) they use Hostaccess, and } works just fine :-)
It sticks a } in the file that really is a @VM. If all else fails, you
can hopefully define
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 th
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 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 manipulate. We do this all the time with import
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 t