Search Results

Already did, now even more.
Thanx Scrutinizer

Thanks Rudi, execatly what I need.
Best regards,
Perry

Input files look like this:

"Billing Country","Invoice Type","Settlement Type","Bill-to Account Number","Control Number","Invoice Number","Invoice Date","Due Date","Bill
to Currency","Total...

Hi,
I'd like to find the values of certain fields in multiple csv files stored in 1 directory
based upon an input search string.
An fgrep returns the complete record, I only want certain fields....

Hi Don,
Many thanks.
I just ran it on the actual xml template (Scribus sla file) and it works !
Great job.
Many thanks for your help.
:b:

Unfortunately I get an error:
awk 'FNR==NR {for (i=2; i<=NF; i++) a["%VAR_"$1"_"i-1"%"]=$i;next}
{for(i=1;i<=NF;i++) printf a[$i]? a[$i]" " : $i" "; print ""}' FS=" *, *" prices.csv FS="[ \t]"...

Hi Don,
Thanks for your offer. Would be great to get it all in awk.
Here's an example template file:

Rateband prices per 01-01-2012
=========================================...

Wow, that's cool
I guess I can pipe to sed and do the magic now :cool:
Many thanks for your help !

You might try: tr
Example:

tr '\n' ';' < input > output

I have a flat file (template) where I want to replace variables based upon a value in another file (csv).
The variables in the template are named %VAR_X_z%
The values are in the csv file and X is...