Visit Our UNIX and Linux User Community


Updating the input file


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Updating the input file
# 1  
Old 05-29-2009
Updating the input file

Hi Experts,

I have a requirement.

input_file.txt

Emp_no Emp_Name Salary
100 A 1000
101 B 2500
102 C 1500

I want to update the salary field of a record based on a condition(like emp_no=100).

Presently I am using a temperory file for updation.

Eg:
read the input_file
if $1=100
update salary + 1200
else if $1=101
update salary + 1000
...
...
output to a temp file.
move temp file input_file.txt
remove temp file
(I am passing the input_file as the first argument & emp_no as the second argument)
I am scheduling the script using crontab.Crotab entry is like this.

23 02 * * 1-5 /usr/bin/sh /isscrmetl/script_test/file_upd.sh input_file.txt 100
23 02 * * 1-5 /usr/bin/sh /isscrmetl/script_test/file_upd.sh input_file.txt 101
23 02 * * 1-5 /usr/bin/sh /isscrmetl/script_test/file_upd.sh input_file.txt 102

Since the script is executing parallely it is not giving the desired output.

Can we update the table without using a temperory file.

Thanks,
Prabhu
# 2  
Old 05-29-2009
Please read the forum rules regarding cross-posting.

Previous Thread | Next Thread
Test Your Knowledge in Computers #616
Difficulty: Medium
There is no separate char data type in Python.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Updating in file

hi, i have an csv(which is a month's log file containing userid and log in date ) file which has to be appended to another file say master.log.I need to compare the next month's log data to master.log file .In case, there is new log date for userid it has to get updated in master.log file or i... (2 Replies)
Discussion started by: preema
2 Replies

2. Homework & Coursework Questions

Removing punctuations from file input or standard input

Just started learning Unix and received my first assignment recently. We haven't learned many commands and honestly, I'm stumped. I'd like to receive assistance/guidance/hints. 1. The problem statement, all variables and given/known data: How do I write a shell script that takes in a file or... (4 Replies)
Discussion started by: fozilla
4 Replies

3. Shell Programming and Scripting

Read input files and merge them in given order and write them to input one param or one file

Dear Friends, I am looking for a shell script to merge input files into one file .. here is my idea: 1st paramter would be outfile file (all input files content) read all input files and merge them to input param 1 ex: if I pass 6 file names to the script then 1st file name as output file... (4 Replies)
Discussion started by: hyd1234
4 Replies

4. Shell Programming and Scripting

Help updating a file

I can not seem to figure out how to update the attached match.txt column 2 using update.txt. However, only the text before the period in updat.txt appears in match.txt. For example, in update.txt NM_001613.2 matches NM_001613 in match.txt, so is it possible to update the record in match.txt to... (8 Replies)
Discussion started by: cmccabe
8 Replies

5. 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

6. 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

7. UNIX for Dummies Questions & Answers

Updating the input file

Hi Experts, I have a requirement. input_file.txt Emp_no Emp_Name Salary 100 A 1000 101 B 2500 102 C 1500 I want to update the salary field of a record based on a condition(like emp_no=100). Presently I am using a temperory file for updation. Eg: read the input_file if $1=100... (1 Reply)
Discussion started by: prabhutkl
1 Replies

8. Shell Programming and Scripting

Updating the input file

Hi Experts, I have a requirement. input_file.txt Emp_no Emp_Name Salary 100 A 1000 101 B 2500 102 C 1500 I want to update the salary field of a record based on a condition(like emp_no=100). Presently I am using a temperory file for updation. Eg: read the input_file if $1=100... (1 Reply)
Discussion started by: prabhutkl
1 Replies

9. Shell Programming and Scripting

Reading specific contents from 1 input files and appending it to another input file

Hi guys, I am new to AWK and unix scripting. Please see below my problem and let me know if anyone you can help. I have 2 input files (example given below) Input file 2 is a standard file (it will not change) and we have to get the name (second column after comma) from it and append it... (5 Replies)
Discussion started by: sksahu
5 Replies

10. Shell Programming and Scripting

awk updating one file with another, comparing, updating

Hello, I read and search through this wonderful forum and tried different approaches but it seems I lack some knowledge and neurones ^^ Here is what I'm trying to achieve : file1: test filea 3495; test fileb 4578; test filec 7689; test filey 9978; test filez 12300; file2: test filea... (11 Replies)
Discussion started by: mecano
11 Replies

Featured Tech Videos