Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date to Day in loop
Top Forums Shell Programming and Scripting Date to Day in loop Post 302756265 by nua7 on Tuesday 15th of January 2013 01:46:36 PM
Old 01-15-2013
Date to Day in loop
Hi All,
I have a file in the following format.I need to pick up 25th field which is a date and convert it into a day and add it as a field in the file.

Code:
"AAGENAS,PEARL L"|"S00834219"|"131186147D"|"SUP"|"600"|""|"00001236BIME"|DIAMOND|"PROVIDER|"NC|"20110824"|"733.90"|"V76.12"|"786.2"|"490"|"627.2"|""|""|""|""|"6125"|"20110827"|"20110826"|"20110826"|"N|"6125"|"Prev Rad:Bone Density(MS)"|"P"|"P"|"I"
"AARENS,MIMI"|"S00462243"|"110262446A"|"H2256"|""|""|"00001293B3IV"|DIAMOND|"PROVIDER|"C|"20111020"|"786.2"|""|""|""|""|""|""|""|""|"6120"|"20111021"|"20111021"|"20111022"|"N|"6120"|"Radiology-MF POS"|"P"|"P"|"I"
"AARENS,MIMI"|"S00462243"|"110262446A"|"H2256"|""|"GEOGRAPHIC LOCATION INCONVENIENT"|"00001293B3IV"|DIAMOND|"PROVIDER|"C|"20111020"|"786.2"|""|""|""|""|""|""|""|""|"6120"|"20111021"|"20111021"|"20111021"|"N|"6120"|"Radiology-MF POS"|"P"|"P"|"I"

I have the code which converts date to day in perl, but not sure how to put this in the loop.

Code:
perl -e '
		use POSIX qw(strftime);
		$fmt = "%A";  # %a = abbreviated weekday %u = weekday number	
		$mday = substr("$ARGV[0]", 6, 2);
		$mon =  substr("$ARGV[0]", 4 ,2);
		$year = substr("$ARGV[0]", 0 ,4);
		$weekday =
		  strftime($fmt, 0, 0, 0, $mday , $mon - 1, $year - 1900, -1, -1, -1);
		print "$weekday";
		' 20110827

Also since the file has thousands of records , I am not sure if perl is the right way to go.

Any help will be appreciated.

Desired format of the file

Code:
"AAGENAS,PEARL L"|"S00834219"|"131186147D"|"SUP"|"600"|""|"00001236BIME"|DIAMOND|"PROVIDER|"NC|"20110824"|"733.90"|"V76.12"|"786.2"|"490"|"627.2"|""|""|""|""|"6125"|"20110827"|"20110826"|"20110826"|"Friday"|"N|"6125"|"Prev Rad:Bone Density(MS)"|"P"|"P"|"I"
"AARENS,MIMI"|"S00462243"|"110262446A"|"H2256"|""|""|"00001293B3IV"|DIAMOND|"PROVIDER|"C|"20111020"|"786.2"|""|""|""|""|""|""|""|""|"6120"|"20111021"|"20111021"|"20111022"|"Saturday"|"N|"6120"|"Radiology-MF POS"|"P"|"P"|"I"
"AARENS,MIMI"|"S00462243"|"110262446A"|"H2256"|""|"GEOGRAPHIC LOCATION INCONVENIENT"|"00001293B3IV"|DIAMOND|"PROVIDER|"C|"20111020"|"786.2"|""|""|""|""|""|""|""|""|"6120"|"20111021"|"20111021"|"20111021"|"Friday"|"N|"6120"|"Radiology-MF POS"|"P"|"P"|"I"

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting day from a date...

Hi, I have a date input in MMDDYYYY format.. I have to give the day (whether that DD is sunday/monday...) Is there any command for it... Or do I have to write a script for that... Thanks in Advance Yeheya (1 Reply)
Discussion started by: yeheyaansari
1 Replies

2. UNIX for Dummies Questions & Answers

date - 1 day

Hi, I have been trying just about every unix command to come up with yesterday's date (today's date - 1). I have seen all of the help on this forum, and none of it seems to work for me here. We are using Sun Solaris 9 Unix. I am using this script to create a .txt file with ftp commands that I will... (2 Replies)
Discussion started by: sfedak
2 Replies

3. Shell Programming and Scripting

how to obtain date and day of the week from `date` command

Hi, does anybody know how to format `date` command correctly to return the day of the week? Thanks -A I work in ksh.... (1 Reply)
Discussion started by: aoussenko
1 Replies

4. UNIX for Dummies Questions & Answers

Getting date -1 day not using GNU date

It's easy as pie to get the date minus one day on opensolaris: date -d "-1 day" +"%Y%m%d"run this command on our crappy Solaris 10 machines however (which I'm guessing doesn't have GNU date running on it) and you get: date: illegal option -- d date: illegal option -- 1 date: illegal option --... (5 Replies)
Discussion started by: rich@ardz
5 Replies

5. Shell Programming and Scripting

finding the previous day date and creating a file with date

Hi guys, I had a scenario... 1. I had to get the previous days date in yyyymmdd format 2. i had to create a file with Date inthe format yyyymmdd.txt format both are different thanks guys in advance.. (4 Replies)
Discussion started by: apple2685
4 Replies

6. Shell Programming and Scripting

To Get the day of given date in aix

Hi, Can any one help to find out the day for the given date in AIX. If we giving date as "YYYYMMDD" it should display its day. eg:if the input is "20120103", expected output is "tuesday" :wall: Pls help (7 Replies)
Discussion started by: novaothers
7 Replies

7. AIX

Need to get the next day's date of the user entered date

I need to get the next day's date of the user entered date for example: Enter date (yyyy/mm/yy): 2013/10/08I need to get the next day's date of the user entered date Desired Output: 2013/10/09Though there are ways to achieve this is Linux or Unix environment (date command) ,I need to... (1 Reply)
Discussion started by: rpm120
1 Replies

8. Shell Programming and Scripting

Adding one day to a date

Hi All, I want to add one day to a date and store it in a variable. From GUI we are passing value (last day of the month)to $t_date. This $t_date will give me the value like this %Y%m%d 20150531. Now I want to add one day to this value and store it in a variable "datein". datein should... (8 Replies)
Discussion started by: ROCK_PLSQL
8 Replies

9. Shell Programming and Scripting

Need to minus one day from a date given

Hello Folks, I have a variable output holding date as below - output = "20141220" I need to extract a day out of it and store it in another variable i.e. something similar to below - output1=20141219" and if the month is changing i.e. date in on 31st or 1st it should be taken care of "date... (5 Replies)
Discussion started by: ektubbe
5 Replies

10. UNIX for Beginners Questions & Answers

Replace date in file every day with current date

I Have text like XXX_20190908.csv.gz need to replace Only date in this format with current date every day Thanks! (1 Reply)
Discussion started by: yamasani1991
1 Replies
All times are GMT -4. The time now is 06:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy