On 7/7/07, Jim Ault <[EMAIL PROTECTED]> 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 ;-)
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
