Sponsored Content
Top Forums Shell Programming and Scripting Help tabulating file putting repeated strings as headers Post 303015768 by RudiC on Thursday 12th of April 2018 02:46:22 AM
Old 04-12-2018
Extending your attempt:
Code:
awk '
BEGIN           {print "STAGE|ID|NAME|TYPE|DFRUL|ADDR|RRUL|SPRR|ISGALW|ISUTWD"
                }
/STAGE/         {x=$3}
/ID/            {a=$3}
/NAME/          {b=$3}
/TYPE/          {c=$3}
/DFRUL/         {d=$3}
/ADDR/          {f=$3}
/RRUL/          {g=$3}
/SPRR/          {h=$3}
/ISGALW/        {i=$3}
/ISUTWD/        {j=$3
                 print x"|"a"|"b"|"c"|"d"|"f"|"g"|"h"|"i"|"j
                 a = b = c = d = e = f = g = h = i = j = x = ""
                }
' file
STAGE|ID|NAME|TYPE|DFRUL|ADDR|RRUL|SPRR|ISGALW|ISUTWD
1|0|JFMSC|MLRR|PERMISSION|1001|PERMISSION|TRUE|FALSE|FALSE
1|4|AAAARR|MLRR|RESTRICT|3553|PERMISSION|FALSE|FALSE|FALSE
|||||66444|PERMISSION|FALSE|FALSE|FALSE
|||||890087|PERMISSION|FALSE|FALSE|FALSE
1|0|PPROOA|RRHN|PERMISSION|7034|PERMISSION|FALSE|FALSE|FALSE

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

putting a timestamp in a file

I was sure there was a way to put a timestamp ina logfile but I can't seem to figure out how. What I would like to do is after the last messages in the rptmgr.err log is put a timestamp so I know the next time I look whats new. I am using AIX 5.1 any help will great Thanks (2 Replies)
Discussion started by: rocker40
2 Replies

2. Shell Programming and Scripting

Remove text between headers while leaving headers intact

Hi, I'm trying to strip all lines between two headers in a file: ### BEGIN ### Text to remove, contains all kinds of characters ... Antispyware-Downloadserver.com (Germany)=http://www.antispyware-downloadserver.c om/updates/ Antispyware-Downloadserver.com #2... (3 Replies)
Discussion started by: Trones
3 Replies

3. Shell Programming and Scripting

Deleting repeated strings in column 2

Hi to all, I have a file where the subject could contain "Summarized Availability Report" or only "Summarized Report" If the subject is "Summarized Availability Report" I want to apply it Scrip1 and if the subject is "Summarized Report" I want to apply it Scrip2. 1-) I would like you... (5 Replies)
Discussion started by: cgkmal
5 Replies

4. Shell Programming and Scripting

Merging of files with different headers to make combined headers file

Hi , I have a typical situation. I have 4 files and with different headers (number of headers is varible ). I need to make such a merged file which will have headers combined from all files (comman coluns should appear once only). For example - File 1 H1|H2|H3|H4 11|12|13|14 21|22|23|23... (1 Reply)
Discussion started by: marut_ashu
1 Replies

5. Shell Programming and Scripting

delete repeated strings (tags) in a line and concatenate corresponding words

Hello friends! Each line of my input file has this format: word<TAB>tag1<blankspace>lemma<TAB>tag2<blankspace>lemma ... <TAB>tag3<blankspace>lemma Of this file I need to eliminate all the repeated tags (of the same word) in a line, as in the example here below, but conserving both (all) the... (2 Replies)
Discussion started by: mjomba
2 Replies

6. Shell Programming and Scripting

Delete lines in file containing duplicate strings, keeping longer strings

The question is not as simple as the title... I have a file, it looks like this <string name="string1">RZ-LED</string> <string name="string2">2.0</string> <string name="string2">Version 2.0</string> <string name="string3">BP</string> I would like to check for duplicate entries of... (11 Replies)
Discussion started by: raidzero
11 Replies

7. Shell Programming and Scripting

Find repeated word and take sum of the second field to it ,for all the repeated words in awk

Hi below is the input file, i need to find repeated words and sum up the values of it which is second field from the repeated work.Im trying but getting no where close to it.Kindly give me a hint on how to go about it Input fruits,apple,20,fruits,mango,20,veg,carrot,12,veg,raddish,30... (11 Replies)
Discussion started by: 100bees
11 Replies

8. UNIX for Dummies Questions & Answers

Joining ends of strings in certain order with repeated ID's

I posted this a few days ago and got some help (Putting together substrings if pattern is matched - Page 2 | Unix Linux Forums | Shell Programming and Scripting) But I am now stuck on an issue that is similar but not the same really. I want to join parts of one line with parts of another line... (8 Replies)
Discussion started by: verse123
8 Replies

9. UNIX for Beginners Questions & Answers

Use strings from nth field from one file to match strings in entire line in another file, awk

I cannot seem to get what should be a simple awk one-liner to work correctly and cannot figure out why. I would like to use patterns from a specific field in one file as regex to search for matching strings in the entire line ($0) of another file. I would like to output the lines of File2 which... (1 Reply)
Discussion started by: jvoot
1 Replies

10. Shell Programming and Scripting

Putting strings into positioning array in loop

i need to add 2 string variables into a positioning array , repeatedly - in loop. First string in $2, second to $3 then up to the desired count incrementing the "position". Using set -- alone does not increment the count so I end up with 2 variables in the array. How do I increment the... (7 Replies)
Discussion started by: annacreek
7 Replies
Dancer::Error(3pm)					User Contributed Perl Documentation					Dancer::Error(3pm)

NAME
Dancer::Error - class for representing fatal errors SYNOPSIS
# taken from send_file: use Dancer::Error; my $error = Dancer::Error->new( code => 404, message => "No such file: `$path'" ); Dancer::Response->set($error->render); DESCRIPTION
With Dancer::Error you can throw reasonable-looking errors to the user instead of crashing the application and filling up the logs. This is usually used in debugging environments, and it's what Dancer uses as well under debugging to catch errors and show them on screen. ATTRIBUTES
code The code that caused the error. This is only an attribute getter, you'll have to set it at "new". title The title of the error page. This is only an attribute getter, you'll have to set it at "new". message The message of the error page. This is only an attribute getter, you'll have to set it at "new". exception The exception that caused the error. If the error was not caused by an exception, returns undef. Exceptions are usually objects that inherits of Dancer::Exception. This is only an attribute getter, you'll have to set it at "new". METHODS
/SUBROUTINES new Create a new Dancer::Error object. title The title of the error page. type What type of error this is. code The code that caused the error. message The message that will appear to the user. exception The exception that will be useable by the rendering. backtrace Create a backtrace of the code where the error is caused. This method tries to find out where the error appeared according to the actual error message (using the "message" attribute) and tries to parse it (supporting the regular/default Perl warning or error pattern and the Devel::SimpleTrace output) and then returns an error- higlighted "message". tabulate Small subroutine to help output nicer. dumper This uses Data::Dumper to create nice content output with a few predefined options. render Renders a response using Dancer::Response. environment A main function to render environment information: the caller (using "get_caller"), the settings and environment (using "dumper") and more. get_caller Creates a strack trace of callers. _censor An internal method that tries to censor out content which should be protected. "dumper" calls this method to censor things like passwords and such. _html_encode Internal method to encode entities that are illegal in (X)HTML. We output as UTF-8, so no need to encode all non-ASCII characters or use a module. FIXME : this is not true anymore, output can be any charset. Need fixing. AUTHOR
Alexis Sukrieh LICENSE AND COPYRIGHT
Copyright 2009-2010 Alexis Sukrieh. This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License. See http://dev.perl.org/licenses/ for more information. perl v5.14.2 2012-03-31 Dancer::Error(3pm)
All times are GMT -4. The time now is 07:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy