mar, 16 Feb 2010, Alex Rufon skribis:
> [data=.4 5 $ ;:'aa bb cc dd'
> +--+--+--+--+--+
> |aa|bb|cc|dd|aa|
> +--+--+--+--+--+
> |bb|cc|dd|aa|bb|
> +--+--+--+--+--+
> |cc|dd|aa|bb|cc|
> +--+--+--+--+--+
> |dd|aa|bb|cc|dd|
> +--+--+--+--+--+
> '''',~ each '''', each data
> +----+----+----+----+----+
> |'aa'|'bb'|'cc'|'dd'|'aa'|
> +----+----+----+----+----+
> |'bb'|'cc'|'dd'|'aa'|'bb'|
> +----+----+----+----+----+
> |'cc'|'dd'|'aa'|'bb'|'cc'|
> +----+----+----+----+----+
> |'dd'|'aa'|'bb'|'cc'|'dd'|
> +----+----+----+----+----+
> then I'll comma separate this data and eventually getting this result:
> INSERT INTO test_table (f1,f2,f3,f4,f5) VALUES ('aa','bb','cc','dd','aa')
> INSERT INTO test_table (f1,f2,f3,f4,f5) VALUES ('bb',cc','dd','aa','bb')
> INSERT INTO test_table (f1,f2,f3,f4,f5) VALUES ('cc','dd','aa','bb','cc')
> INSERT INTO test_table (f1,f2,f3,f4,f5) VALUES ('dd','aa','bb','cc','dd')
Why didn't you insert these data directly from J using odbc?
--
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
