Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date from filename inserted into records
Top Forums UNIX for Beginners Questions & Answers Date from filename inserted into records Post 302975777 by spirospap on Saturday 18th of June 2016 04:47:40 PM
Old 06-18-2016
Hello,

Re kernel please see below:
Code:
Spiross-MBP:AIRTEMP spirospap$ uname -a
Darwin Spiross-MBP.fios-router.home 15.5.0 Darwin Kernel Version 15.5.0: Tue Apr 19 18:36:36 PDT 2016; root:xnu-3248.50.21~8/RELEASE_X86_64 x86_64

The file contents look like this:
Code:
Spiross-MBP:AIRTEMP spirospap$ head CPK2004001
Month:, 01/2004
Station Name:, "CENTRAL PARK" Call Sign:, NYC
Day,Time,StationType,Maint Indic,SkyConditions,Visibility,Weather Type,Dry Bulb Faren,Dry Bulb Cel,Wet Bulb Faren,Wet Bulb Cel,Dew Point Faren,Dew Point Cel,Rel Humd,Wind Speed,Wind Dir,Wind Char Gusts,Val. for Wind Char,Station Pressure,Press Tend,Sea Level Pressure,Report Type,Precip Total
01,0051,AO2 ,-,CLR                                          ,10SM   ,-,41   ,   5.0,-,   2.1,28   ,  -2.2, 60 , 6   ,VRB,-,0  ,29.92,5,180,AA,-
01,0151,AO2 ,-,CLR                                          ,10SM   ,-,41   ,   5.0,-,   2.2,28   ,  -2.2,

I only need fields 1, 2 and 9 which contain Day of the Month, Hour and Temperatures in Degrees Celsius (labeled Dry Bulb Cel). I can do this by using the code below:
Code:
Spiross-MBP:AIRTEMP spirospap$ awk -F"," '{ print $1, $2, $9 }' CPK2004001 >CPK2004001.txt
Spiross-MBP:AIRTEMP spirospap$ head CPK2004001.txt 
Month:  01/2004 
Station Name:  "CENTRAL PARK" Call Sign: 
Day Time Dry Bulb Cel
01 0051    5.0
01 0151    5.0
01 0251    5.0
01 0351    5.6
01 0451    5.0
01 0551    5.0
01 0651    3.9

Eventually, I would like to have the first field (DAY) in Julian days like this:
Code:
Month:  01/2004 
Station Name:  "CENTRAL PARK" Call Sign: 
Julian Time Dry Bulb Cel
001 0051    5.0
001 0151    5.0
001 0251    5.0
001 0351    5.6
001 0451    5.0
001 0551    5.0
001 0651    3.9
......
001 2351
002 0051   4.0
002 0151   5.0
etc...
002 0151

I hope this clarifies
Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

filename to contain date

hello, can anyone tell me how to rename a filename in a script to contain the current date? i have searched for the answer but with little success! many thanks rkap (4 Replies)
Discussion started by: rkap
4 Replies

2. Shell Programming and Scripting

display filename with date

Hi buddies, I have a doubt. I want to display filename with date in the following format.Is there any way to do this. Kindly give me the solution. I want to display the result in the following manner. test1.txt 03/28/2008 testlog.log 02/20/2008 Please let me know one solution how to do... (1 Reply)
Discussion started by: pstanand
1 Replies

3. Shell Programming and Scripting

Get date from filename

Hi all, I have this files: aaa20080714.log bbbb20080714.log ccccccc20080714.log Can i get the 20080714 from each file? (6 Replies)
Discussion started by: icy_blu_blu
6 Replies

4. UNIX for Dummies Questions & Answers

Date in filename

how do i add the date for the filename? for example filename20080917 (3 Replies)
Discussion started by: khestoi
3 Replies

5. Shell Programming and Scripting

date from filename

Hi all I have the following question: With this command, I get the latest file in a directory. lastfile =`ls -1tr | tail -n 1` echo $lastfile The output is then: partner131210.txt (meaning 13th December 2010) My goal is to get the date into a variable and to obtain a final variable... (4 Replies)
Discussion started by: davis77
4 Replies

6. Shell Programming and Scripting

Get the oldest date based on date in the filename

I am using ksh93 on Solaris. Ok, this may seem like a simple request at first. I have a directory that contains sets of files with a YYYYMMDD component to the name, along with other files of different filespecs. something like this: 20110501_1.dat 20110501_2.dat 20110501_3.dat... (2 Replies)
Discussion started by: gary_w
2 Replies

7. UNIX for Advanced & Expert Users

query display number lines or records present in file only numeric value -without filename

Hi all Thanks in advance........... Please help me for this issue............ I have a file it has 11 records . I used the command like .... >$ wc -l file 11 file I'm getting output like 11 file (no.of records along with filename) here my requirement is, I want to display only... (3 Replies)
Discussion started by: ksrivani
3 Replies

8. Shell Programming and Scripting

How to append date to filename, but base it on yesterday's date?

Hello, I'd like to write a monthly archive script that archives some logs. But I'd like to do it based on yesterday's date. In other words, I'd like to schedule the script to run on the 1st day of each month, but have the archive filename include the previous month instead. Here's what I... (5 Replies)
Discussion started by: nbsparks
5 Replies

9. Shell Programming and Scripting

Comparing two files to get only records to be inserted and updated

Hello all, Please help me for a script that compares two files and reads only those records that are to be inserted and updated. File1: c_id name place contact_no 1 abc xyz 34567 10 efg uvw 82725 6 hjk wth 01823 2 iuy ... (4 Replies)
Discussion started by: T@ni@
4 Replies

10. UNIX for Beginners Questions & Answers

How to change existing date to current date in a filename?

Suppose i have a list of files in a directory as mentioned below 1. Shankar_04152019_ny.txt 2. Gopi_shan_03122019_mi.txt 3. Siva_mourya_02242019_nd.txt .. . . . . 1000 . Jiva_surya_02282019_nd.txt query : At one shot i want to modify the above all filenames present in one path with... (4 Replies)
Discussion started by: Shankar455
4 Replies

LEARN ABOUT REDHAT

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)
All times are GMT -4. The time now is 10:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy