Sponsored Content
Full Discussion: Script asks to input data
Top Forums Shell Programming and Scripting Script asks to input data Post 302738797 by baris35 on Sunday 2nd of December 2012 10:00:48 PM
Old 12-02-2012
Script asks to input data

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


database2.txt
Code:
store4	product101	  40	£40
store3	product102	   9	£22
store2	product103	  91	£39
store2	product104	  12	£40
store1	product105	  10	£29
store2	product106	  5	£34
store9	product107	  90	£19
store3	product108	  29	£20
store4	product109	  19	£10
store8	product110	  13	£12
store5	product111	  28	£90

database3.txt
Code:
store1	product101	  440	£40
store2	product102	  20	£22
store2	product103	  30	£39
store6	product104	   6	£40
store6	product105    9	£29
store3	product106	   5	£34
store7	product107   90	£19
store9	product108	 209	£20
store8	product109	 109	£10
store4	product110  103	£12
store1	product111	 298	£90

I am not sure if this question should be placed under "shell script" topic.
I would appreciate if you could help me.

thanks in advance
Boris

Last edited by Franklin52; 12-03-2012 at 07:27 AM.. Reason: Please use code tags for data and code samples
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with Creation of Script to Input Separators in Data

Hi all, I have one problem that is preparing datas so I can run a script to extrat informations for my statistic reports. I receive some datas, that are informations mixed and I need to separate them to analyse. This is an exemple of datas:... (8 Replies)
Discussion started by: Alexis Duarte
8 Replies

2. Shell Programming and Scripting

Need script to take input from file, match on it in file 2 and input data

All, I am trying to figure out a script to run in windows that will allow me to match on First column in file1 to 8th Column in File2 then Insert file1 column2 to file2 column4 then create a new file. File1: 12345 Sam 12346 Bob 12347 Bill File2:... (1 Reply)
Discussion started by: darkoth
1 Replies

3. Shell Programming and Scripting

Reading passwd and need to use it multple times when script asks

Hi Gurus, I have one requirment.. I have written a script and it asks a registry passwd while performing some clearcase command. Now we are giving it manually. It's for one time run. We want to perform this for multiple times on multiple files throguh for loop.. means we need to pass the same... (3 Replies)
Discussion started by: raghu.iv85
3 Replies

4. Shell Programming and Scripting

Help to write a script or program to automatic execute and link input file data

Output file template format <input_file_name>a</input_file_name> <total_length_size>b</total_length_size> <log_10_length_size>c</log_10_length_size> Input_file_1 (eg. sample.txt) SDFSDGDGSFGRTREREYWW Parameter: a is equal to the input file name b is equal to the total length of... (2 Replies)
Discussion started by: perl_beginner
2 Replies

5. Shell Programming and Scripting

Echo date variable from data input to a script

Hi, I'm trying to make a script which you type the year, select the month and day and then create the date in the format 2010-12-7. #!/bin/bash dia () { echo " Seleccione el dia:" select file in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Salir do... (6 Replies)
Discussion started by: iga3725
6 Replies

6. Shell Programming and Scripting

adding data in input file if 2nd script output SUCCESS

Hi All, how can i edit my original data and add more data if my 2nd script outputs SUCESS? ex. input file: 1.txt nik,is,the 1script.sh if 2ndscript.sh output SUCCESS then i'm going to edit my input file and add data best,pogi.. sample outputdata. nik,is,the,best,pogi 2ndscript.sh... (3 Replies)
Discussion started by: nikki1200
3 Replies

7. Shell Programming and Scripting

Script to delete files with an input for directories and an input for path/file

Hello, I'm trying to figure out how best to approach this script, and I have very little experience, so I could use all the help I can get. :wall: I regularly need to delete files from many directories. A file with the same name may exist any number of times in different subdirectories.... (3 Replies)
Discussion started by: *ShadowCat*
3 Replies

8. Shell Programming and Scripting

Standardization of input source data files using shell script

Hi there, I'm a newbie in unix and am fishing for options related to how raw input data files are handled. The scenario, as I'm sure y'all must be very familiar with, is this : we receive upwards of 50 data files in ASCII format from various source systems - now each file has its own structure... (3 Replies)
Discussion started by: Prat Khos
3 Replies

9. UNIX for Dummies Questions & Answers

Inserting shell script input data automatically from a text file

Dear experts, I am new to linux programming. I have a shell script which i should run it on all my samples. I only define input and out put for this script. The inputs are 3 numbers(coordination numbers) which are available in a series of text file. Since i have a lots of samples, it takes a... (5 Replies)
Discussion started by: mohamadreza
5 Replies

10. Shell Programming and Scripting

How to get the shell script to read the .txt file as an input/data?

i have written my shell script in notepad however i am struggling to pass the data file to be read to the script the data file is of .txt format. My target is to run the shell script from the terminal and pass 3 arguments e.g. polg@DESKTOP-BVPDC5C:~/CS1420/coursework$ bash valsplit.sh input.txt... (11 Replies)
Discussion started by: Gurdza32
11 Replies
pac(8)							      System Manager's Manual							    pac(8)

NAME
pac - Outputs printer/plotter accounting information SYNOPSIS
pac [-cmrs] [-p price] [-P printer] [name] FLAGS
Sorts output according to the computed cost instead of alphabetically according to user. Groups all printing charges for the user speci- fied by name, without regard for the host machine from which printing was invoked. The dollar amount charged per unit of output specified by price. The default dollar amount charged is $0.02 per unit. Specifies the printer for which accounting records are produced. Alterna- tively, the system selects the printer named with the PRINTER environment variable, or the default printer lp0. Reverses the sorted order, so that records are listed alphabetically from z to a, or in descending order by computed cost when this flag is used with the -c flag. Writes printer accounting information to a summary file. You must specify the -P flag and printer name (or synonym) when you use this flag. Output is made to a file that is associated with the af entry for the specified printer in the /etc/printcap file. This file is located in the /usr/adm directory. The file name is usually the af accounting file name, with the letters _sum (summary) appended, for example: /usr/adm/lp2acct_sum. Accounting information is in three unheaded columns in the format: pages/feet machinename:username runs DESCRIPTION
When printer accounting is enabled in the /etc/printcap file, and you use the pac command in a shell script or from the standard input, pac outputs printer/plotter accounting records to the standard output for each user of the printer specified with the -P flag and printer name or for users specified with the name parameter. The unit used for printer accounting is the number of pages printed. However, for raster devices (such typesetters, and plotters) length in feet of print medium (film, for example) is the unit used. Output units are expressed both as the number of units used and the charge in dollars according to the price specified with -p flag and price amount per unit. The printer/plotter accounting output has the following column headings and format: Login pages/feet runs price chicken:rcb 19.00 2 $ 0.38 sardine:jmp 22.00 3 $ 0.44 hunch:lucy 53.00 12 $ 1.06 stovetop:suki 1.00 1 $ 0.02 newspaper:myralou 834.00 202 $ 16.68 wimbledon:nhk 69.00 20 $ 1.38 norfolk:sophie 184.00 17 $ 3.68 There are four fields, each with its own column heading, in each record of the default output produced by the pac command: 1) the machine from which the print command was entered and login name is entered in the Login column; 2) the number of pages or feet of paper output is entered in the page/feet column; 3) the number of times the printer was used is entered in the runs column; and 4) the cost computed at the default or specified price is entered in the price column. EXAMPLES
To print printer/plotter accounting information for all users of default printer lp0 to the standard output device, enter: /usr/sbin/pac Output is sorted alphabetically according to machine name and username. The number of printed pages or feet of output paper used and the charge per foot of paper or page is computed at the default dollar amount of $0.02 per page because no flags are specified. To write accounting records for printer printer1 in a summary file, enter the following line as a superuser or as adm: /usr/sbin/pac -Pprinter1 -s Summary information is written to the file /var/adm/printer1acct_sum. To produce accounting information for users lucy, suki and myralou for pages printed on printer putnam408, enter: /usr/sbin/pac -Pputnam408 lucy suki myralou FILES
Specifies the command path Accounting information summary file. Printer information summary file, where printcap symbol af defines the name of the accounting file. RELATED INFORMATION
Commands: acct(8), acctcms(8), acctcom(8), acctcon(8), acctmerg(8), acctprc(8), printcap(4), runacct(8) delim off pac(8)
All times are GMT -4. The time now is 07:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy