Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: update records in a file using shell script...
Top Forums UNIX for Dummies Questions & Answers update records in a file using shell script... Post 302286037 by new_learner on Tuesday 10th of February 2009 07:18:13 AM
Old 02-10-2009
Java update records in a file using shell script...
Hi,

I have a file with 6 columns. First 3 columns together make unique record. I have a variable ($v) which hold a value that is obtained by a caliculaion. I have to replace value in 5th columnn with the value of the variable ($v). The value $v is caliculated from col4 and col6 values.

Record1: A|B|C|1|2|3
Record2: D|E|F|4|5|6

I know to do this is a database:
update table table_name set col_5=x where col_1=A and col_2=B and col_3=C.

But I dont have a clue how to do it in a file. It seems like find and replace. But I have to find ABC record and replace 5th column of the record with value in $v.


Please suggest.

Thanks and Regards,
 

10 More Discussions You Might Find Interesting

1. Programming

Can we use write() to modify/update intermediate records in a file

Hi, I have a database (a simple .dat file) which has multiple records (structure datatype) in it. I would like to know if we can use write() system call to update/modify intermediate records in this file (using C). If so, could somegive give a code snippet of the same. :-) Thanks in advance... (2 Replies)
Discussion started by: maverix
2 Replies

2. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies

3. Shell Programming and Scripting

update file contents using shell script

Hi, I am having a file which contains as below Names(aaaa ,bbbb ,cccc ,dddd) now i want the file to be updated with new value 'eeee' as below Names(aaaa ,bbbb ,cccc ,dddd ,eeee) Is there a way to script this ? Thanks, (5 Replies)
Discussion started by: drams
5 Replies

4. Shell Programming and Scripting

unix shell script which inserts some records into a file located in remote servers...

All, I need to write an unix shell script which inserts some records into a file located in remote servers. * Get the input from the user and insert according the first row. It should be in ascending order. 123451,XA,ABA 123452,XB,ABB 123453,XC,ABC 123455,XE,ABE 123456,XF,ABF 123458,XG,ABG... (2 Replies)
Discussion started by: techychap
2 Replies

5. Shell Programming and Scripting

need shell script to read particular records from a file

i am reading an i/p file input.txt as below and want to read all filenames as in highlighted in bold below and put them in a different file output.txt. can someone help me with a shell script to do this? thanks in advance regards brad input.txt --------- START TYPE:OPT INIT_SEQ:01... (8 Replies)
Discussion started by: bradc
8 Replies

6. Shell Programming and Scripting

How to update an entry of another file in a Shell script?

Hi all, Say I have a shell script called update_password.sh - in this script I want to perform a task to update a specified entry of another file (e.g. users.passpords) update_password.sh #!/bin/bash -e PW_FILE_DIR="${A_DIR}/.../..." PW_FILE="users.passwords" I want to update the... (2 Replies)
Discussion started by: isaacniu
2 Replies

7. Shell Programming and Scripting

Shell script to read from a file and update remote server

Its a tough one and would appreciate any guidance for a script that i am trying to develop....Again I do understand its a complicated script and help would be greatly appreciated.... Thank you 1- Need to check for a file (in a certain location on a server) every 15 minute or so if it is there... (4 Replies)
Discussion started by: aavam
4 Replies

8. Shell Programming and Scripting

Shell script to update zone file

Hi folks, I have zone files at below path i want to modify their name i don't know how to do it, Can some can suggest some kind line technique. I give you detail I have domain ibphello.com host at ip address 10.2.2.1 and 50 plus domain are there /var/named/*.db. If i want to change... (0 Replies)
Discussion started by: learnbash
0 Replies

9. Shell Programming and Scripting

Update config file using shell script in Solaris 5.10

hi I need to update the value in config.txt value using shell script example: lets say a value in config.txt file is as SEQUENCE=1 after some iteration as the loop ends , the SEQUENCE should get update in the config.txt file with a new value of SEQUENCE=2. also , can anyone please help me... (7 Replies)
Discussion started by: ravidwivedi2288
7 Replies

10. Shell Programming and Scripting

Shell script to filter records in a zip file that contains matching columns from another file

Not sure if this is the correct forum for this question. I have two files. file1.zip, file2 Input: file1.zip col1, col2 , col3 a , b , 0:0:0:0:0:c436:9346:d40b x, y, 0:0:0:0:0:880:39f9:c9a7 m, n , 0:0:0:0:0:80c7:9161:fe00 file2.txt col1 c4:36:93:46:d4:0b... (1 Reply)
Discussion started by: anil.v
1 Replies

LEARN ABOUT OSX

tdbtool

TDBTOOL(8)																TDBTOOL(8)

NAME

       tdbtool - manipulate the contents TDB files

SYNOPSIS

       tdbtool

       tdbtool TDBFILE [COMMANDS...]

DESCRIPTION

       This tool is part of the samba(1) suite.

       tdbtool	a  tool  for  displaying and altering the contents of Samba TDB (Trivial DataBase) files. Each of the commands listed below can be
       entered interactively or provided on the command line.

COMMANDS

       create TDBFILE
	  Create a new database named TDBFILE.

       open TDBFILE
	  Open an existing database named TDBFILE.

       erase
	  Erase the current database.

       dump
	  Dump the current database as strings.

       cdump
	  Dump the current database as connection records.

       keys
	  Dump the current database keys as strings.

       hexkeys
	  Dump the current database keys as hex values.

       info
	  Print summary information about the current database.

       insert KEY DATA
	  Insert a record into the current database.

       move KEY TDBFILE
	  Move a record from the current database into TDBFILE.

       store KEY DATA
	  Store (replace) a record in the current database.

       show KEY
	  Show a record by key.

       delete KEY
	  Delete a record by key.

       list
	  Print the current database hash table and free list.

       free
	  Print the current database and free list.

       ! COMMAND
	  Execute the given system command.

       first
	  Print the first record in the current database.

       next
	  Print the next record in the current database.

       quit
	  Exit tdbtool.

CAVEATS

       The contents of the Samba TDB files are private to the implementation and should not be altered with tdbtool.

VERSION

       This man page is correct for version 3.0.25 of the Samba suite.

AUTHOR

       The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the  Samba	Team  as  an  Open
       Source project similar to the way the Linux kernel is developed.

																	TDBTOOL(8)
All times are GMT -4. The time now is 06:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy