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