Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk - filtering data by if --> into an array
Homework and Emergencies Homework & Coursework Questions awk - filtering data by if --> into an array Post 302689541 by IMPe on Tuesday 21st of August 2012 03:28:31 PM
Old 08-21-2012
Quote:
Originally Posted by Corona688
What relation does your output have to your input then? If your output doesn't match your input, we're only guessing.

My guess is, 122 would end up in the second column, 233 would be in the third, 344 would be in the fourth, and 455 would be in the fifth. But I can't really tell for sure.
Hi corona688!
First of all, thank you for helping me to solving my problem..
the triplets should be sortet by there first number acording to the timestamp.
I would like the triplets printout in a gnuplot-grafik. there should be the 4**-Triplets in red, the 3** in green and so on. therefor i need the data-triplets in this strukture.
Code:
...
08/13/12-16:30  \t      \t      322    \t
08/13/12-16:40  \t      \t      \t      422
08/13/12-16:50  \t      \t      \t      \t
08/13/12-17:00  \t      \t      321    \t
08/13/12-17:10  \t      \t      \t      \t  
08/13/12-17:20  \t      \t      \t      \t  
08/13/12-17:30  \t      \t      322    \t
08/13/12-17:40  \t      \t      \t      \t  
08/13/12-17:50  \t      \t      321    \t
08/13/12-18:00  131    \t       \t      \t
08/13/12-18:10  \t      \t      322    \t
08/13/12-18:20  \t      231    \t      \t
...

The main problem i think, is the if-structure. I'm not quit famuiliar with this part in the awk. I think the script start struggeling by defining the Fieldseperator.

Thanks
IMPe
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Filtering out data ...

I have following command which tells me File size in GBs which are greater than 0.01GBs recursively in a dir structure. ls -l -R | awk '{ if ($5/1073741824 >= 0.01) print $9, $5/1073741824 }' But there are some files whom I dont have enough permissions, after executing this script gives me... (1 Reply)
Discussion started by: videsh77
1 Replies

2. Shell Programming and Scripting

Filtering Data

Hi All, I have the below input and expected ouput. I need a code which can scan through this input file and if the number in column1 is more than 1 , it will print out the whole line, else it will output "No Re-occurrence". Can anybody help ? Input: 1 vvvvv 20 7 7 23 0 64 6 zzzzzz 11 5... (7 Replies)
Discussion started by: Raynon
7 Replies

3. UNIX for Dummies Questions & Answers

Filtering Data

file1 contain: (this just a small sample of data it may have thousand of lines) 1 aaa 1/01/1975 delhi 2 bbb 2/03/1977 mumbai 3 ccc 1/01/1975 mumbai 4 ddd 2/03/1977 chennai 5 aaa 1/01/1975 kolkatta 6 bbb 2/03/1977 bangalore program: nawk '{ idx= $2 SUBSEP $3 arr = (idx in arr) ?... (2 Replies)
Discussion started by: bobo
2 Replies

4. Shell Programming and Scripting

help need in filtering data

Hello Gurus, Please help me out of the problem. I ve a input file as below input clock; input a; //reset all input b; //input comment output c; output d; output e; input f; //output comment I need the output as follows: \\Inputs (1 Reply)
Discussion started by: user_prady
1 Replies

5. Shell Programming and Scripting

AWK help. how to compare a variable with a data array in AWK?

Hi all, i have a data array as follows. array=ertfgj2345 array=456ttygkd . . . array=errdjt3235 so number or elements in the array can varies depending on how big the data input is. now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1). ... (9 Replies)
Discussion started by: usustarr
9 Replies

6. Shell Programming and Scripting

Filtering data using AWK

Hi , i have file with delimiter as "|" and data in Double codes for all fields. how to filter data in a column like awk -F"|" '$1="asdf" {print $0}' test. ex : "asdf"|"zxcv" Thanks, Soma (1 Reply)
Discussion started by: challamsomu
1 Replies

7. Shell Programming and Scripting

awk data filtering

I am trying to filter out some data with awk. If someone could help me that would be great. Below is my input file. Date: 10-JUN-12 12:00:00 B 0: 00 00 00 00 10 00 16 28 B 120: 00 00 00 39 53 32 86 29 Date: 10-JUN-12 12:00:10 B 0: 00 00 00 00 10 01 11 22 B 120: 00 00 00 29 23 32 16 29... (5 Replies)
Discussion started by: thibodc
5 Replies

8. Shell Programming and Scripting

awk - filtering data by if --> into an array

Hi my data is in csv-format ... ... 13/08/2012,16:30,303.30,5.10,3,2,2,1,9360.0,322 13/08/2012,16:40,305.50,5.00,3,2,2,1,12360.0,322 13/08/2012,16:50,319.90,3.80,3,2,1,0,2280.0 13/08/2012,17:00,326.10,3.50,3,2,1,1,4380.0,321 13/08/2012,17:10,333.00,3.80,3,3,1,0,2280.0... (1 Reply)
Discussion started by: IMPe
1 Replies

9. Shell Programming and Scripting

Filtering out the data with dates

Hi, I have some data like seen below. format : apple(hhmm mm/dd).fruit apple(2345 03/25).fruit apple(2345 05/06).fruit orange(0443 05/02).fruit orange(0345 05/05).fruit orange(2134 05/04).fruit grape(0930 04/24).fruit grape(2330 03/30).fruit I need to get the data which are... (1 Reply)
Discussion started by: jayadanabalan
1 Replies

10. Shell Programming and Scripting

Need help Filtering Data from an API

Hi Everyone, I need help on figuring out a way to filter some data that I get back from an API. Im able to get all the data that Im looking for but I would like to know a way for me to filter it better. The data that Im getting back is basically 2 rows of data as seen here. Row 1 ... (25 Replies)
Discussion started by: TheStruggle
25 Replies

LEARN ABOUT OPENSOLARIS

iconv_8859-2

iconv_8859-2(5) 					Standards, Environments, and Macros					   iconv_8859-2(5)

NAME

       iconv_8859-2 - code set conversion tables for ISO 8859-2 (Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |		  Code Set Conversions Supported		    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |   Target Output    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |MS 1250       |win2    | Windows Latin 2    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |MS 852	      |dos2    | MS-DOS Latin 2     |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |Mazovia       |maz     | Mazovia	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |DHN	      |dhn     | Dom Handlowy Nauki |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   ISO 8859-2 to MS 1250
       For the conversion of ISO 8859-2 to MS 1250, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    MS 1250	|  ISO 8859-2	 |   MS 1250	 |
       |24	       | 4		|261		 |271		 |
       |177-237        | 40		|265		 |276		 |
       |241	       | 245		|266		 |234		 |
       |245	       | 274		|267		 |241		 |
       |246	       | 214		|271		 |232		 |
       |251	       | 212		|273		 |235		 |
       |253	       | 215		|274		 |237		 |
       |254	       | 217		|276		 |236		 |
       |256	       | 216		|266		 |236		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-2 to MS 852
       For the conversion of ISO 8859-2 to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    MS 852	|  ISO 8859-2	 |   MS 852	 |
       |24	       | 4		|316		 |327		 |
       |177-237        | 40		|317		 |322		 |
       |240	       | 377		|320		 |321		 |
       |241	       | 244		|321		 |343		 |
       |242	       | 364		|322		 |325		 |
       |243	       | 235		|323		 |340		 |
       |244	       | 317		|324		 |342		 |
       |245	       | 225		|325		 |212		 |
       |246	       | 227		|326		 |231		 |
       |247	       | 365		|327		 |236		 |
       |250	       | 371		|330		 |374		 |
       |251	       | 346		|331		 |336		 |
       |252	       | 270		|332		 |351		 |
       |253	       | 233		|333		 |353		 |
       |254	       | 215		|334		 |232		 |
       |255	       | 360		|335		 |355		 |
       |256	       | 246		|336		 |335		 |
       |257	       | 275		|337		 |341		 |
       |260	       | 370		|340		 |352		 |
       |261	       | 245		|341		 |240		 |
       |262	       | 362		|342		 |203		 |
       |263	       | 210		|343		 |307		 |
       |264	       | 357		|344		 |204		 |
       |265	       | 226		|345		 |222		 |
       |266	       | 230		|346		 |206		 |
       |267	       | 363		|347		 |207		 |
       |270	       | 367		|350		 |237		 |
       |271	       | 347		|351		 |202		 |
       |272	       | 255		|352		 |251		 |
       |273	       | 234		|353		 |211		 |
       |274	       | 253		|354		 |330		 |
       |275	       | 361		|355		 |241		 |
       |276	       | 247		|356		 |214		 |
       |277	       | 276		|357		 |324		 |
       |300	       | 350		|360		 |320		 |
       |301	       | 265		|361		 |344		 |
       |302	       | 266		|362		 |345		 |
       |303	       | 306		|363		 |242		 |
       |304	       | 216		|364		 |223		 |
       |305	       | 221		|365		 |213		 |
       |306	       | 217		|366		 |224		 |
       |307	       | 200		|367		 |366		 |
       |310	       | 254		|370		 |375		 |
       |311	       | 220		|371		 |205		 |
       |312	       | 250		|372		 |243		 |
       |313	       | 323		|374		 |201		 |
       |314	       | 267		|375		 |354		 |
       |315	       | 326		|376		 |356		 |
       |366	       | 367		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-2 to Mazovia
       For the conversion of ISO 8859-2 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    Mazovia	|  ISO 8859-2	 |   Mazovia	 |
       |24	       | 4		|323		 |243		 |
       |177-237        | 40		|324-325	 |40		 |
       |240	       | 377		|326		 |231		 |
       |241	       | 217		|327-333	 |40		 |
       |242	       | 40		|334		 |232		 |
       |243	       | 234		|335-336	 |40		 |
       |244-245        | 40		|337		 |341		 |
       |246	       | 230		|340-341	 |40		 |
       |247-253        | 40		|342		 |203		 |
       |254	       | 240		|343		 |40		 |
       |255-256        | 40		|344		 |204		 |
       |257	       | 241		|345		 |40		 |
       |260	       | 370		|346		 |215		 |
       |261	       | 206		|347		 |207		 |
       |262	       | 40		|350		 |40		 |
       |263	       | 222		|351		 |202		 |
       |264-265        | 40		|352		 |221		 |
       |266	       | 236		|353		 |211		 |
       |267-273        | 40		|354-355	 |40		 |
       |274	       | 246		|356		 |214		 |
       |275-276        | 40		|357-360	 |40		 |
       |277	       | 247		|361		 |244		 |
       |300-303        | 40		|362		 |40		 |
       |304	       | 216		|363		 |242		 |
       |305	       | 40		|364		 |223		 |
       |306	       | 225		|365		 |40		 |
       |307	       | 200		|366		 |224		 |
       |310-311        | 40		|367		 |366		 |
       |312	       | 220		|370-373	 |40		 |
       |313-320        | 40		|374		 |201		 |
       |321	       | 245		|375-376	 |40		 |
       |322	       | 40		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-2 to DHN
       For the conversion of ISO 8859-2 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |      DHN	|  ISO 8859-2	 |     DHN	 |
       |24	       | 4		|322		 |40		 |
       |177-237        | 40		|323		 |205		 |
       |240	       | 377		|324-325	 |40		 |
       |241	       | 200		|326		 |231		 |
       |242	       | 40		|327-333	 |40		 |
       |243	       | 203		|334		 |232		 |
       |244-245        | 40		|335-336	 |40		 |
       |246	       | 206		|337		 |341		 |
       |247-253        | 40		|340		 |40		 |
       |254	       | 207		|341		 |240		 |
       |255-256        | 40		|342-345	 |40		 |
       |257	       | 210		|346		 |212		 |
       |260	       | 370		|347-351	 |40		 |
       |261	       | 211		|352		 |213		 |
       |262	       | 40		|353-354	 |40		 |
       |263	       | 214		|355		 |241		 |
       |264-265        | 40		|356-360	 |40		 |
       |266	       | 217		|361		 |215		 |
       |267-273        | 40		|362		 |40		 |
       |274	       | 220		|363		 |216		 |
       |275-276        | 40		|364		 |223		 |
       |277	       | 221		|365		 |40		 |
       |300-305        | 40		|366		 |224		 |
       |306	       | 201		|367		 |366		 |
       |307-311        | 40		|370-371	 |40		 |
       |312	       | 202		|372		 |243		 |
       |313-320        | 40		|373-376	 |40		 |
       |321	       | 204		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						   iconv_8859-2(5)
All times are GMT -4. The time now is 10:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy