On Sun, 30 Jan 2005 20:21:49 -0800, rasdj wrote:
> Thanks Jeremy, something like this would work:
>
> try:
> lines = [ line.replace(",\n;", ")\n;") for line in input ]
>
> If I could figgure out how to:
>
> IF ':' in line
> READ next line in
> lines = [ line.replace(",\n;", ")\n;") for line in
Thanks Jeremy, something like this would work:
try:
lines = [ line.replace(",\n;", ")\n;") for line in input ]
If I could figgure out how to:
IF ':' in line
READ next line in
lines = [ line.replace(",\n;", ")\n;") for line in input ]
output.write(str.join('', lines))
because there are lots of
On Sun, 30 Jan 2005 19:42:22 -0800, rasdj wrote:
> I have a lot of SQL to convert to postgres from oracle. I have most of the
> problems worked out except for this last bit. Many of my tables need the
> last comma replaced with a close parenthesis - they look like this:
>
> create table schema.ta
I have a lot of SQL to convert to postgres from oracle. I have most of
the problems worked out except for this last bit. Many of my tables
need the last comma replaced with a close parenthesis - they look like
this:
create table schema.table (
FLD000 NUMERIC(10,0) NOT NULL,
FLD001 CHAR(3) NOT NULL