On Mon, Apr 17, 2023 at 12:04 PM Joe Yoder wrote:
> I thought I could simply preprocess the file and change each occurrence of
> a single line feed with a comma but when I look at functions available I
> suspect it will be painfully slow.
>
> Any ideas appreciated,
>
You ought to try it before r
You can use notepad ++ find and replace to preprocess the file.
Rick Q
quilh...@gmail.com
On Mon, Apr 17, 2023 at 12:04 PM Joe Yoder wrote:
> Alan and all,
> I have researched the problem records and find that they have line feed
> characters without a leading carriage return. This results f
Alan and all,
I have researched the problem records and find that they have line feed
characters without a leading carriage return. This results from the
operator hitting a return in a notes field of the accounting package I am
using.
Apparently Excel import insists on a combination of carriage
This challenge may arise if the delimiter is also a value in the field
content such as a comma.
Ideally it would be good to use a delimiter which isn't ever used in the
content such as the pipe symbol.
Trust this should solve your challenge.
--
Cheers!!!
*Srikanth Bhandari*
Email: srikanth.bhan
want it to.
-Philip B.
-- Original Message --
From: Joe Yoder
To: profoxt...@leafe.com
Subject: .csv file imports to VFP
Date: Sat, 15 Apr 2023 22:35:14 -0400
I have an accounting system data dump that I export each year at tax time,
I think I have always had a few records that
'Append from' has always been bombproof in my experience, as long as what
you're giving it is correct. Do those problem rows have any weird non ASCII
characters ir anything?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Sun, 16 Apr 2023, at 3:35 AM, Joe Yoder wrote:
> I have an acco
Joe, you may consider using the CSVProcessor class at
https://github.com/atlopes/csv.
On Sun, Apr 16, 2023 at 3:36 AM Joe Yoder wrote:
> I have an accounting system data dump that I export each year at tax time,
> I think I have always had a few records that got mangled but this year I
> would l
I have an accounting system data dump that I export each year at tax time,
I think I have always had a few records that got mangled but this year I
would like to solve the problem.
My preferred technique is to create a cursor with the fields I need to
import along with any required place holders.
8 matches
Mail list logo
