Sponsored Content
Top Forums Shell Programming and Scripting Search for a substr with nawk Post 302785889 by apenkov on Tuesday 26th of March 2013 01:57:39 PM
Old 03-26-2013
Search for a substr with nawk

Hi, I have files, with fixed length fields/let's say every field 5 positions/, like this:
Code:
xxxx 140  xxxxx
xxxx 140  xxxxx
xxxx 1400 xxxxx
xxxx 150  xxxxx

I need to get only the records, which have 140 in the second column. I use that command:
Code:
nawk '{if (substr($0,6,3)=="140") print $0}' input_files >> ooutput_file;

But that also return me the rows that contain 1400.
Any idea how to fix that?

Thanks!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using substr

What is the more efficient way to do this (awk only and default FS) ? $ echo "jefe@alm"|awk '{pos = index($0, "@");printf ("USER: %s\n",substr ($0,1,pos-1))}' USER: jefe Thx in advance (2 Replies)
Discussion started by: Klashxx
2 Replies

2. UNIX for Dummies Questions & Answers

Substr

Hi, My input file is 41;2;xxxx;yyyyy.... 41;2;xxxx;yyyyy.... 41;2;xxxx;yyyyy.... .. .. I need to change the second field value from 2 to 1. i.e., 41;1;xxxx;yyyyy.... 41;1;xxxx;yyyyy.... 41;1;xxxx;yyyyy.... .. .. Thanks in advance. (9 Replies)
Discussion started by: deepakwins
9 Replies

3. Shell Programming and Scripting

get substr?

Hi, I have a long string like, aabab|bcbcbcbbc|defgh|paswd123 dedededede|efef|ghijklmn|paswd234 ghghghghgh|ijijii|klllkkk|paswd345 lmlmlmmm|nononononn|opopopopp|paswd456 This string is devided into one space between substrings. This substrings are, aabab|bcbcbcbbc|defgh|paswd123... (6 Replies)
Discussion started by: syamkp
6 Replies

4. Shell Programming and Scripting

how to access values of awk/nawk variables outside the awk/nawk block?

i'm new to shell scripting and have a problem please help me in the script i have a nawk block which has a variable count nawk{ . . . count=count+1 print count } now i want to access the value of the count variable outside the awk block,like.. s=`expr count / m` (m is... (5 Replies)
Discussion started by: saniya
5 Replies

5. UNIX for Dummies Questions & Answers

substr

can anybody explain this code? thanks in advance..:) (6 Replies)
Discussion started by: janani_kalyan
6 Replies

6. Shell Programming and Scripting

Nesting - two nawk into one nawk

hi people; this is my two awk code: nawk '/cell+-/{r=(NF==8) ? $4FS$5FS$6 : NF==7 ? $4FS$5 : $4 ;c=split(r,rr);for (i=1;i<=c;i++){if(rr != "111111"){printf($3" %d ""\n",(i+3))}}printf("")}' /home/gc_sw/str.txt > /home/gc_sw/predwn.txt nawk -F'*' '{gsub(/ *$/,"")}$0=$1$($NF-2)'... (2 Replies)
Discussion started by: gc_sw
2 Replies

7. Shell Programming and Scripting

search pattern that has spaces with nawk

Hi guys, I need a help ! I need do grab some string from file and then count n lines after that pattern. This is working fine, but my problem is that the string to be searched has spaces within, like an example : LINK COUNTERS what I am using is: nawk... (2 Replies)
Discussion started by: robdcb
2 Replies

8. Shell Programming and Scripting

Nawk Problem - nawk out of space in tostring on

Hi.. i am running nawk scripts on solaris system to get records of file1 not in file2 and find duplicate records in a while with the following scripts -compare nawk 'NR==FNR{a++;next;} !a {print"line"FNR $0}' file1 file2duplicate - nawk '{a++}END{for(i in a){if(a-1)print i,a}}' file1in the middle... (12 Replies)
Discussion started by: Abhiraj Singh
12 Replies

9. UNIX for Dummies Questions & Answers

Substr

awk '/^>/{id=$0;next}length>=7 { print id, "\n"$0}' Test.txt Can I use substr to achieve the same task? Thanks! (8 Replies)
Discussion started by: Xterra
8 Replies

10. Shell Programming and Scripting

Search comppare replace (substr/lppad)

Hi Everyone, I have a data file with data as below which contains millions of data and gets loaded to database using SQL loader using positional notation. AT 0001 000000000100000000000 BE 4 000000000000030000000 DE 0055 000004000000000000000 FR 0 ... (8 Replies)
Discussion started by: Showdown
8 Replies
UNICODE_START(1)					      General Commands Manual						  UNICODE_START(1)

NAME
unicode_start - put keyboard and console in unicode mode SYNOPSIS
unicode_start [font [umap]] DESCRIPTION
The unicode_start command will put the keyboard and console into Unicode (UTF-8) mode. For the keyboard this means that one can attach 16-bit U+xxxx values to keyboard keys using loadkeys(1), and have these appear as UTF-8 input to user programs. Also, that one can type hexadecimal Alt-xxxx using the numeric keypad, and again produce UTF-8. For the console this means that the kernel expects UTF-8 output from user programs, and displays the output accordingly. The parameter font is a font that is loaded. It should have a built-in Unicode map, or, if it hasn't, such a map can be given explicitly as second parameter. When no font was specified, the current font is kept. NOTE
Unicode mode is a parameter with a value per virtual console. However, usually the font and keymap is common to all consoles. SEE ALSO
dumpkeys(1), kbd_mode(1), loadkeys(1), unicode_stop(1), utf-8(7), setfont(8) 3 Feb 2001 UNICODE_START(1)
All times are GMT -4. The time now is 08:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy