Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Specific Length awk Results

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Specific Length awk Results
# 1  
Old 12-30-2004
Computer Specific Length awk Results
I am awk-ing a line, and only want to get the results of the five chrs. following my field seperator. the line of prose is:

Unit=01982 (PICO RIVERA)
Unit=I1001 (INTERMOUNTAIN AREA)
Unit=E1000 (INTERMOUNTAIN WEST DIVISION)

failing in using an awk of:
awk -F= '/Unit/{print $2 length(5)}' inputfile.rpt
--------------------
awk: syntax error near line 1
awk: bailing out near line 1
(my length argument is wrong, I know)

Desired results:
01982
I1001
E1000

I'm sure this is rudementry, however, I have searched the net and can't find anything specific. Thanks in advance for any suggestions.
# 2  
Old 12-30-2004
MySQL
Gozer,
Try this, it is tested.
awk -F= '/Unit/''{print substr($2,1,5)}' inputfile.rpt
# 3  
Old 12-30-2004
awk 'FS=" " { print substr($1,6,length($1)) }' file1
# 4  
Old 12-30-2004
Computer WooooHoooo....
It feels like Christmas all over again, THANKS so much!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How do you preserve the max length of a line after replacing a specific value?

I'm new with scripting and I can't seem to figure out what I should do to get the output that I want. My file content would be below. ID2|ID3 |ID4|ID5 | I'm trying to replace the field of ID3 which has a fixed length of 10 characters, for each entry I have placed on a .txt file... (5 Replies)
Discussion started by: asdfghjkl
5 Replies

2. Shell Programming and Scripting

awk to update specific value in file with match and add +1 to specific digit

I am trying to use awk to match the NM_ in file with $1 of id which is tab-delimited. The NM_ will always be in the line of file that starts with > and be after the second _. When there is a match between each NM_ and id, then the value of $2 in id is substituted or used to update the NM_. Each NM_... (3 Replies)
Discussion started by: cmccabe
3 Replies

3. Shell Programming and Scripting

Print a specific length using awk

Hello, I have the following input data: A C AA GG A G CG AG the code I tried: awk -F" " '{ if ((length($1==1) && (length($2==1))) input_file is not working, I need the output to be (such that only the columns containing one letter are printed) A C A G Any help would be appreciated! (5 Replies)
Discussion started by: Rabu
5 Replies

4. Shell Programming and Scripting

Deleting lines in a fixed length file where there is a word at specific location

I have a big file having 100 K lines. I have to read each line and see at 356 character position whethere there is a word "W" in it. If it is their then don't delete the line otherwise delete it. There are two lines as one Header and one trailer which should remain same. Can somebody... (5 Replies)
Discussion started by: mohit kanoongo
5 Replies

5. Shell Programming and Scripting

Cutting rows at specific length

Hi, i have a file containing nrows and 3cols. i want to cut it in specific length and save output to individual files. 1 2 3 4 5 6 5 8 9 10 11 12 13 14 15 16 17 18 i need to cut the file say every 2 rows and save it in individual file. 01.dat contains 1 2 3 4 5 6 02.dat 7 8 9... (10 Replies)
Discussion started by: ida1215
10 Replies

6. Shell Programming and Scripting

Replace specific field on specific line sed or awk

I'm trying to update a text file via sed/awk, after a lot of searching I still can't find a code snippet that I can get to work. Brief overview: I have user input a line to a variable, I then find a specific value in this line 10th field in this case. After asking for new input and doing some... (14 Replies)
Discussion started by: crownedzero
14 Replies

7. UNIX for Dummies Questions & Answers

Create File with specific Length

We have utility running on Unix which generates Files with records greater than 32760 , (max supported by Mainframe) .Our requirement is to transfer is file to Mainframe .When we ftp the in binary format it automatically wraps it up..so we are good there... But now we need to zip and send the file... (2 Replies)
Discussion started by: nishantrk
2 Replies

8. Shell Programming and Scripting

Delete words greater than a specific length

HI All, I have a file with contents like this: apple computer terminal applecomputernetworkrouterterminalrouter network router applecomputernetworkrouterterminalrouter I want to remove all lines with length greater than "18 alphabets". Hence, my output should be: apple computer... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

9. Shell Programming and Scripting

Assigning a specific format to a specific column in a text file using awk and printf

Hi, I have the following text file: 8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm 9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm 10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm 11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies

10. Shell Programming and Scripting

Insert a text from a specific row into a specific column using SED or AWK

Hi, I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it. Here is how the text file looks: _______________________________________________________ DEVICE STATUS INFORMATION FOR LOCATION 1: OPER STATES: Disabled E:Enabled ... (5 Replies)
Discussion started by: Issemael
5 Replies
Login or Register to Ask a Question