Split multiple blank, even if it's blank Post: 302969137

Sponsored Content

Top Forums Shell Programming and Scripting Split multiple blank, even if it's blank Post 302969137 by cterra on Friday 18th of March 2016 10:42:54 AM

03-18-2016

Registered User

Quote:

Originally Posted by RudiC

Sure that it works? The type becomes "generator" in your third record, the one with the empty field.

And, you are creating 16 processes instead of 1 when working with a single awk solution.

I ve all my processus, my final code is :

Code:

cat $logpathGetSysInfo_ITO_Process_Status.sh-$site-$env.log | while read LINE
do
	tmp=""
	SERVER2USE=$(echo $LINE | awk -F' ' '{ print $1 }')
	Process=$(echo $LINE | awk -F' ' '{ print $2 }')
	tmp=$(echo $LINE | awk -F' ' '
	{	
		i = 3 
		do { 
				print $i
 
				i++
			} while(i < NF-1) 
	}
	
	')
	Type=$(echo $LINE | awk -F' ' '{ print $(NF-1) }')
	Status=$(echo $LINE | awk -F' ' '{ print $NF }')
	Description=$(echo "$tmp" | tr '\n' ' ')
	if [  "$Status" = "Aborted" ] || [  "$Status" = "Stopped" ]  ; then
		echo "$SITE;$ENV;$SERVER2USE;ITO;Processus;Critical;$Status;$Process : ${Description}"
	fi
done

The end line will push it to database through the file generated by the output

But you re right, i was so focus on my first "do while" into a "awk", that i ve forgotten the type ...

Now i understand better awk i will try to implement your code, it seems to be the perfect answer, it was just to hard for me and my first awk do while.

cterra

View Public Profile for cterra

Find all posts by cterra

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

regex to delete multiple blank lines in a file?

can't figure out a way to delete multiple empty lines but keep single empty lines in a file, file is like this #cat file 1 2 3 4 5 6 - What I want is 1 2

2. Shell Programming and Scripting

multiple search separated by blank line

hi all I want to get multiple search that are separated by blank line according to first search in text file eg: egrep 'x|Y|Z' file in that for each x...it should be seperated by blank line will u pls help

3. Shell Programming and Scripting

PERL: removing blank lines from multiple files

Hi Guru's , I have a whole bunch of files in /var/tmp that i need to strip any blank lines from, so ive written the following script to identify the lines (which works perfectly).. but i wanted to know, how can I actually strip the identified lines from the actual source files ?? my...

4. Shell Programming and Scripting

how to append blank line in multiple files in unix

Dear All- Please suggest a single unix command which can append blank line in multiple files. I need to achieve this using a single unix command and not a script Please do advice Regards, Suresh

5. Shell Programming and Scripting

Delete blank lines, if blank lines are more than one using shell

Hi, Consider a file named "testfile" The contents of file are as below first line added for test second line added for test third line added for test fourth line added for test fifth line added for test

6. UNIX for Dummies Questions & Answers

Split file based on number of blank lines

Hello All , I have a file which needs to split based on the blank lines Name ABC Address London Age 32 (4 blank new line) Name DEF Address London Age 30 (4 blank new line) Name DEF Address London

7. UNIX for Advanced & Expert Users

Delete blank spaces and blank lines in a file

Hi Gurus, Somebody can say me how to delete blank spaces and blank lines in a file unix, please. Thank you for advanced.

8. Shell Programming and Scripting

To check Blank Lines, Blank Records and Junk Characters in a File

9. Shell Programming and Scripting

In a file, replace blank line by the last line not blank above

Dear All, In a CSV file, say that a given column has been extracted. In that column, information is missing (i.e. blank lines appear). I would like to replace the blank lines by the last valid line (not blank) previously read. For example, consider the extract below: 123 234 543 111...

10. Shell Programming and Scripting

Split file when value in column is blank

Hi Experts, In short : Need to split file when field in column 5 is blank and need to generate two file in which column 5 is blank and other in which column 5 has values along with other rows and column data My issue is i am not able to get header for column from raw file into new file which...

LEARN ABOUT OPENSOLARIS

fmt

fmt(1)								   User Commands							    fmt(1)

NAME

       fmt - simple text formatters

SYNOPSIS

       fmt [-cs] [-w width | -width] [inputfile]...

DESCRIPTION

       fmt  is a simple text formatter that fills and joins lines  to produce output lines of (up to) the number of characters specified in the -w
       width option. The default  width is 72. fmt concatenates the inputfiles listed as arguments. If none are given, fmt formats text  from  the
       standard input.

       Blank lines are preserved in the output, as is the spacing between words. fmt does not fill nor split lines beginning with a `.' (dot), for
       compatibility with nroff(1). Nor does it fill or split a set of contiguous non-blank lines which is determined to be  a	mail  header,  the
       first line of which must begin with "From".

       Indentation is preserved in the output, and input lines with differing indentation are not joined (unless -c is used).

       fmt can also be used as an in-line text filter for vi(1). The  vi command:

       !}fmt

       reformats the text between the cursor location and the end of the paragraph.

OPTIONS

       -c		    Crown  margin  mode.  Preserve the indentation of the first two lines within a paragraph, and align the left margin of
			    each subsequent line with that of the second line. This is useful for tagged paragraphs.

       -s		    Split lines only. Do not join short lines to form longer ones. This prevents sample lines of code, and other such for-
			    matted text, from being unduly combined.

       -w width | -width    Fill output lines to up to	width columns.

OPERANDS

       inputfile    Input file.

ENVIRONMENT VARIABLES

       See environ(5) for a description of the LC_CTYPE environment variable that affects the execution of fmt.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       nroff(1), vi(1), attributes(5), environ(5)

NOTES

       The -width option is acceptable for BSD compatibility, but it may go away in future releases.

SunOS 5.11							    9 May 1997								    fmt(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

regex to delete multiple blank lines in a file?

Discussion started by: fedora

2. Shell Programming and Scripting

multiple search separated by blank line

Discussion started by: suryanarayana

3. Shell Programming and Scripting

PERL: removing blank lines from multiple files

Discussion started by: hcclnoodles

4. Shell Programming and Scripting

how to append blank line in multiple files in unix

Discussion started by: sureshg_sampat

5. Shell Programming and Scripting

Delete blank lines, if blank lines are more than one using shell

Discussion started by: anil8103

6. UNIX for Dummies Questions & Answers

Split file based on number of blank lines

Discussion started by: Pratik4891

7. UNIX for Advanced & Expert Users

Delete blank spaces and blank lines in a file

Discussion started by: systemoper