Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Changing CSV files with date . Subtracting date by values
Top Forums UNIX for Beginners Questions & Answers Changing CSV files with date . Subtracting date by values Post 303025465 by arunkumar_mca on Friday 2nd of November 2018 05:17:10 PM
Old 11-02-2018
It worked partially
Code:
(K>)  awk -f change.awk input.csv
id,description,type,year
994475;1832 +  S PP1829 10/17/18;S;P201829;115;N;4,4;M;0;xx994475;*;BA7005;10/17/2018 16:48
994477;1836 +  S PP1833 10/17/18;S;P201833;115;N;4,4;M;0;xxh994477;*;BA7005;10/17/2018 16:48
994479;CONTROL 1452-1527,1552-1627;S;P201522;115;N;4,4;M;0;RHS_12_1510FF_0706;*;B7005;10/17/2018 16:49

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
 

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 (1 Reply)
Discussion started by: rameshspal
1 Replies

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... (0 Replies)
Discussion started by: roadcyclist
0 Replies

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 Replies)
Discussion started by: monkfan
4 Replies

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... (1 Reply)
Discussion started by: St.Fartatric
1 Replies

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. (13 Replies)
Discussion started by: Annorax
13 Replies

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... (2 Replies)
Discussion started by: siteregsam
2 Replies

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... (3 Replies)
Discussion started by: ottsm
3 Replies

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. (2 Replies)
Discussion started by: Anupam_Halder
2 Replies

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" '... (3 Replies)
Discussion started by: Rahul Raj
3 Replies

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... (5 Replies)
Discussion started by: invinzin21
5 Replies

LEARN ABOUT CENTOS

claswp

claswp.f(3)							      LAPACK							       claswp.f(3)

NAME

       claswp.f -

SYNOPSIS

   Functions/Subroutines
       subroutine claswp (N, A, LDA, K1, K2, IPIV, INCX)
	   CLASWP performs a series of row interchanges on a general rectangular matrix.

Function/Subroutine Documentation
   subroutine claswp (integerN, complex, dimension( lda, * )A, integerLDA, integerK1, integerK2, integer, dimension( * )IPIV, integerINCX)
       CLASWP performs a series of row interchanges on a general rectangular matrix.

       Purpose:

	    CLASWP performs a series of row interchanges on the matrix A.
	    One row interchange is initiated for each of rows K1 through K2 of A.

       Parameters:
	   N

		     N is INTEGER
		     The number of columns of the matrix A.

	   A

		     A is COMPLEX array, dimension (LDA,N)
		     On entry, the matrix of column dimension N to which the row
		     interchanges will be applied.
		     On exit, the permuted matrix.

	   LDA

		     LDA is INTEGER
		     The leading dimension of the array A.

	   K1

		     K1 is INTEGER
		     The first element of IPIV for which a row interchange will
		     be done.

	   K2

		     K2 is INTEGER
		     The last element of IPIV for which a row interchange will
		     be done.

	   IPIV

		     IPIV is INTEGER array, dimension (K2*abs(INCX))
		     The vector of pivot indices.  Only the elements in positions
		     K1 through K2 of IPIV are accessed.
		     IPIV(K) = L implies rows K and L are to be interchanged.

	   INCX

		     INCX is INTEGER
		     The increment between successive values of IPIV.  If IPIV
		     is negative, the pivots are applied in reverse order.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   September 2012

       Further Details:

	     Modified by
	      R. C. Whaley, Computer Science Dept., Univ. of Tenn., Knoxville, USA

       Definition at line 115 of file claswp.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.2							  Tue Sep 25 2012						       claswp.f(3)
All times are GMT -4. The time now is 11:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy