What I did with Rev last night

[Kay C Lan]

On 7/7/07, Jim Ault <JimAultWins at yahoo.com> wrote:
>
> I do the old way and paste into Excel using transpose.
> Only works with cr and tab delimited, though.
> Plus, I always have Excel open


Yes I'll put my hand up, I've done that enough times:-)

I have build a few transpose functions but always with more complex issues
> than the one Kay C. offered.  Don't know of a built-in transpose in Rev.
>
> Yes, I've already started complaining to the developer to pull his finger
out and add some real functionallity:

1) add a field where I can specify the delimiters, such as; tab, & ","

2) Make it work in both directions

3) Recognise certain single line entries and automatically parse it into two
lists and then go from there. At the top of the list would be the SQL
command

INSERT INTO table (clmn1, colmn2... colmn100,...) VALUES ("value1",
"value2",..." value 100"...)

4) Justification

5) More than two lists.

But he's making lame excuses about priorities, no one else has voted for it,
ROI, and actually spending time doing his real job ;-)