UNIX for Dummies Questions & Answers

i am having one file which is of CSV format with two fields client_id and client_nbr.The sample data is lke below

ABC,1250
CDE,1520
EFG,1000
PQR,1800

The client nbr for these clients change frequently.So i want to create one lookup file every week for the changed client and run a script sothat in original CSV the client nbr will change.
Say for week1 the client nbr for two clients changed

ABC,1000
PQR,1500

This will be placed in a CSV file(lookup file)

After running the script the output in the original file should be


ABC,1000
CDE,1520
EFG,1000
PQR,1500

Please help me writing the script.

- Script should not touch/move/edit original file.
- When you run script it should save original file and then work on copy of it and paste it back as original.
- Get the contents of original file using cat, strings command and compare with it current changes.(Use for loop)
- If there is a change then replace new value with old one otherwise do nothing.

- nilesh

Code:

awk -F, -v OFS=, '
    # load array with changed client numbers
    NR==FNR { client_num[$1]=$2; next }
    # if this client has changed, print updated record
    $1 in client_num { print $1,client_num[$1]; next }
    # otherwise just print the current record
    1
' file_with_changes originalfile > newfile

Hi,

Since u are running the script every week , i think the below scritp might help u.

f1--The first column ie ABC etc
f2--The second column ie 1200 etc

cat file | cut -d ',' -f1 > file1 # This will take the first column in file1
cat file | cut -d ',' -f2 > file2 # This will take the second column in file2
paste -d, file1 file2 # This would paste first and second column with commas

Cheers!
Jegan