Sponsored Content
Top Forums Shell Programming and Scripting How to change values in datafile from source file Post 302448394 by luna_soleil on Thursday 26th of August 2010 02:13:00 AM
Old 08-26-2010
Oh sorry guys, I should be using nawk instead of awk. Pardon my silliness :P.

I will try once again your scripts and let you know the outcome :-)

---------- Post updated at 10:13 PM ---------- Previous update was at 09:57 PM ----------

Hey pravin27 and rdcwayx,

I tried all the 3 scripts and they work like magic!

Code:
echo "Enter filename that you want to modify"
read destfile
nawk 'NR==FNR{a[$1]=$2;next} {if ($2 in a) {$4= a[$2]}}1' source.txt FS="\"" OFS="\"" $destfile > tempfile
mv -f tempfile $destfile

Code:
echo "Enter filename that you want to modify"
read destfile
nawk 'NR==FNR{a[$1]=$2;next} { if ($2 in a) {print $1 FS $2 FS $3 FS a[$2] FS $5} else {print $0}}' source.txt FS="\"" $destfile > tempfile
mv -f tempfile $destfile

Code:
echo "Enter filename that you want to modify"
read destfile
nawk 'NR==FNR{a[$1]=$2;next} {for (i in a) if (match($0,i)) $3="v=\"" a[i] "\""}1' source.txt $destfile > tempfile
mv -f tempfile $destfile

Thank u so much guys for making my life easier. XOXOXO ;-)
 

10 More Discussions You Might Find Interesting

1. UNIX Desktop Questions & Answers

Change time source?

I need to change the time on my SUN box, it is five minutes fast. (4 Replies)
Discussion started by: michelemcdonald
4 Replies

2. Shell Programming and Scripting

Change the Values in a file

I have a data file. I want to write a shell script that reads a data file and reads position 19 thru 24. if the data in those fields is 002006, than it should change it to 002007. example: hello world hello 002006 hello world hello world hello world hello 002005 hello world hello world... (6 Replies)
Discussion started by: rudoraj
6 Replies

3. Shell Programming and Scripting

Combine a datafile with Master datafile, emergent!

Hi guys, my supervisor has asked me to solve the problem in 7 days, I've taken 3 days to think about it but couldn't figure out any idea. Please give me some thoughts with the following problem, I have index.database that has only index date: 1994 1995 1996 1997 1998 1999 I have... (6 Replies)
Discussion started by: onthetopo
6 Replies

4. Shell Programming and Scripting

to parse (or grep) a number from a datafile and write it to tab limited file

Hi All, I have a folder that contain 100's of subfolders namely: Main folder -> GHFG - Subfoders ->10 100 234 102 345 .. .. ... (2 Replies)
Discussion started by: Lucky Ali
2 Replies

5. Shell Programming and Scripting

How do I change the values in a file?

TRASH_PATH:~/deleted/ MAX_VERSIONS:5 FILE_MAX_SIZE:1024 FOLDER_MAX_SIZE:8096 TRASH_MAX_SIZE:1024 LOG_MAX_SIZE:100 how do i change the value of TRASH_MAX_SIZE to 2040 using the script? the filename is config.ini please advice Use code tags, ty. (5 Replies)
Discussion started by: classic
5 Replies

6. UNIX for Dummies Questions & Answers

Iptables to change source IP

Hey everyone! I am trying to configure iptables/netfilter so that all traffic coming from a certain port (8001) has its source ip re-written as a different ip. Can this be done? Basically its a possible workaround for another issue I'm having with a multihomed server. SNMP data is coming in on... (3 Replies)
Discussion started by: msarro
3 Replies

7. Shell Programming and Scripting

sorting the datafile in an order given in second datafile

Hi, I have two files: first input file is having 7-8 columns, and second data file is like I want to arrange my datafile1 in the order given in second data file, by comparing the seconddatafile with the second column of first file and print the entire line....also if any... (2 Replies)
Discussion started by: CAch
2 Replies

8. Shell Programming and Scripting

How to change certain values in a file

Hi all, i need help to replace certain values in a file. I need the script to check and match the ID and exNum1. if match, values in $3 (file2.txt) need to replace the value for 'START' (file1.txt) for each match. The sample structure is like this:- File1.txt ID P_6 START ... (4 Replies)
Discussion started by: redse171
4 Replies

9. Shell Programming and Scripting

Change values in .conf file with a script

This is my first time posting here...so be gentle. Suppose I have a test.conf file that contains a value such as a IP. I would like to be able to use the Dialog Utility in Linux to allow me to enter the new IP in a Dialog form...and the results get saved into the test.conf file in the place... (4 Replies)
Discussion started by: calahanp
4 Replies

10. UNIX for Beginners Questions & Answers

How to change values in xml file?

I have xml file like below, i want change the values at default-value place of each argument name using shell script. like where argument name= protocol and default-value=tcp, where argument name =port and default-value= 7223, where argument name = username and default-value=test, example ... (12 Replies)
Discussion started by: s1s2s3s4
12 Replies
RABBIT(1)							      rabbit								 RABBIT(1)

NAME
rabbit - presentation tool using RD, simple text format SYNOPSIS
rabbit [options] [SOURCE_INFOS] DESCRIPTION
Theme -I, --include=PATH Add [PATH] to load path. -t, --theme=THEME Use [THEME] as theme. (default) --comment-theme=THEME Use [THEME] for comment. () --allotted-time=TIME Use [TIME] as allotted time. () Source -T, --type=TYPE Specify source type as [TYPE]. Select from [auto, argf, file, memory, slideshare, uri]. Note: case insensitive. (auto) When select ARGF specify none (get from STDIN) or [FILE_NAMES] as [SOURCE_INFOS]. When select File specify [FILENAME] as [SOURCE_INFOS]. When select Memory specify [FILENAME_OR_NOT] as [SOURCE_INFOS]. When select SlideShare specify [USER] and [TITLE] as [SOURCE_INFOS]. When select URI specify URI as [SOURCE_INFOS]. -e, --encoding=ENCODING Specify source encoding as [ENCODING]. (auto) -B, --base=BASE Specify base URI or path of source as [BASE]. (auto) Initial state -f, --[no-]full-screen Toggle full screen mode. (off) --[no-]index-mode Toggle index mode. (off) Size -g, --geometry=GEOMETRY Set window geometry [GEOMETRY]. Format: WIDTHxHEIGHT+X+Y (nil) -w, --width=WIDTH Set window width to [WIDTH]. (800) -h, --height=HEIGHT Set window height to [HEIGHT]. (600) -S, --size=WIDTH,HEIGHT Set window width and height to [WIDTH] and [HEIGHT]. (800,600) Save -s, --save-as-image Save as image and exit. -i, --saved-image-type=TYPE Specify saved image type as [TYPE]. (png) -bBASE_NAME, Specify saved image base name as [BASE_NAME]. --saved-image-base-name (Title of slide) --saved-image-basename --[no-]output-html Output HTML for viewing saved images. (false) --[no-]output-index-html Output index HTML for navigating slides. (false) --rss-base-uri=URI Specify base URI of RSS as [URI]. RSS is generated only when HTML is output. () --source-filename=FILENAME Specify source filenam as [FILENAME]. () Print -p, --print Print and exit. -o, --output-filename=FILENAME Specify printed out filename as [FILENAME]. (#{Title of slide}.pdf) --slides-per-page=SLIDES Set slides per page. (1) --[no-]draw-scaled-image Draw scaled image. Better look for displaying but lesser look for printing. (true) Paper --paper-width=WIDTH Set paper width to [WIDTH] Pt. (landscape A4 width) --paper-height=HEIGHT Set paper height to [HEIGHT] Pt. (landscape A4 height) --paper-size=WIDTH,HEIGHT Set paper width and height to [WIDTH] Pt and [HEIGHT] Pt. (landscape A4 size) Margin --margin-left=MARGIN Set left margin for slides per page mode print. (auto) --margin-right=MARGIN Set right margin for slides per page mode print. (auto) --margin-top=MARGIN Set top margin for slides per page mode print. (auto) --margin-bottom=MARGIN Set bottom margin for slides per page mode print. (auto) --margin={ [ALL] | [TOP_BOTTOM],[LEFT_RIGHT] | [TOP],[LEFT_RIGHT],[BOTTOM] | [TOP],[RIGHT],[BOTTOM],[LEFT]} Set margin for slides per page mode print. --page-margin-left=MARGIN Set left page margin. (auto) --page-margin-right=MARGIN Set right page margin. (auto) --page-margin-top=MARGIN Set top page margin. (auto) --page-margin-bottom=MARGIN Set bottom page margin. (auto) --page-margin={[ALL]|[TOP_BOTTOM],[LEFT_RIGHT]|[TOP],[LEFT_RIGHT],[BOTTOM]|[TOP],[RIGHT],[BOTTOM],[LEFT]} Set page margin. dRuby --[no-]use-druby Specify whether to use dRuby. (true) --druby-uri=URI Specify dRuby URI. (druby://127.0.0.1:10101) --[no-]output-druby-uri Specify whether to output dRuby URI. (false) SOAP --[no-]use-soap Specify whether to use SOAP. (false) --soap-host=HOST Specify SOAP host as [HOST]. (0.0.0.0) --soap-port=PORT Specify SOAP port as [PORT]. (10103) XML-RPC --[no-]use-xmlrpc Specify whether to use XML-RPC. (false) --xmlrpc-host=HOST Specify XML-RPC host as [HOST]. (0.0.0.0) --xmlrpc-port=PORT Specify XML-RPC port as [PORT]. (10104) Server --[no-]server Specify whether to run as server. (false) Public level --public-level=LEVEL Specify public level. Select from the following: [ strict, move, read-size, change-size, size, read-source, change-source, source, control, all ] (all) Comment --comment-source=FILE Deprecated. Just ignored. Specify initial comment source. (default source) --comment-encoding=ENCODING Deprecated. Just ignored. Specify comment source encoding. (auto) Migemo --migemo-dictionary-search-path=PATH1,PATH2,... Specify search paths for Migemo static dictionary. (/usr/share, /usr/local/share) --migemo-dictionary-name=NAME Specify static dictionary name for Migemo. (migemo-dict) 3D --[no-]use-gl Specify whether to use OpenGL if available. (false) Display --[no-]keep-above Specify whether to keep above window. (false) Others --[no-]show-native-window-id Show a native window ID of the Rabbit window if available. e.g. The ID is the ID of X resource on X window system. (false) Common options --locale-dir=DIR Specify locale dir as [DIR]. (auto) --logger-type=TYPE Specify logger type as [TYPE]. Select from [stderr, gui]. (STDERR) --log-level=LEVEL Specify log level as [LEVEL]. Select from [debug, info, warning, error, fatal, unknown]. (info) --help Show this message. --version Show version. rabbit 1.0.7 June 2012 RABBIT(1)
All times are GMT -4. The time now is 05:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy