Skip site navigation (1) Skip section navigation (2)

Re: AWK script

From: glenn <glenn(at)davy(dot)net(dot)au>
To: Atif Jung <atifjung(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: AWK script
Date: 2010-04-13 14:02:24
Message-ID: 1271167344.5362.126.camel@baldur (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Atif
from one  non expert to another, does this help:

glenn(at)baldur:~$ cat x
ORDER BY var[x,y]
ORDER BY var[2,5]
ORDER BY var[Z,Q]
ORDER BY var[ABC,DEF]

glenn(at)baldur:~$ sed 's/ORDER\ BY\ var\[\(.*\),\(.*\)\]/ORDER\ BY\
SUBSTRING(var\ FROM\ \1\ FOR\ \2\)/' x
ORDER BY SUBSTRING(var FROM x FOR y)
ORDER BY SUBSTRING(var FROM 2 FOR 5)
ORDER BY SUBSTRING(var FROM Z FOR Q)
ORDER BY SUBSTRING(var FROM ABC FOR DEF)

So, tahts with sed, haven't tried awk yet. let you know if I come up
with something.


On Tue, 2010-04-13 at 14:30 +0100, Atif Jung wrote:
> I've been tasked with writing a script which will automatically update
> our exisitng INFORMIX code to include POSTGRES compliant equivalent
> code. My awk skills are pretty basic to say the least, but  I've
> managed to write some of the rules in an awk script, but am having
> difficulty with the following 
>  
>  
> CHANGE INFORMIX CODE
>  
> ORDER BY var[x,y];
>  
> TO POSTGRES CODE
>  
> ORDER BY SUBSTRING(var FROM x FOR y);
>  
> my problem is var[x,y] is completely variable. How do I check for that
> in AWK/SED? Is it even possible?
>  
> Thanks
>          
> 
> 



In response to

  • AWK script at 2010-04-13 13:30:29 from Atif Jung

Responses

pgsql-novice by date

Next:From: Atif JungDate: 2010-04-13 14:41:05
Subject: Re: AWK script
Previous:From: Atif JungDate: 2010-04-13 13:30:29
Subject: AWK script

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group