Sponsored Content
Full Discussion: Column printing in awk
Top Forums Shell Programming and Scripting Column printing in awk Post 302701607 by Amit.saini333 on Monday 17th of September 2012 02:20:39 AM
Old 09-17-2012
Column printing in awk

Experts,

i have a following file containing data in following manner.

Code:
              1      2480434.4   885618.6        0.00        1948.00
                                                                 40.00      1952.00
                                                                 80.00      1961.00
                                                                120.00     1977.00
               2       2480653.8  885738.3        0.00         1948.00
                                                                  40.00       1952.00
                                                                  4000.00   4938.00
                                                                  4040.00   4938.00
               3      2480873.3  885858.0         0.00         1948.00
                                                                  40.00       1952.00
                                                                  80.00       1961.00
                                                                  4100.00   4938.00

Desired output is like below 

    2480434.4    885618.6       0     1948
    2480434.4    885618.6     40     1952
    2480434.4    885618.6     80     1961
    2480434.4    885618.6    120    1977
    2480653.8    885738.3         0    1948
    2480653.8    885738.3        40    1952
    2480653.8    885738.3    4000    4938
    2480653.8    885738.3    4040    4938
    2480873.3    885858             0    1948
    2480873.3    885858           40    1952
    2480873.3    885858           80    1961
    2480873.3    885858         4100    4938

Any help/suggestion on the above request is highly appreciated . I tried a lot for good editing , but i think i am clear with my question above

Thanks & Regards

Last edited by Amit.saini333; 09-17-2012 at 03:49 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk not printing the last combined column

nawk -F "|" 'FNR==NR {a=$2 OFS $3 OFS $4 OFS $5 OFS $6;next}\ {if ($5 in a)print $1,"test",$5,a, $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 ; \ else print $1,"Database",$5 OFS OFS OFS OFS OFS OFS $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 }' OFS="|" \ file1 file2 > file3 This... (5 Replies)
Discussion started by: pinnacle
5 Replies

2. Shell Programming and Scripting

Printing 1st column to lower case using awk

I want to print the 1st field in a comma seperated file to lower case and the rest the case they are. I tried this nawk -F"," '{print tolower($0)}' OFS="," file this converts whole line in to lower case i just want the first column to be converted. The below doesnt work because in... (11 Replies)
Discussion started by: pinnacle
11 Replies

3. UNIX for Dummies Questions & Answers

Printing highest value from one column

Hi, I have a file that looks like this: s6 98 s6 91 s6 56 s5 32 s5 10 s5 4 So what I want to do is print only the highest value for each value in the column: So the file will look like this: s6 98 s5 32 Thanks (4 Replies)
Discussion started by: phil_heath
4 Replies

4. Shell Programming and Scripting

regarding about printing row to column

Hello, I got data like that, =111 A= alpha B= 1 C= qq D= 45 F= ss G= 334 =1234 A= B= 2w C= D= 443 F= G= =3434 A= B= e3e (5 Replies)
Discussion started by: davidkhan
5 Replies

5. UNIX for Dummies Questions & Answers

creating a file using the fist column and printing second column

Hello all. I have a problem that I need help solving. I would like to convert the following file: human pool1_12 10e-02 45 67 human pool1_1899 10e-01 45 29 human pool1_1829 10e-01 43 26 horse pool1_343 10e-20 65 191 horse pool1_454 10e-09 44 43... (5 Replies)
Discussion started by: viralnerd
5 Replies

6. Solaris

Printing a particular column[autosys]

Dear All, I'm using autosys in my production system. My concern is as follows: autosys -j <some_job_nm> Output: Job Name Last Start Last End ST Run Pri/Xit ... (1 Reply)
Discussion started by: saps19
1 Replies

7. Shell Programming and Scripting

Printing a variable column using awk

Hi everyone, Ok here's the scenario. I have a control file like this. component1,file1,file2,file3,file4,file5 component2,file1,file2,file3,file4,file5I want to do a while loop here to read all files for each component. file_count=2 while ] do file_name=`cat list.txt | grep... (2 Replies)
Discussion started by: The Gamemaster
2 Replies

8. Shell Programming and Scripting

Printing another column using awk and input data

Hi, I have data of the following type, chr1 234 678 39 852 638 abcd 7895 chr1 526 326 33 887 965 kilj 5849 Now, I would like to have something like this chr1 234 678 39 852 638 abcd 7895 <a href="http://unix.com/thread=chr1:234-678">Link</a> chr1 526 326 33 887 965 kilj 5849 <a... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

9. Shell Programming and Scripting

awk: printing newline with last column

I was trying to simplify this from what I'm actually doing, but I started getting even more confused so I gave up. Here is the content of my input file: Academic year,Term,Course name,Period,Last name,Nickname 2012-2013,First Semester,English 12,7th Period,Davis,Lucille When I do this: ... (3 Replies)
Discussion started by: nextyoyoma
3 Replies

10. Shell Programming and Scripting

Awk: printing column using for loop

Hello: I've input data: Input data --- 3:60069:C:T 60069 C T 1 0 0 1 0 0 1 0 0 1 0 0 1 --- 3:60079:A:G 60079 A G 1 0 0 0.988 0.012 0 1 0 0 1 0 0 1 --- rs186476240:60157:G:A 60157 G A 1 0 0 1 0 0 1 0 0 1 0 0 1 I edit/make first few columns before numbers (6th column) and want to... (4 Replies)
Discussion started by: genome
4 Replies
INTLDATEFORMATTER(3)							 1						      INTLDATEFORMATTER(3)

The IntlDateFormatter class

INTRODUCTION
Date Formatter is a concrete class that enables locale-dependent formatting/parsing of dates using pattern strings and/or canned patterns. This class represents the ICU date formatting functionality. It allows users to display dates in a localized format or to parse strings into PHP date values using pattern strings and/or canned patterns. CLASS SYNOPSIS
IntlDateFormatter IntlDateFormatter Methods o public IntlDateFormatter::__construct (string $locale, int $datetype, int $timetype, [mixed $timezone = NULL], [mixed $calendar = NULL], [string $pattern = ""]) o publicstatic IntlDateFormatter IntlDateFormatter::create (string $locale, int $datetype, int $timetype, [mixed $timezone = NULL], [mixed $calendar = NULL], [string $pattern = ""]) o public string IntlDateFormatter::format (mixed $value) o publicstatic string IntlDateFormatter::formatObject (object $object, [mixed $format = NULL], [string $locale = NULL]) o int IntlDateFormatter::getCalendar (void ) o public int IntlDateFormatter::getDateType (void ) o public int IntlDateFormatter::getErrorCode (void ) o public string IntlDateFormatter::getErrorMessage (void ) o public string IntlDateFormatter::getLocale ([int $which]) o public string IntlDateFormatter::getPattern (void ) o public int IntlDateFormatter::getTimeType (void ) o public string IntlDateFormatter::getTimeZoneId (void ) o public IntlCalendar IntlDateFormatter::getCalendarObject (void ) o public IntlTimeZone IntlDateFormatter::getTimeZone (void ) o public bool IntlDateFormatter::isLenient (void ) o public array IntlDateFormatter::localtime (string $value, [int &$position]) o public int IntlDateFormatter::parse (string $value, [int &$position]) o bool IntlDateFormatter::setCalendar (mixed $which) o public bool IntlDateFormatter::setLenient (bool $lenient) o public bool IntlDateFormatter::setPattern (string $pattern) o public bool IntlDateFormatter::setTimeZoneId (string $zone) o public boolean IntlDateFormatter::setTimeZone (mixed $zone) SEE ALSO
oICU Date formatter oICU Date formats PREDEFINED CONSTANTS
These constants are used to specify different formats in the constructor for DateType and TimeType. o IntlDateFormatter::NONE ( integer) -Do not include this element o IntlDateFormatter::FULL ( integer) -Completely specified style (Tuesday, April 12, 1952 AD or 3:30:42pm PST) o IntlDateFormatter::LONG ( integer) -Long style (January 12, 1952 or 3:30:32pm) o IntlDateFormatter::MEDIUM ( integer) -Medium style (Jan 12, 1952) o IntlDateFormatter::SHORT ( integer) -Most abbreviated style, only essential data (12/13/52 or 3:30pm) The following int constants are used to specify the calendar. These calendars are all based directly on the Gregorian calendar. Non-Grego- rian calendars need to be specified in locale. Examples might include locale="hi@calendar=BUDDHIST". o IntlDateFormatter::TRADITIONAL ( integer) -Non-Gregorian Calendar o IntlDateFormatter::GREGORIAN ( integer) -Gregorian Calendar PHP Documentation Group INTLDATEFORMATTER(3)
All times are GMT -4. The time now is 02:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy