help with data formatting Post: 302587727

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting help with data formatting Post 302587727 by agama on Thursday 5th of January 2012 06:41:40 PM

Old

01-05-2012

Registered User

Assuming that the the area-code (xxx) is always after the 'break point', and is always present, this might work:

Code:

awk '
    /\([0-9][0-9][0-9]\)/ {
        if( buffer )
            printf( "%s%s\n", buffer, $0 );
        else
            print;
        buffer = "";
        next;
    }
    { buffer = $0; }
' input-file >fixed-file

agama

View Public Profile for agama

Find all posts by agama

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Formatting Data

i am writing a script that reads in a file and i just want it to print each element on a new line here is my code and the data that i want to read in #!/usr/bin/perl use strict; use CGI qw(:standard); use CGI qw(:cgi); my $data_file = "/tmp/results.txt"; my $configuration; my...

2. Shell Programming and Scripting

Re-formatting of data display

Hi All, I have been trying to re-arrange the below data using AWK or Perl. Can anybody help me ? Thanks in advance. Input: 111 222 333 444 AAA BBB CCC DDD 555 666 777 888 EEE FFF GGG HHH Output:

3. Shell Programming and Scripting

Script for data formatting

Hi I have to convert the data in a file ******* 01-20-09 11:14AM 60928 ABC Valuation-2009.xls 01-20-09 11:16AM 55808 DEF GHI Equation-2009.xls 01-20-09 11:02AM 52736 ABC DF Valuation-2009.xls 01-20-09 11:06AM 89600 THE...

4. UNIX for Dummies Questions & Answers

Data manipulation/ formatting question

How would I get this output to look $ cat newfile 13114 84652 84148 LIKE THIS?: 13114,84652,84148 sed,cut awk? syntax?

5. Shell Programming and Scripting

Formatting Data - CSV

I want to check whether if any column data has any + , - , = prefixed to it then convert it in such a form that in excel its not read as formula. echo "$DATA" | awk 'BEGIN { OFS="," } -F" " {print $1,$2,$3,$4,$5,$6,$7,$8.$9,$10,$11,$12}'

6. Shell Programming and Scripting

Formatting input data

Hello everybody, I have a file containing some statistics regarding CPU usage. The file has this syntax : Fri Jul 16 14:27:16 EEST 2010 Cpu(s): 15.2%us, 1.4%sy, 0.0%ni, 82.3%id, 0.1%wa, 0.0%hi, 0.9%si, 0.0%st Fri Jul 16 15:02:17 EEST 2010 Cpu(s): 15.3%us, 1.4%sy, 0.0%ni, 82.3%id, ...

7. UNIX for Advanced & Expert Users

formatting the data

HI I want to make it single row if start with braces i.e. { .Any idea {1:XXX2460275191}{2:SEC00687921131112201641N}{3:{58910}}{4: :R:GENL :C::xx//xx1 :20C::yy//yy1 :2S:xxT} {1:XXX2460275190}{2:SEC00687921131112201641y}{3:{58911}}{4: :z:GENL :v::xx//xx1 :10C::yy//yy1 :4S:xxT ...

8. Shell Programming and Scripting

Help with data formatting

Hi, I am generating the following output from my script. Country,A,B,C,D,E,F INDIA ,3755019,774604,484749,329838,7333612,442031 CHINA ,3716520,889197,530899,379754,6198475,355768 JAPAN ,52038,30462,231224,147275,1272,498 USA,9494,1130,0,0,15303,451...

9. Shell Programming and Scripting

Data formatting using awk

Need assistance on the data extraction using awk Below is the format and would like to extract the data in another format ------------------------------------------------------------------------------------------------- Minimum Temperature (deg F ) DAY 1 2 3 4 5 6 7 8 9 10 11...

LEARN ABOUT OPENSOLARIS

scsi_validate_sense

scsi_validate_sense(9F) 				   Kernel Functions for Drivers 				   scsi_validate_sense(9F)

NAME

       scsi_validate_sense - find descriptor in SCSI sense data

SYNOPSIS

       #include <sys/scsi/scsi.h>

       int scsi_validate_sense(uint8_t *sense_buffer, int sense_buf_len,
	    int *flags);

INTERFACE LEVEL

       Solaris DDI specific (Solaris DDI).

PARAMETERS

       sense_buffer	Pointer to a buffer containing SCSI sense data. The sense data is expected in wire format starting at the response code.

       sense_buf_len	Length of sense buffer in bytes.

       flags		Returns additional properties of the sense data.

DESCRIPTION

       The  scsi_validate_sense() function returns the format of the sense data contained in the provided sense buffer. If the response code field
       in the sense data is not recognized or if there is not enough sense data to include sense key, asc,  and  ascq  then  scsi_validate_sense()
       returns	SENSE_UNUSABLE.  If  the buffer contains usable sense data in fixed format, the function returns SENSE_FIXED_FORMAT. If the buffer
       contains usable sense data in descriptor format, the function returns SENSE_DESCR_FORMAT.

       The following flags may be set as appropriate depending on the sense data:

       SNS_BUF_OVERFLOW    The sense data buffer provided for the request is too small to hold all the sense data.

       SNS_BUF_DEFERRED    The sense data contained in the buffer relates to an error that has occurred during the processing  of  a  successfully
			   completed command, such as a cached write that could not be commited to the media.

RETURN VALUES

       SENSE_UNUSABLE	     The response code from the sense data is unrecognized or not enough sense data present to provide the sense key, asc,
			     and ascq.

       SENSE_FIXED_FORMAT    The sense data in the buffer is in "fixed format".

       SENSE_DESCR_FORMAT    The sense data in the buffer is in "descriptor format".

CONTEXT

       The scsi_validate_sense() function can be called from user or interrupt context.

SEE ALSO

       scsi_ext_sense_fields(9F),   scsi_find_sense_descr(9F),	 scsi_sense_asc(9F),	scsi_sense_ascq(9F),	scsi_sense_cmdspecific_uint64(9F),
       scsi_sense_info_uint64(9F), scsi_sense_key(9F)

SunOS 5.11							    29 Jun 2006 					   scsi_validate_sense(9F)