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