Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File Manipulations

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File Manipulations
# 1  
Old 06-03-2010
Question File Manipulations
Hi All,

I have a pipe delimited file with around 30 fields. What is the simple way to Update a value for any column. For ex. If i want to update 22 field with "album".

Similarly, how to do this for the whole file and selective records of the file.

Example file contents:

Code:
f1,f2,f2,f4,f5,f6
11,  ,  ,22,33,44
11,  ,  ,22,33,44
11,  ,  ,22,33,44
11,  ,  ,22,33,44
11,  ,xx,22,33,44

1. How to update f2 value with "ZZ"
2. How to do the same for only selective records say only for first 3 lines.

Thanks in Advance.

Regards,
Joe
Last edited by Franklin52; 06-08-2010 at 05:12 AM.. Reason: Please use code tags!
# 2  
Old 06-03-2010
Joe2226,

You can try with.
Quote:
1. How to update f2 value with "ZZ"
Code:
awk 'BEGIN{FS=OFS=","} {$2="ZZ"}1' file

Quote:
2. How to do the same for only selective records say only for first 3 lines.
Code:
awk 'BEGIN{FS=OFS=","} NR<4{$2="ZZ"}1' file

I hope it helps.
# 3  
Old 06-04-2010
hi cgkmal,
I tried the code, I'm geting an error, its givin me syntax error & bailing out error. I dnt know wat does tht mean...
# 4  
Old 06-04-2010
Hi.

It probably means you are using Solaris, and should use /usr/xpg4/bin/awk or nawk
# 5  
Old 06-04-2010
okay alrite... I'm using SunOS.
M very new to Unix n jus trying to learn as much as i can from this forum.
M sure the syntax will still remain the same with nawk as well right..??

---------- Post updated at 03:47 AM ---------- Previous update was at 03:45 AM ----------

Thanx scottn it worked wid nawk.

I got the following output:
Code:
f1,ZZ,f2,f4,f5,f6
11,ZZ, ,22,33,44
11,ZZ, ,22,33,44
11,ZZ, ,22,33,44
11,ZZ, ,22,33,44
11,ZZ,xx,22,33,44
,ZZ  <---  Where does this come from..??
f1,ZZ,f2,f4,f5,f6
11,ZZ, ,22,33,44
11,ZZ, ,22,33,44
11, , ,22,33,44
11, , ,22,33,44
11, ,xx,22,33,44

# 6  
Old 06-07-2010
Thanks Kamal. I havent tried it. Will try it and let u know
Quote:
Originally Posted by cgkmal
Joe2226,

You can try with.
Code:
awk 'BEGIN{FS=OFS=","} {$2="ZZ"}1' file

Code:
awk 'BEGIN{FS=OFS=","} NR<4{$2="ZZ"}1' file

I hope it helps.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script (sh file) logic to compare contents of one file with another file and output to file

Shell script logic Hi I have 2 input files like with file 1 content as (file1) "BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt File 2 contents as fle(2) "BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt I want to get... (22 Replies)
Discussion started by: pottic
22 Replies

2. Shell Programming and Scripting

Text file manipulations

Hello All, I have three txt files ***main.txt***** code test line code test3 asdfasdf do for while line1: code test line code test3 asdfasdf do for while line2: code test (6 Replies)
Discussion started by: avatar_007
6 Replies

3. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

4. UNIX for Dummies Questions & Answers

Help with Multiple Text Manipulations

Hey guys, I have a file which contains 22,373 ping trace outputs which I generated using a script I made, see excerpt below: ... PING6(72=40+8+24 bytes) 2001:630:301:1453:219:e3ff:fee7:8c2a --> 2406:8000:101:c020::24 32 bytes from 2406:8000:101:c020::24, icmp_seq=0 hlim=44 time=279.163 ms... (6 Replies)
Discussion started by: churchill
6 Replies

5. Shell Programming and Scripting

Some manipulations with files and folders. (loop, find, create and remove)

Hello! I need to realize such task. 1. In my user's home dir I have folder1; 2. In folder1 I have some (various count) subfolders with random names; 3. In these subfolders I have one file anyname.pdf (various name in each subfolder) and file content.txt (constant name in each subfolder) ##... (7 Replies)
Discussion started by: optik77
7 Replies

6. Shell Programming and Scripting

Time and Date Manipulations

Hi Guys... I do have a script that I need to use time or time function in my condition. The logic will be like if the current time of execution is between 7am and 7pm then do 1,2,3,etc else do 4,5,6. I need help is that function or how best can I do this. Thanks in advance. Please... (3 Replies)
Discussion started by: Phuti
3 Replies

7. Shell Programming and Scripting

How to do String manipulations using Substring function in Shell

Hi, I have a scenario to just plug out the file name from the following location path. /opt/project/data/int/holdFiles/csv195687.csv So, how do I get just file name which is "csv195687.csv" from the above line using awk/shell scripting? Can we use indexOf and Substring in awk to get... (7 Replies)
Discussion started by: anilvvnn
7 Replies

8. UNIX for Advanced & Expert Users

Date manipulations

hi i am having a script in which i am supposed to extract data for three different dates...first date is current date second date is 15 days back third date is 40 days back for eg consider todays date 26062006 as first date then second date is 11062006 third date is 17052006 now in my... (2 Replies)
Discussion started by: rochitsharma
2 Replies

9. Shell Programming and Scripting

Time Manipulations

Hi All :D I have a long file having different fields like :- hh:mm:ss seconds 14:15:56 120 14:18:36 12 15:12:36 1500 I want to subtract the hh:mm:ss in line(2) from hh:mm:ss in line(1) & compare the output of substraction (obtained in... (10 Replies)
Discussion started by: vanand420
10 Replies

10. Shell Programming and Scripting

date manipulations

i need a date manipulation unix shell script, to find the difference between any two dates. kindly help me:confused: (2 Replies)
Discussion started by: user1
2 Replies
Login or Register to Ask a Question