Re: Another Revolution Success Story

2004-10-17 Thread Alex Tweedly
Reviving an old thread from a few months ago At 15:02 01/07/2004 -0700, Richard Gaskin wrote: If CSV were consistently implemented CSV2TabNew would work excellently right out of the box, but since some CSVs escape quotes by doubling them I needed to add one line (see below) to also substitut

Re: Another Revolution Success Story

2004-07-01 Thread Richard Gaskin
Alex Tweedly wrote: At 00:25 01/07/2004 -0700, Richard Gaskin wrote: My post from 14 June 2002 with my own CSV2Tab function is at . Hats off to anyone who can improve it's speed, and a bottle of 12-year-old single malt to anyone who

Re: Another Revolution Success Story

2004-07-01 Thread Mark Wieder
Richard- Thursday, July 1, 2004, 12:25:54 AM, you wrote: RG> [Semi-OT link - US Gov. warns against MS Explorer: RG> ] Thanks for the link. I hadn't seen that one. Not that I use IE unless I absolutely *have* to, anyway... RG> My post from 14 June 2002 with

Re: Another Revolution Success Story

2004-07-01 Thread Alex Tweedly
At 00:25 01/07/2004 -0700, Richard Gaskin wrote: I asked around on this some time ago, including quite a few programmers far smarter than me. The best algorithm we could come up with was one which walks through the data char by char, keeping track of when it's in field data and when it leaves t

Re: Another Revolution Success Story

2004-07-01 Thread Richard Gaskin
Mark Wieder wrote: I really wish the csv format had never been invented. Separating fields with tabs works much better, and separating them with non-printing characters is better yet. Amen to that, brother. I guess the clue train doesn't stop in Redmond. ;) [Semi-OT link - US Gov. warns against MS

Re: Another Revolution Success Story

2004-06-30 Thread Mark Wieder
MisterX- Wednesday, June 30, 2004, 12:01:39 AM, you wrote: M> You mean my importer didn't work? No, I was just ranting in general. No worries. I'll go back to talking among myself now. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing l

RE: Another Revolution Success Story

2004-06-29 Thread MisterX
se Revolution > Subject: Re: Another Revolution Success Story > > > > On Jun 29, 2004, at 10:31 PM, Mark Wieder wrote: > > > I really wish the csv format had never been invented. Separating > > fields with tabs works much better, and separating them with > > no

Re: Another Revolution Success Story

2004-06-29 Thread Troy Rollins
On Jun 29, 2004, at 10:31 PM, Mark Wieder wrote: I really wish the csv format had never been invented. Separating fields with tabs works much better, and separating them with non-printing characters is better yet. This is why regex exists. Parsing of csv is probably best done with a matchText rout

Re: Another Revolution Success Story

2004-06-29 Thread Mark Wieder
MisterX- Tuesday, June 29, 2004, 1:52:18 PM, you wrote: M> It works for really overly simple csv files... I really wish the csv format had never been invented. Separating fields with tabs works much better, and separating them with non-printing characters is better yet. I'm getting tired of run

RE: Another Revolution Success Story - yet another release!

2004-06-29 Thread Alex Tweedly
At 22:42 29/06/2004 +0200, MisterX wrote: Hi everyone, Here you are, a pretty compliant CSV importer for RunRev... Sorry, it's not quite that simple :-) I see two problems 1. You have a small bug, in that you only replace commas within a quoted field in the first occurrence on each line. The secti

Re: Another Revolution Success Story

2004-06-29 Thread Pierre Sahores
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alex Tweedly Sent: Tuesday, June 29, 2004 03:51 To: [EMAIL PROTECTED] Subject: Re: Another Revolution Success Story At 18:02 28/06/2004 -0400, Troy Rollins wrote: On Jun 28, 2004, at 5:40 PM, Kurt Kaufman wrote: A physician in our area had a nee

Re: Another Revolution Success Story

2004-06-29 Thread Dave Cragg
At 3:21 pm -0500 29/6/04, Jim wrote: On Jun 28, 2004, at 10:01 PM, Brian Yennie wrote: Perhaps there's a good CSV-to-tab-delimited converter out there =). replace comma with tab in tData :-) If only it were that easy. But commas may occur within a field, in which case, the field is usually quote

RE: Another Revolution Success Story

2004-06-29 Thread MisterX
to:[EMAIL PROTECTED] Behalf Of Jim > Sent: Tuesday, June 29, 2004 22:22 > To: How to use Revolution > Subject: Re: Another Revolution Success Story > > > On Jun 28, 2004, at 10:01 PM, Brian Yennie wrote: > > > Perhaps there's a good CSV-to-tab-delimited converter

RE: Another Revolution Success Story - yet another release!

2004-06-29 Thread MisterX
Hi everyone, Here you are, a pretty compliant CSV importer for RunRev... Imports Excel CSV (with returns and quotes in the MS Xcel fields and all kinds of craps including filtering out linefeeds and the like that usualy slip in the process! Just took a while to clean that up! I didn't bother with

Re: Another Revolution Success Story

2004-06-29 Thread Jim
On Jun 28, 2004, at 10:01 PM, Brian Yennie wrote: Perhaps there's a good CSV-to-tab-delimited converter out there =). replace comma with tab in tData :-) (Can you replace comma with tab in url "file://path/to/file.csv" ??) Jim. ___ use-revolution mailing

RE: Another Revolution Success Story

2004-06-28 Thread MisterX
er credits. The database contains a few thousands NT events errors and codes reference. cheers Xavier > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Alex > Tweedly > Sent: Tuesday, June 29, 2004 03:51 > To: [EMAIL PROTECTED] > Subject:

Re: Another Revolution Success Story

2004-06-28 Thread Brian Yennie
yes, string handling is pretty good - but I'm surprised that Rev has no built-in support for CSV files. They are a pretty common interchange format, but handling the variations commonly found makes it non-trivial to do this properly - quoted fields, delimiter in quoted fields, escaped or double

Re: Another Revolution Success Story

2004-06-28 Thread Alex Tweedly
At 18:02 28/06/2004 -0400, Troy Rollins wrote: On Jun 28, 2004, at 5:40 PM, Kurt Kaufman wrote: A physician in our area had a need for an application which could easily import patient data from a text file (multiple rows of comma-delineated data). It was a simple task, using Revolution, to open

Re: Another Revolution Success Story

2004-06-28 Thread Brian Yennie
A physician in our area had a need for an application which could easily import patient data from a text file (multiple rows of comma-delineated data). It was a simple task, using Revolution, to open the file and read the data to a field. Subsequently a "model" card was cloned and the appropr

Re: Another Revolution Success Story

2004-06-28 Thread Marian Petrides
I was hoping the same thing, but wasn't bold enough to ask--until someone else did. Please do consider sharing them with us. M On Jun 28, 2004, at 8:59 PM, [EMAIL PROTECTED] wrote: Can you share the scripts you used to do this project? jack ___ use-re

Re: Another Revolution Success Story

2004-06-28 Thread Revinfo1155
Can you share the scripts you used to do this project? jack ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Another Revolution Success Story

2004-06-28 Thread Troy Rollins
On Jun 28, 2004, at 5:40 PM, Kurt Kaufman wrote: A physician in our area had a need for an application which could easily import patient data from a text file (multiple rows of comma-delineated data). It was a simple task, using Revolution, to open the file and read the data to a field. Subseq

Another Revolution Success Story

2004-06-28 Thread Kurt Kaufman
A physician in our area had a need for an application which could easily import patient data from a text file (multiple rows of comma-delineated data). It was a simple task, using Revolution, to open the file and read the data to a field. Subsequently a "model" card was cloned and the appropr