Sponsored Content
Top Forums Shell Programming and Scripting search a string in a particular column of file and return the line number of the line Post 302585323 by arunshankar.c on Wednesday 28th of December 2011 06:19:36 AM
Old 12-28-2011
search a string in a particular column of file and return the line number of the line

Hi All,

Can you please guide me to search a string in a particular column of file and return the line number of the line where it was found using awk. As an example :

abc.txt
Code:
7000,john,2,1,0,1,6
7001,elen,2,2,0,1,7
7002,sami,2,3,0,1,6
7003,mike,1,4,0,2,1
8001,nike,1,5,0,1,8
8002,paul,2,6,0,2,7

In above example search in 4th column for value 5 and return line number 5.

I tried below awk but it does not work

Code:
awk '/5/ {if ($4=="5") print $0}' abc.txt

Can some one please help
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

String search and return value from column

Dear All I had below mention file as my input file. 87980457 Jan 12 2008 2:00AM 1 60 BSC1 81164713 Jan 12 2008 3:00AM 1 60 BSC2 78084521 Jan 12 2008 4:00AM 1 60 BSC3 68385193... (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies

2. Shell Programming and Scripting

Search string and return only the 5th line

I have looked at almost every posting on here regarding, grep, sed, awk, nawk, perl methods to perform this function, but they are just not returning the results I hope to see. Example File: abcdef 123456 ghijkl 7890123 7890123 7890123 7890123 mnopqrs 456789 This is the most... (4 Replies)
Discussion started by: doza22
4 Replies

3. Shell Programming and Scripting

search string in a file and retrieve 10 lines including string line

Hi Guys, I am trying to write a perl script to search a string "Name" in the file "FILE" and also want to create a new file and push the searched string Name line along with 10 lines following the same. can anyone of you please let me know how to go about it ? (8 Replies)
Discussion started by: sukrish
8 Replies

4. Shell Programming and Scripting

Replace 2nd column for each line in a csv file with fixed string+random number

Hi experts, My csv file looks like this U;cake;michael;temp;;;; U;bread;john;temp;;;; U;cocktails;sarah;temp;;;; I'd like to change the value fo 2nd column to cf+random number , which will look maybe something like this U;cf20187;michael;temp;;;; U;cf8926;john;temp;;;;... (7 Replies)
Discussion started by: tententen
7 Replies

5. Shell Programming and Scripting

SH script to parse string and return multi-line file

Hello all, I have been asked to exercise my shell scripting and it has been 10 plus years since I used to do it so I can not remember hardly anything and ask for your help. What I need to do is copy a line out of a file that can be 10 to 100 characters long, I then need to parse this line into... (3 Replies)
Discussion started by: Alivadoro
3 Replies

6. Shell Programming and Scripting

Search a string in a text file and add another string at the particular position of a line

I am having a text file which is having more than 200 lines. EX: 001010122 12000 BIB 12000 11200 1200003 001010122 2000 AND 12000 11200 1200003 001010122 12000 KVB 12000 11200 1200003 In the above file i want to search for string KVB and add/replace... (1 Reply)
Discussion started by: suryanarayana
1 Replies

7. Shell Programming and Scripting

Search a string in a text file and add another string at the end of line

Dear All I am having a text file which is having more than 200 lines. EX: 001010122 12000 BIB 12000 11200 1200003 001010122 2000 AND 12000 11200 1200003 001010122 12000 KVB 12000 11200 1200003 In the above file i want to search for string KVB... (5 Replies)
Discussion started by: suryanarayana
5 Replies

8. Shell Programming and Scripting

Deleting double quoted string from a line when line number is variable

I need to remove double quoted strings from specific lines in a file. The specific line numbers are a variable. For example, line 5 of the file contains A B C "string" I want to remove "string". The following sed command works: sed '5 s/\"*\"//' $file If there are multiple... (2 Replies)
Discussion started by: rennatsb
2 Replies

9. Shell Programming and Scripting

Search string within a file and list common words from the line having the search string

Hi, Need your help for this scripting issue I have. I am not really good at this, so seeking your help. I have a file looking similar to this: Hello, i am human and name=ABCD. How are you? Hello, i am human and name=PQRS. I am good. Hello, i am human and name=ABCD. Good bye. Hello, i... (12 Replies)
Discussion started by: royzlife
12 Replies

10. UNIX for Dummies Questions & Answers

Search for a string,delete the line and replace with new string in a file

Hi Everyone, I have a requirement in ksh where i have a set of files in a directory. I need to search each and every file if a particular string is present in the file, delete that line and replace that line with another string expression in the same file. I am very new to unix. Kindly help... (10 Replies)
Discussion started by: Pradhikshan
10 Replies
fold(1) 						      General Commands Manual							   fold(1)

NAME
fold - fold long lines for finite width output device SYNOPSIS
width] [file ...] Obsolete form: width] [file ...] DESCRIPTION
The command is a filter that folds the contents of the specified files, breaking the lines to have a maximum of width column positions (or bytes, if the option is specified). The command breaks lines by inserting a newline character so that each output line is the maximum width possible that does not exceed the specified number of column positions (or bytes). A line cannot be broken in the middle of a char- acter. If no files are specified or if a file name of is specified, the standard input is used. The command is often used to send text files to line printers that truncate, rather than fold, lines wider than the printer is able to print. If the backspace, tab, or carriage-return characters are encountered in the input, and the option is not specified, they are treated spe- cially as follows: Backspace The current count of line width is decremented by one, although the count never becomes negative. Thus, the char- acter sequence character-backspace-character counts as using one column position, assuming both characters each occupy a single column position. does not insert a newline character immediately before or after any backspace character. Tab Each tab character encountered advances the column position pointer to the next tab stop. Tab stops are set 8 col- umns apart at column positions 1, 9, 17, 25, 33, etc. Carriage-return The current count of line width is set to zero. does not insert a newline character immediately before or after any carriage-return character. Note that may affect any underlining that is present. Options The command recognizes the following options and command-line arguments: Count width in bytes rather than in column positions. Break the line on the last blank character found before the specified number of column positions (or bytes). If none are found, break the line at the specified line length. Specify the maximum line length, in column positions (or bytes if is specified). The default value is 80. width should be a multiple of 8 if tabs are present, or the tabs should be expanded using before processing by (see expand(1)). The option is obsolescent and may be removed in a future release. EXTERNAL INFLUENCES
Environment Variables determines the interpretation of text as single- and/or multi-byte characters. determines the language in which messages are displayed. If or is not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty variable. If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See environ(5). International Code Set Support Single- and multi-byte character code sets are supported. SEE ALSO
expand(1). STANDARDS CONFORMANCE
fold(1)
All times are GMT -4. The time now is 10:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy