Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: a cut-command or special format pattern in awk
Top Forums Shell Programming and Scripting a cut-command or special format pattern in awk Post 302682489 by IMPe on Monday 6th of August 2012 10:29:46 AM
Old 08-06-2012
a cut-command or special format pattern in awk
Hi

i read data with awk,
Code:
01.07.2012	00:10	227.72	247.50	1.227	1.727	17.273
01.07.2012	00:20	237.12	221.19	2.108	2.548	17.367
01.07.2012	00:30	230.38	230.34	3.216	3.755	17.412
01.07.2012	00:40	243.18	242.91	4.662	5.172	17.328
01.07.2012	00:50	245.58	245.41	5.179	5.721	17.128
01.07.2012	01:00	256.63	253.30	5.002	5.711	16.980
01.07.2012	01:10	263.29	257.95	5.208	5.860	16.746
01.07.2012	01:20	262.18	258.82	5.529	6.091	16.477

and i want to achieve an output, especially for the timestamp 07/01/12-hh:mm
Code:
...
awk '{printf("%02d/%02d/%2d-%02d:%02d\t%.2f\t%.2f\t%.3f\t%.3f\t%.3f\n",$2,$3,$1,$4,$5,$6,$7,$9,$10,$11)}' OFS='\t' $home/data.dat > $home/out.txt

Is there an parameter for awk '{printf( , where i can set the pattern for two-number-year?

Thanks in advance!
IMPe
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk,cut fields by change field format

Hi Everyone, # cat 1.txt 1321631,77770132976455,19,20091001011859,20091001011907 1321631,77770132976455,19,20091001011859,20091001011907 1321631,77770132976455,19,20091001011859,20091001011907 # cat 1.txt | awk -F, '{OFS=",";print $1,$3,$4,$5}' 1321631,19,20091001011859,20091001011907... (7 Replies)
Discussion started by: jimmy_y
7 Replies

2. Shell Programming and Scripting

awk search pattern with special characters passed from CL

I'm very new to awk and sed and I've been struggling with this for a while. I'm trying to search a file for a string with special characters and this string is a command line argument to a simple script. ./myscript "searchpattern" file #!/bin/sh awk "/$1/" $2 > dupelistfilter.txt sed... (6 Replies)
Discussion started by: cue
6 Replies

3. Shell Programming and Scripting

Sed or awk : pattern selection based on special characters

Hello All, I am here again scratching my head on pattern selection with special characters. I have a large file having around 200 entries and i have to select a single line based on a pattern. I am able to do that: Code: cat mytest.txt | awk -F: '/myregex/ { print $2}' ... (6 Replies)
Discussion started by: usha rao
6 Replies

4. UNIX for Advanced & Expert Users

awk command in special character

Hi, I want to add below line after end of a file (i.e file1) &&echo "copy done" >> out.txt cat file1 scp user1@server1:/tmp/dir /tmp/dir1 my requirment is cat file1 scp user1@server1:/tmp/dir /tmp/dir1 &&echo "copy done" >> out.txt could any one please help me (7 Replies)
Discussion started by: anshu ranjan
7 Replies

5. UNIX for Dummies Questions & Answers

Regarding cut or awk command

Hi, I need a help with cut/awk command. I need to get certain values from a string provided. For example: i have a config file with below mentioned details oracle="user=name"/"pass/word"@databasename. I have used a command var1=`grep -w oracle sample.cfg | cut -d"=" -f2 | cut -d"/" -f1`. ... (10 Replies)
Discussion started by: kumars2102
10 Replies

6. Shell Programming and Scripting

AWK command to cut the desired header columns

Hi Friends, I have a file1 i want to retrieve only the fields which have DEP,CITY,TRANS as headers in other file. Output: I want to give the input as DEP,CITY,TRANS column names to get the output. i used cut command .. but if i have 300 fileds it is more difficult to... (4 Replies)
Discussion started by: i150371485
4 Replies

7. Shell Programming and Scripting

awk and cut command

Hi, I have to display the value 16 present in "lcpu=16" which is the output of a command # vmstat System configuration: lcpu=16 mem=4096MB I used as # hdtype=`vmstat | grep "lcpu" | awk -F "=" '{print $2}'` # echo $hdtype 16 mem But I need to display only 16.. Am doing... (3 Replies)
Discussion started by: Priya Amaresh
3 Replies

8. Shell Programming and Scripting

Help with cut or awk command

i am trying to cut the 4th field from the file. sample file a1,a2,"a,3",a4,a5,a6 b1,"b,2",b3,b4,b5,b6 c1,"c,2","c,3",c4,c5,c6 i need the output in the format of a1,a2,"a,3",a5,a6 b1,"b,2",b3,b5,b6 c1,"c,2","c,3",c5,c6 i tried using cut -d, -f1-4,6- but i am getting the output as ... (10 Replies)
Discussion started by: ATWC
10 Replies

9. Shell Programming and Scripting

awk command to find total number of Special character in a column

How to find total number of special character in a column? I am using awk -f "," '$col_number "*$" {print $col_number}' file.csv|wc -l but its not giving correct output. It's giving output as 1 even though i give no special character? Please use code tags next time for your code and... (4 Replies)
Discussion started by: AjitKumar
4 Replies

10. Shell Programming and Scripting

awk to format each line by pattern

The four lines in the tab-delimeted input are a sample format from my actual data. The awk is meant to go line by line and check if a pattern is satisfied and if it is follow a particular format (there are 3). All the lines in the file should follow one of the three formats below. I added comments... (4 Replies)
Discussion started by: cmccabe
4 Replies

LEARN ABOUT SUNOS

iconv_maz

iconv_maz(5)						Standards, Environments, and Macros					      iconv_maz(5)

NAME

       iconv_maz - code set conversion tables for Mazovia

DESCRIPTION

       The following code set conversions are supported:

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

CONVERSIONS

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

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

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   Mazovia     |  ISO 8859-2	|   Mazovia	 |  ISO 8859-2	 |
       |24-177	       | 40		|230		 |246		 |
       |200	       | 307		|231		 |326		 |
       |201	       | 374		|232		 |334		 |
       |202	       | 351		|233		 |40		 |
       |203	       | 342		|234		 |243		 |
       |204	       | 344		|235		 |40		 |
       |205	       | 40		|236		 |266		 |
       |206	       | 261		|237		 |40		 |
       |207	       | 347		|240		 |254		 |
       |210	       | 40		|241		 |257		 |
       |211	       | 353		|242		 |363		 |
       |212-213        | 40		|243		 |323		 |
       |214	       | 356		|244		 |361		 |
       |215	       | 346		|245		 |321		 |
       |216	       | 304		|246		 |274		 |
       |217	       | 241		|247		 |277		 |
       |220	       | 312		|250-340	 |40		 |
       |221	       | 352		|341		 |337		 |
       |222	       | 263		|342-365	 |40		 |
       |223	       | 364		|366		 |367		 |
       |224	       | 366		|367		 |40		 |
       |225	       | 306		|370		 |260		 |
       |226-227        | 40		|371-376	 |40		 |
       |256	       | 201		|		 |		 |
       +---------------+----------------+----------------+---------------+

   Mazovia to MS 1250
       For the conversion of Mazovia to MS 1250, all characters not in the following table are mapped unchanged.

       +---------------+----------------+----------------+---------------+
       |   Mazovia     |    MS 1250	|   Mazovia	 |   MS 1250	 |
       |200	       | 307		|236		 |234		 |
       |201	       | 374		|237		 |40		 |
       |202	       | 351		|240		 |217		 |
       |203	       | 342		|241		 |257		 |
       |204	       | 344		|242		 |363		 |
       |205	       | 40		|243		 |323		 |
       |206	       | 271		|244		 |361		 |
       |207	       | 347		|245		 |321		 |
       |210	       | 40		|246		 |237		 |
       |211	       | 353		|247		 |277		 |
       |212-213        | 40		|250-251	 |40		 |
       |214	       | 356		|252		 |254		 |
       |215	       | 346		|253-255	 |40		 |
       |216	       | 304		|256		 |253		 |
       |217	       | 245		|257		 |273		 |
       |220	       | 312		|260-340	 |40		 |
       |221	       | 352		|341		 |337		 |
       |222	       | 263		|342-345	 |40		 |
       |223	       | 364		|346		 |265		 |
       |224	       | 366		|347-360	 |40		 |
       |225	       | 306		|361		 |261		 |
       |226-227        | 40		|362-365	 |0		 |
       |230	       | 214		|366		 |367		 |
       |231	       | 326		|367		 |40		 |
       |232	       | 334		|370		 |260		 |
       |233	       | 40		|371		 |40		 |
       |234	       | 243		|372		 |267		 |
       |235	       | 40		|373-376	 |40		 |
       |274	       | 212		|		 |		 |
       +---------------+----------------+----------------+---------------+

   Mazovia to MS 852
       For the conversion of Mazovia to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   Mazovia     |    MS 852	|   Mazovia	 |    MS 852	 |
       |205	       | 40		|234		 |235		 |
       |206	       | 245		|235		 |40		 |
       |210-213        | 40		|236		 |230		 |
       |215	       | 206		|237		 |40		 |
       |217	       | 244		|240		 |215		 |
       |220	       | 250		|241		 |275		 |
       |221	       | 251		|243		 |340		 |
       |222	       | 210		|244		 |344		 |
       |225	       | 217		|245		 |343		 |
       |226-227        | 40		|246		 |253		 |
       |230	       | 227		|247		 |276		 |
       |233	       | 40		|250-375	 |40		 |
       |227	       | 327		|		 |		 |
       +---------------+----------------+----------------+---------------+

   Mazovia to DHN
       For the conversion of Mazovia to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   Mazovia     |      DHN	|   Mazovia	 |     DHN	 |
       |200-205        | 40		|234		 |203		 |
       |206	       | 211		|236		 |217		 |
       |207-214        | 40		|240		 |207		 |
       |215	       | 212		|241		 |210		 |
       |216	       | 40		|242		 |216		 |
       |217	       | 200		|243		 |205		 |
       |220	       | 202		|244		 |215		 |
       |221	       | 214		|246		 |220		 |
       |225	       | 201		|247		 |221		 |
       |230	       | 206		|		 |		 |
       +---------------+----------------+----------------+---------------+

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_maz(5)
All times are GMT -4. The time now is 02:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy