Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Sorting arrays horizontally without END section, awk Post 302708777 by RudiC on Tuesday 2nd of October 2012 08:13:24 AM
Old 10-02-2012
Without an end section it will be difficult to terminate the last line with <lf>.
Code:
sort -k1,2 -k4n inputfile|
awk     '{if ($1!=tmp) {if (NR>1) print ""; printf "%s %s", $1, $2; tmp=$1} else printf ","}
     {printf " %s %s", $3, $4}
    '
ref001, Europe, Spain, 203, Germany, 457, Belgium, 1001
ref002, America, US, 87, Canada, 234, Alaska, 652$

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed & awk--get section of file based 2 params

I need to get a section of a file based on 2 params. I want the part of the file between param 1 & 2. I have tried a bunch of ways and just can't seem to get it right. Can someone please help me out.....its much appreciated. Here is what I have found that looks like what I want....but doesn't... (12 Replies)
Discussion started by: Andy Cook
12 Replies

2. Shell Programming and Scripting

Sorting rules on a text section

Hi all My text file looks like this: start doc ... (certain number of records) REC3|Emma|info| REC3|Lukas|info| REC3|Arthur|info| ... (certain number of records) end doc start doc ... (certain number of records)... (4 Replies)
Discussion started by: Indalecio
4 Replies

3. Shell Programming and Scripting

Extract section of file based on word in section

I have a list of Servers in no particular order as follows: virtualMachines="IIBSBS IIBVICDMS01 IIBVICMA01"And I am generating some output from a pre-existing script that gives me the following (this is a sample output selection). 9/17/2010 8:00:05 PM: Normal backup using VDRBACKUPS... (2 Replies)
Discussion started by: jelloir
2 Replies

4. Shell Programming and Scripting

how to get one particular section (using awk)?

Hey, I have a problem about how to get one section of a file? I'm new to shell, but by reading some tutorial, I think I can use awk to do this. my input file: >ref|ZP_04937576.1| ECRINAEDPKTFMPSPGKVKHFHAPGGNGVRVDSHLYSGYSVPPNYDSLVGKVITYGAD DEALARMRNALDELIVDGIKTNTELHKDLVRDAAFCKGGVNIHYLE... (11 Replies)
Discussion started by: ritacc
11 Replies

5. Shell Programming and Scripting

Sort each row (horizontally) in AWK or any

Hello, How to sort each row in a document with numerical values and with more than one row. Example Input data (file1.txt): 4 6 8 1 7 2 12 9 6 10 6 1 14 5 7 and I want the the output to look like this(file2.txt): 1 4 6 7 8 2 6 9 10 12 1 5 6 7 14 I've tried sort -n file1.txt >... (12 Replies)
Discussion started by: joseamck
12 Replies

6. Shell Programming and Scripting

using awk to get specific section of lines in logs

i have a log file that has the date and time that looks like this: Wed Jun 28 15:46:21 2012 test failed tailed passed passed not error panic what we want to focus on is the first 5 columns because they contain the date and time. the date and time can be anywhere on the line. in this... (6 Replies)
Discussion started by: SkySmart
6 Replies

7. Shell Programming and Scripting

Warning while sorting : A newline character was added to the end of file

Hi, I am trying to sort a csv file which has say 10 lines each line having a row size that is upto 30183 no. of COLUMNS (Row length = 30183). There is a LINE FEED (LF) at the end of each line. When I try to sort this file say, based on the second FIELD using the below command, sort -t ',' +1... (5 Replies)
Discussion started by: DHeisenberg
5 Replies

8. Shell Programming and Scripting

IF section problem. syntax error: unexpected end of file error

Hello, I have another problem with my script. Please accept my apologies, but I am really nooby in sh scripts. I am writing it for first time. My script: returned=`tail -50 SapLogs.log | grep -i "Error"` echo $returned if ; then echo "There is no errors in the logs" fi And after... (10 Replies)
Discussion started by: jedzio
10 Replies

9. UNIX for Beginners Questions & Answers

Sorting blocks by a section of the identifier

I have a file that should be sorted by a string (shown in red in my example below) in the identifier. The RS is ^@M0, something like this: @M04961:22:000000000-B5VGJ:1:1101:9280:7106 1:N:0:86 GGCATGAAAACATACAAACCGTCTTTCCAGAAATTGTTCCAAGTATCGGCAACAGCTTTATCAATACCATGAAAAATATCAACCACACCAGAAGCAGCAT... (16 Replies)
Discussion started by: Xterra
16 Replies

10. Shell Programming and Scripting

awk to parse section of csv into array

In the awk below I am trying to parse the Sample Name below the section. The values that are extracted are read into array s(each value in a row seperated by a space) which will be used later in a bash script. The awk does execute but no values are printed. I am also not sure how to print in a row... (1 Reply)
Discussion started by: cmccabe
1 Replies
DATE_DEFAULT_TIMEZONE_GET(3)						 1					      DATE_DEFAULT_TIMEZONE_GET(3)

date_default_timezone_get - Gets the default timezone used by all date/time functions in a script

SYNOPSIS
string date_default_timezone_get (void ) DESCRIPTION
In order of preference, this function returns the default timezone by: o Reading the timezone set using the date_default_timezone_set(3) function (if any) o Prior to PHP 5.4.0 only: Reading the $TZ environment variable (if non empty) o Reading the value of the date.timezone ini option (if set) o Prior to PHP 5.4.0 only: Querying the host operating system (if supported and allowed by the OS). This uses an algorithm that has to guess the time- zone. This is by no means going to work correctly for every situation. A warning is shown when this stage is reached. Do not rely on it to be guessed correctly, and set date.timezone to the correct timezone instead. If none of the above succeed, date_default_timezone_get will return a default timezone of UTC. RETURN VALUES
Returns a string. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.4.0 | | | | | | | The TZ environment variable is no longer used to | | | guess the timezone. | | | | | 5.4.0 | | | | | | | The timezone is no longer guessed from informa- | | | tion available through the operating system as | | | the guessed timezone can not be relied on. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 Getting the default timezone <?php date_default_timezone_set('Europe/London'); if (date_default_timezone_get()) { echo 'date_default_timezone_set: ' . date_default_timezone_get() . '<br />'; } if (ini_get('date.timezone')) { echo 'date.timezone: ' . ini_get('date.timezone'); } ?> The above example will output something similar to: date_default_timezone_set: Europe/London date.timezone: Europe/London Example #2 Getting the abbreviation of a timezone <?php date_default_timezone_set('America/Los_Angeles'); echo date_default_timezone_get() . ' => ' . date('e') . ' => ' . date('T'); ?> The above example will output: America/Los_Angeles => America/Los_Angeles => PST SEE ALSO
date_default_timezone_set(3), "List of Supported Timezones". PHP Documentation Group DATE_DEFAULT_TIMEZONE_GET(3)
All times are GMT -4. The time now is 03:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy