No-one seems to have done it, but here's my version of the code.
It's strange, I don't have a problem with CONTINUE and I don't even mind
IF SOMETHING ELSE THIS = THAT
which a lot of people really hate, but I just HAD to reverse the IF/CASE
statement order.
SUBROUTINE REXY(RECORD,TEXT)
The moment you start working in the engineering or manufacturing
industry where it is not uncommon to have double quotes embedded in a
field (i.e 5 1/4 Steel Bar) your code will bite you.
On 15/08/2012 23:24, David Wolverton wrote:
I've done this in the past by doing this:
SWAP DQUOTE WITH
I have double quotes in my product descriptions, and yes, they are a
pain! I also prepare Google Shopping data feeds for clients who don't
want to fight it themselves. This is why I prefer tab delimited with no
surround character. Unless you have tabs in your actual data, no
problems.
On 15/08/12 23:24, David Wolverton wrote:
I've done this in the past by doing this:
SWAP DQUOTE WITH @AM
Now, in theory, every EVEN attribute is a 'quoted' string - don't touch the
commas
Every ODD attribute is a 'non-quoted' string...
Double check me here in case I've lost it...
I actually enjoy reading wjhonson's puzzle posts with code examples,
etc. Maybe they can be flagged in the header so those of you who don't
want to read them can just skip them.
-Dianne
On 8/15/2012 5:49 PM, Tony Gravagno wrote:
Anyone getting paid to play guessing games? Dude, get to the
...@listserver.u2ug.org] On Behalf Of Dianne
Ackerman
Sent: Thursday, August 16, 2012 8:52 AM
To: U2 Users List
Subject: Re: [U2] CSV to Array
I actually enjoy reading wjhonson's puzzle posts with code examples,
etc. Maybe they can be flagged in the header so those of you who don't
want to read them can
LIKE
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne
Ackerman
Sent: Thursday, August 16, 2012 7:52 AM
To: U2 Users List
Subject: Re: [U2] CSV to Array
I actually enjoy reading wjhonson's puzzle posts
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, August 16, 2012 5:26 AM
To: U2 Users List
Subject: Re: [U2] CSV to Array
I have double quotes in my product descriptions, and yes, they are a
pain! I also prepare Google
Thanks for the support.
As I was working my way through the code I posted I noticed that if you
embedded in the quote is a check to see if the character we're on *and* the
next character are both double quotes.
But if that's true, than the initial check for a double quote to even get
*into*
It is tempting to use SWAP or CONVERT statements when parsing CSV, but
they never handle all the possible cases correctly. You have to look
at each character and keep track of state.
rex
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CSV to Array
The moment you start working in the engineering or manufacturing industry
where it is not uncommon to have double quotes embedded in a field (i.e 5
1/4 Steel Bar) your code will bite you.
On 15/08/2012 23:24, David Wolverton wrote
To: 'U2 Users List'
Subject: Re: [U2] CSV to Array
You can't have
3/4 Bolts in the data stream -- that would not work. So that means the
embedded has to be 'escaped' - usually by a \..
So you'd have 3/4\ Bolts or the like ... right?
In that case, you'd want to 'swap' out the \ for some other
: [U2] CSV to Array
On 15/08/12 23:24, David Wolverton wrote:
I've done this in the past by doing this:
SWAP DQUOTE WITH @AM
Now, in theory, every EVEN attribute is a 'quoted' string - don't
touch the commas
Every ODD attribute is a 'non-quoted' string...
Double check me here in case
Anyone getting paid to play guessing games? Dude, get to the point. If
this were presented as I need help I think many people would jump to
help. But presenting this as a Mensa challenge is just wasting
people's time.
T
Wjhonson wrote:
Rex Gozar uploaded this code, and someone (perhaps him)
There's no point in being abusive Tony. No one appreciates it.
-Original Message-
From: Tony Gravagno 3xk547...@sneakemail.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Wed, Aug 15, 2012 2:50 pm
Subject: Re: [U2] CSV to Array
Anyone getting paid to play guessing games? Dude
@listserver.u2ug.org
Subject: Re: [U2] CSV to Array
There's no point in being abusive Tony. No one appreciates it.
-Original Message-
From: Tony Gravagno 3xk547...@sneakemail.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Wed, Aug 15, 2012 2:50 pm
Subject: Re: [U2] CSV to Array
Anyone
: Wed, Aug 15, 2012 3:02 pm
Subject: Re: [U2] CSV to Array
At risk of starting a flame war, I agree with Tony. I need to tune my email
rules better.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent
Walker p...@gnosys.co.nz
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Aug 15, 2012 3:02 pm
Subject: Re: [U2] CSV to Array
At risk of starting a flame war, I agree with Tony. I need to tune my
email
rules better.
-Original Message-
From: u2-users-boun
I've done this in the past by doing this:
SWAP DQUOTE WITH @AM
Now, in theory, every EVEN attribute is a 'quoted' string - don't touch the
commas
Every ODD attribute is a 'non-quoted' string...
Double check me here in case I've lost it... but this should work ... seems
this would be faster
19 matches
Mail list logo
