Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Read text between regexps and write into files based on a field in the text
Top Forums Shell Programming and Scripting Read text between regexps and write into files based on a field in the text Post 302864633 by RavinderSingh13 on Thursday 17th of October 2013 12:13:29 AM
Old 10-17-2013
Hi,

Could you please use the following code.

Code:
awk '/start regexp/,/end regexp/' file_name | awk '/start regexp/ {print$NR}1'  | sed 's/^start$//g'

Output will be as follows.

Code:
start regexp
Name=Name1
Title=Analyst
Address=Address1
Department=Finance
end regexp
 
start regexp
Name=Name2
Title=Controller
Address=Address2
Department=Finance
end regexp
 
start regexp
Name=Name3
Title=Associate
Address=Address3
Department=Marketing
end regexp


Hope this wil help.


Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove spaces from first field, and write entire contents into other text file

Hi all, I have searched and found various threads about removing spaces from a field within a text file. Unfortunately, I have not found exactly what I'm looking for, nor am I adept enough to modify what I've found into what I need. I use the following command to remove the first line... (3 Replies)
Discussion started by: carriehoff
3 Replies

2. Shell Programming and Scripting

match text from two files and write to a third file

Hi all I have two files X.txt and Y.txt. Both file contains same number of sentences. The content of X.txt is The filter described above may be combined. and the content of Y.txt is The filter describ+ed above may be combin+ed. Some of the words are separated with "+"... (2 Replies)
Discussion started by: my_Perl
2 Replies

3. Shell Programming and Scripting

Aligning text files by max field length

Hello, Is there anyway that I can align a pipe delimited text file by the maxium field length where the field is separated out by pipes for large text files with more than 100,000 rows? So, far I have searched other forums and google about aligning text files in unix and I have noticed that... (7 Replies)
Discussion started by: physalis2099
7 Replies

4. Shell Programming and Scripting

how read specific line in a file and write it in a new text file?

I have list of files in a directory 'dir'. Each file is of type HTML. I need to read each file and get the string which starts with 'http' and write them in a new text file. How can i do this shell scripting? file1.html <head> <url>http://www.google.com</url> </head> file2.html <head>... (6 Replies)
Discussion started by: vel4ever
6 Replies

5. Shell Programming and Scripting

Read in 2-column CSV, output many files based on field

Is there a way to read in a two-columned CSV file, and based on the fields in 1st column, output many different files? The input/output looks something like: input.csv: call Call Mom. call Call T-Mobile. go Go home. go Go to school. go Go to gas station. play Play music. play Play... (4 Replies)
Discussion started by: pxalpine
4 Replies

6. Shell Programming and Scripting

Read n lines from a text files getting n from within the text file

I dont even have a sample script cause I dont know where to start from. My data lookes like this > sat#16 #data: 15 site:UNZA baseline: 205.9151 0.008 -165.2465 35.8109 40.6685 21.9148 121.1446 26.4629 -18.4976 33.8722 0.017 -165.2243 48.2201 40.6908 ... (8 Replies)
Discussion started by: malandisa
8 Replies

7. Shell Programming and Scripting

awk to skip lines find text and add text based on number

I am trying to use awk skip each line with a ## or # and check each line after for STB= and if that value in greater than or = to 0.8, then at the end of line the text "STRAND BIAS" is written in else "GOOD". So in the file of 4 entries attached. awk tried: awk NR > "##"' "#" -F"STB="... (6 Replies)
Discussion started by: cmccabe
6 Replies

8. UNIX for Beginners Questions & Answers

awk GSUB read field values from multiple text files

My program run without error. The problem I am having. The program isn't outputting field values with the column headers to file.txt. Each of the column headers in file.txt has no data. MEMSIZE SECOND SASFoundation Filename The output results in file.txt should show: ... (1 Reply)
Discussion started by: dellanicholson
1 Replies

9. Shell Programming and Scripting

awk to print lines based on text in field and value in two additional fields

In the awk below I am trying to print the entire line, along with the header row, if $2 is SNV or MNV or INDEL. If that condition is met or is true, and $3 is less than or equal to 0.05, then in $7 the sub pattern :GMAF= is found and the value after the = sign is checked. If that value is less than... (0 Replies)
Discussion started by: cmccabe
0 Replies

10. Shell Programming and Scripting

awk to adjust text and count based on value in field

The below awk executes as is and produces the current output. It isvery close but what Ican not seem to do is add the -exon..., the ... portion comes from $1 and the _exon is static and will never change. If there is + sign in $4 then the ... is in acending order or sequential. If there is a - in... (2 Replies)
Discussion started by: cmccabe
2 Replies

LEARN ABOUT DEBIAN

grcat

GRCAT(1)						      General Commands Manual							  GRCAT(1)

NAME

       grcat - read from standard input, colourise it and write to standard output

SYNOPSIS

       grcat configuration

DESCRIPTION

       configuration  is a name of a configuration file. Directories ~/.grc/, /usr/local/share/grc/, /usr/share/grc/ are searched for the file (in
       this order).

       If the file is not found, it is assumed to be an absolute path of a configuration file located elsewhere.

       Configuration file consists of entries, one per regexp, entries are separated with lines with first character non-alphanumeric (except  #).
       Lines beginning with # or empty lines are ignored.

       Each  entry  consists  of several lines.  Each line has form: keyword=value where keyword is one of: regexp, colours, command, skip, count.
       Only regexp is mandatory, but it does not have much sense by itself unless you specify at least a colour or command keyword as well.

       regexp is the regular expression to match

       colours is the list of colours, separated by commas (you can specify only one colour), each colour per one regexp group specified  in  reg-
       exp.

       command	is  command  to be executed when regexp matches. Its output will be mixed with normal stdout, use redirectors ( >/dev/null) if you
       want to supress it.

       skip can be either yes, or no, if yes, the matched line will be skipped and not displayed in output.  Default is no.

       count is one of words: once, more, or stop.

       once means that if the regexp is matched, its first occurrence is coloured and the program will continue with other regexp's.

       more means that if there are multiple matches of the regexp in one line, all of them will be coloured.

       stop means that the regexp will be coloured and program will move to the next line (i.e. ignoring other regexp's)

       Regular expressions are evaluated from top to bottom, this allows nested and overlapped expressions. (e.g.  you	colour	everything  inside
       parentheses with one colour, and if a following expression matches the text inside parentheses, it will be also coloured)

OPTIONS

       None so far.

SEE ALSO

       grc(1)

AUTHOR

       Written by Radovan Garabik <garabik @ kassiopeia.juls.savba.sk>

																	  GRCAT(1)
All times are GMT -4. The time now is 08:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy