Script asks to input data

baris35 · #1 12-02-2012

Hi,

I have three different files about a warehouse's stock status.

Each file shows storage locations, stored product names, quantity of the part and at last column, its price.
When there is a change in price, I open those files one by one, search related product name at each row and change the price manually.

What I would like to have is a a script to make the task easier: It will ask me to enter which product name I am looking for. When I enter the product name in terminal panel, it will ask me the second question, the new price. When I enter new price in same format, it will replace the old one by the new one in all three files.

Here are my sample files:

database1.txt

Code:

store1	product101	  440	£40
store2	product102	  300	£22
store2	product103	  210	£39
store2	product104	  120	£40
store1	product105	  100	£29
store1	product106	     5	£34
store3	product107	    90	£19
store3	product108	  209	£20
store4	product109	  109	£10
store4	product110	  103	£12
store5	product111	  298	£90

Yoda · #2 12-02-2012

Is this homework?

baris35 · #3 12-02-2012

Quote:

Originally Posted by bipinajith

Is this homework?

hi,
I was graduated fifteen years ago

Yoda · #4 12-02-2012

Quote:

Originally Posted by baris35

hi,
I was graduated fifteen years ago

I'm sorry. try this code:-

Code:

#!/bin/ksh

echo "Enter product name: "
read pname
echo "Enter product price: "
read price
price=$( echo "\0243"$price )  # Formatting price with pound sign.

for file in database1.txt database2.txt database3.txt
do
        awk -v PN=$pname -v PR=$price ' { if($2==PN) $4=PR; print $0; } ' $file > tmp; mv tmp $file;
done

baris35 · #5 12-03-2012

Quote:

Originally Posted by bipinajith

I'm sorry. try this code:-

Code:

#!/bin/ksh

echo "Enter product name: "
read pname
echo "Enter product price: "
read price
price=$( echo "\0243"$price )  # Formatting price with pound sign.

for file in database1.txt database2.txt database3.txt
do
        awk -v PN=$pname -v PR=$price ' { if($2==PN) $4=PR; print $0; } ' $file > tmp; mv tmp $file;
done

Thanks a lot Sir,
I will test it and let you know in this page.

regards
Boris

---------- Post updated 12-03-12 at 09:03 PM ---------- Previous update was 12-02-12 at 10:42 PM ----------

Quote:

Originally Posted by bipinajith

I'm sorry. try this code:-

Code:

#!/bin/ksh

echo "Enter product name: "
read pname
echo "Enter product price: "
read price
price=$( echo "\0243"$price )  # Formatting price with pound sign.

for file in database1.txt database2.txt database3.txt
do
        awk -v PN=$pname -v PR=$price ' { if($2==PN) $4=PR; print $0; } ' $file > tmp; mv tmp $file;
done

Hi,
Thank you so much! That is perfect!
By running your script, I have edited tens of files in second.

regards
Boris

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
adding data in input file if 2nd script output SUCCESS	nikki1200	Shell Programming and Scripting	3	10-27-2011 07:46 PM
Echo date variable from data input to a script	iga3725	Shell Programming and Scripting	6	12-07-2010 12:00 PM
Help to write a script or program to automatic execute and link input file data	perl_beginner	Shell Programming and Scripting	2	12-03-2010 11:54 AM
Need script to take input from file, match on it in file 2 and input data	darkoth	Shell Programming and Scripting	1	11-03-2009 10:53 AM
Help with Creation of Script to Input Separators in Data	Alexis Duarte	Shell Programming and Scripting	8	06-10-2009 09:56 AM

The Following User Says Thank You to Yoda For This Useful Post:
baris35 (12-02-2012)