Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Cut portion of a field in shell scripts

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cut portion of a field in shell scripts
# 1  
Old 05-20-2009
Cut portion of a field in shell scripts
Hi,

I am a file with the following layout.

field1|field2|field3|field4|field5|field6|field7
field1|field2|field3|field4|field5|field6|field7
field1|field2|field3|field4|field5|field6|field7

I need to write a file with the below layout
field1|field2|fieldx|field6

where fieldx = substring of field4.

I am using cut function to write the required fields. But I don't know how to get the substring of field 4 from the file to be written into the output file.

Please help.
# 2  
Old 05-20-2009
You are a file?

fieldx = first 2 chars of field 4....
Code:
nawk -F'|' '{print $1, $2, substr($4,1,2), $6}' OFS='|' myFile

# 3  
Old 05-20-2009
Hi,

I am using KSH shell script for this.

I use the below command:
filename | grep 'string' | cut -f1,2,4,6 -d"|"

right now to pull fields wherein i need to have a substring of the file in field 4.
# 4  
Old 05-20-2009
Quote:
Originally Posted by shivacbz
Hi,

I am using KSH shell script for this.

I use the below command:
filename | grep 'string' | cut -f1,2,4,6 -d"|"

right now to pull fields wherein i need to have a substring of the file in field 4.
Not sure what you're saying/asking.
Have you tried what'd been posted previously?
# 5  
Old 05-20-2009
The Unix script does not recognize command 'nawk'
# 6  
Old 05-20-2009
how about 'awk' or 'gawk'?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Cut the first field and the 2 last field

Hello, I would like to cut the first field and the 2 last fields from the string.Please help. Here is the example of the string.DL_FUND_FULL_20190605.txt DL_FUND_HIS_DEL_20190605.txt DL_FUND_HIS_TMP_DEL20190605.txt Please noted that DL_ --> Every files have the prefix like this.... (3 Replies)
Discussion started by: palita2601
3 Replies

2. UNIX for Beginners Questions & Answers

awk - If field value of consecutive records are the identical print portion of lines

I have some data that looks like this: PXD= ZW< 1,6 QR> QRJ== 1,2(5) QR> QRJ== 4,1(2) QR> QRJ== 4,2 QRB= QRB 4,2 QWM QWM 6,2 R<C ZW< 11,2 R<H= R<J= 6,1 R>H XZJ= 1,2(2) R>H XZJ= 2,6(2) R>H XZJ= 4,1(2) R>H XZJ= 6,2 RDP RDP 1,2 What I would like to do is if fields $1 and $2 are... (5 Replies)
Discussion started by: jvoot
5 Replies

3. Shell Programming and Scripting

Shell to display portion of a line

Thanks a lot for the code and the explanation. Now my final requirement. I have uploaded 3 files as attachment. Please open the files in Editplus or any other text editor which keeps the formatting. GMDCOM.27936.log.txt------I want to pick only Process request from this file.(Please check... (9 Replies)
Discussion started by: ghosh_tanmoy
9 Replies

4. Shell Programming and Scripting

Cut third field of every third line

Hello, I have got a log file and would need to write a script to cut the every first and second fields of every third line. Job Name : dummytextd_v1 Status : KILLED TIMEDOUT 2011-05-01 05:33 Job Name : dummyttx_v1 Status : KILLED TIMEDOUT 2011-05-03 02:33 Job Name :... (4 Replies)
Discussion started by: Kochappa
4 Replies

5. Shell Programming and Scripting

how to cut a particular field

hi all i am need to cut the name of the file which i am entering in the comand line. say abc.txt is the name of the file i need to cut only the "abc" part. when i try doing this(using cut -f1) i am getting the data that s present inside the file and the file name. pls help.... (3 Replies)
Discussion started by: din_annauniv
3 Replies

6. Shell Programming and Scripting

Cut the last field

Hello guys. Is there any way I can cut the last field using "cut" ??? (without putting it into a while...) Thanks. 435 Gavea. (9 Replies)
Discussion started by: 435 Gavea
9 Replies

7. Shell Programming and Scripting

How do I cut out this field?

Hello, In a shell script I am writing I execute this command: uniq -c names1.tmp > names2.tmp In names2.tmp I get these results: 4 user 2 username 1 users 1 veriano 1 victoria I need to isolate the names in this file and put it in another file. However it seems that the number... (7 Replies)
Discussion started by: mojoman
7 Replies

8. Shell Programming and Scripting

Cut last Field

Guys, I have a line like this: 109;201;1099010 and as you see that first field 109 and the last field starts with 109. I need to cut the rest in the last field after 109 which is 9010 How to do it? (2 Replies)
Discussion started by: sfaqih
2 Replies

9. Shell Programming and Scripting

dirname, save cut portion to variable, clean up

Hi guys, last cry for help for today. I appreciate the help so far. ok so I have a program that dumps a path into my script as a variable ($1) This path is an example /home/xbmc/sab_downloads/video/tv/grey's anatomy/season 3 So in order to search thetvdb.com for a show, I need to extract... (6 Replies)
Discussion started by: tret
6 Replies

10. UNIX for Dummies Questions & Answers

how to use cut to get the last field of a string?

If I am not sure of how many fields a string has, say STR=/homt/root/dir1/dir2/../dirn how to use "cut -d/ -f" to get dirn ? (3 Replies)
Discussion started by: meili100
3 Replies
Login or Register to Ask a Question