Search Results

cskumar to be honest, I didn't understand very well your last explanation. However, have you thinked about inserting all the informations in database's tables and do the joins inside the db? As I...

If you don't have multiple occurrences of the same variable "$n" in file1, you can substitute the "gsub" command with "sub": this may increase performances a bit. Note that, in this manner, the...

awk -F'|' '
BEGIN { getline in_stmt < "file1"; }
{
nVars=split($0, values);
out_stmt=in_stmt;
for (i=1; i<=nVars; i++) {
gsub("\\$" i, values[i], out_stmt);
}...