Changing CSV files with date . Subtracting date by values Post: 303025439

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Changing CSV files with date . Subtracting date by values Post 303025439 by Peasant on Friday 2nd of November 2018 11:36:57 AM

11-02-2018

Moderator

Fixed some typos..

I'm not sure i follow.
Input now is also inconsistent, with first two rows having 13 fields and last having 12.

Now you say you require fields 2,4 and 10, but on expected output you changed only field 4 for the first two lines and field 5 for the last line.

I have no idea what to do with 2,10, but we can work with 4 and 5 using awk match and regex.
Will it be a good guess now, or are we missing some input again ?

Code:

BEGIN {
FS=";"
mweek=52
}
#NR > 1 { # if we do not have header in our input ...
{
match($0,/P[12][0-9][0-9][0-9][0-5][0-9]/)
dw=substr($0,RSTART+1,RLENGTH-1)
year=substr(dw,1,4)
week=substr(dw,5,6)
variance=( year > 2015 ) ? 6 : 5

if ( int(week) == variance ) { week=mweek ; year=year - 1 ; sub(dw,year week,$0) }
else if ( int(week) < variance ) { week=mweek - (variance - week) ; year=year-1 ; sub(dw,year week,$0) }
else { week=sprintf("%02d",week - variance) ; sub(dw,year week,$0) }
} 1

Be sure other fields in line do not match P<year week regex>, since we are using $0

Please, read about NF, RSTART, RLENGTH here (for gawk, but is available on other awk(s) as well ) :
ftp://ftp.gnu.org/pub/old-gnu/Manual...11.html#SEC110

Regards
Peasant.

Last edited by Peasant; 11-02-2018 at 01:02 PM..

This User Gave Thanks to Peasant For This Post:

Peasant

View Public Profile for Peasant

Find all posts by Peasant

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

subtracting a days from current date

Hi i am trying to subtract days from current date. For example todays date is 10/03/2006. If i subtract 2 days it should give 8/03/2006. I am also trying to find the access date of a file in dd/mm/yyyy format. Can any one please help in how to do this. Ramesh

2. Shell Programming and Scripting

Subtracting date / timestamps

I have looked through the forums and found many date / time manipulation tools, but cannot seem to find something that fits my needs for the following. I have a log file with date time stamps like this: Jun 21 17:21:52 Jun 21 17:24:56 Jun 21 17:27:59 Jun 21 17:31:03 Jun 21 17:34:07 Jun...

3. UNIX for Dummies Questions & Answers

Changing Creation Date to a Prespecified Date of a File In Unix

Dear Expert, Is there a command to do that in Unix? In such a way that we don't need to actually "write" or modified the content. -- monkfan

4. UNIX for Dummies Questions & Answers

adding or subtracting days in the o/p of date

how can we add or subtract days from the output of date command in unix... like if i want to subtract a day from the result of date command like this.. v_date=`date +%Y%m%d` this wud give me 20080519 now i want to subtract one day from this.. so tht it wud give me 20080518.. how do i do...

5. UNIX for Dummies Questions & Answers

mv folders/files without changing modified date?

Hi all, I'm using Red Hat Linux and want to move some folders and files around but not change the modified date. Is this possible? I know cp has a -p flag which seems to do what I want, but this is a large volume of data so copying and deleting would not be feasible.

6. Shell Programming and Scripting

SQL one liner for subtracting 1 from date

I got a statement like below to subtract 1 from given date using teradata. I am looking for a one line unix command to perform the same. select 'parse_this_record', (DATE '${FILE_DATE}' - 1) (FORMAT 'YYYY-MM-DD'); Input: 2012-02-21 Expected Output: 2012-02-20 PS: One liner because I am...

7. Shell Programming and Scripting

Changing date format in CSV file

I have a CSV file with a date format like this; 11/19/2012 17:37:00,1.372,121.6 11/19/2012 17:38:00,0.743,121.6 Want to change the time stamp to seconds after 1970 so I can get the data in rrdtool. For anyone interested, this is data from a TED5000 unit and is Kwatts and volts. Needs to...

8. Shell Programming and Scripting

Adding/ Subtracting from Date

Hi , How can I add/substruct x number of days with date? For example My_Date=`date` Now I need Hope it's clear.

9. Shell Programming and Scripting

Subtracting months from passed Date

Hi All, I am getting a date from environment variable and want to do some processing by subtracting 2 months from the date passed through the environment variable. I am trying the following syntax : date_var=2014-08-31 date_2M_ago='$date_var+"%d%m%y" --$date_var="2 months ago" '...

10. Shell Programming and Scripting

Subtracting a date based on ls output

I am trying to achieve to get only the month and the day. Example Feb 5 (as you can see if it is feb 1-9) the space is 2. If it is feb 10-28, the space is only 1. I am trying to right a script that will list a directory and shoot an email if there is an activity in last 7 days. I dont really trust...

LEARN ABOUT CENTOS

sttime

sttime(3)                                                   ShapeTools Toolkit Library                                                   sttime(3)

NAME

       stMktime, stWriteTime - date and time handling

SYNOPSIS

       #include <config.h>
       #include <sttk.h.h>

       time_tstMktime (char *string);

       char*stWriteTime (time_t date);

DESCRIPTION

       stMktime scans the given string and tries to read a date and time from it. It understands various formats of date strings. The following is
       a list of all valid formats, optional parts in brackets.

       [Tue] Jan 5[,] [19]93
                     This includes the standard asctime(3) format.

       Jan 5         With no year given, the year defaults to the current year.

       [19]93/01/05  This notation requires month and day represented by exactly two digits.

       5.1.[19]93    This is the usual German notation.

       5.1.          German notation referencing the current year.

       A certain time, given together with the date must always have the following form.

       hours:minutes[:seconds]
                       Each of the fields must be an integer value within the proper range (hours: 0-23, minutes and seconds: 0-59). Values  below
                       10 may be written as one digit numbers.

       The  time  value  may be placed anywhere in the date string: at the beginning, at the end, or somewhere in the middle. Any amount of white-
       space may be given between a field of the time value and the separating colon. The time is always considered to be local time.

       stWriteTime generates a time string similar to asctime(3) from its date argument.

SEE ALSO

       asctime(3)

BUGS

       Time Zone Names within the time string (like `MET') are not handled properly. In most cases they will cause a failure.

sttk-1.7                                                     Thu Jun 24 17:43:35 1993                                                    sttime(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

subtracting a days from current date

Discussion started by: rameshspal

2. Shell Programming and Scripting

Subtracting date / timestamps

Discussion started by: roadcyclist

3. UNIX for Dummies Questions & Answers

Changing Creation Date to a Prespecified Date of a File In Unix

Discussion started by: monkfan

4. UNIX for Dummies Questions & Answers

adding or subtracting days in the o/p of date

Discussion started by: St.Fartatric