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
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
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:
Hi Joe,
Some things you can check for in your character fields before you append are:
CHR(10)
CHR(13)
CHR(2)
CHR(3)
CHR(4)
Replace those with a blank if they exist.
Also see if some of the character fields (like addresses) have a comma in them
that might be separating it into a column before you
'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
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
7 matches
Mail list logo