It worked partially
in the above output on row 1, column 2 it is still 1832 + S PP1829 10/17/18. It updated the part after + but 1832 should be 1816 that is not changed
In row 2 .column2 - It did't update update the same as above 1836 should be as 1830
in row 3 column 2 - ;CONTROL 1452-1527,1552-1627 not record is updated. It should be ;CONTROL 1446-1521,1545-1621
......
It updated the part after + but 1832 should be 1816 that is not changed
....
Is the above a mistake, since you posted subtraction bigger then 5 or 6 and above is 16 ?
Well you really gave me a challenge for one who doesn't code like this on a daily basis
This is surely growing into a monster without creating very big arrays and manipulating those in END condition.
Code assumes that the string RHS_12_1510FF_0706 will always have 4 values if separated by _ and started with RHS on $10 field
And on the same line $2 field will start with string CONTROL having 2 values if separated by space char.
Or to color a bit red string has two values when seperated by space, while blue string has 4 values when separated by _.
Lines which do not match both conditions (containing both blue and red) will not be processed by that specific code part (marked as green in whole program)
I'm trying to write this, so the program can run with small memory footprint on large files, keeping the original order in file untouched.
Hopefully others more experienced awkers can tell me if i succeeded or this is just a mess.
Feel free to chip in boys
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... (5 Replies)
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" '... (3 Replies)
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... (3 Replies)
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... (2 Replies)
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. (13 Replies)
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... (1 Reply)
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 Replies)
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... (0 Replies)
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 (1 Reply)