Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Trying to add currrent date as the first the first column in the file
Homework and Emergencies Emergency UNIX and Linux Support Trying to add currrent date as the first the first column in the file Post 302628325 by pankaj_tarale on Monday 23rd of April 2012 09:43:28 AM
Old 04-23-2012
Hi Ajay,
Below is your answer by sed for date .
Code:
#!/bin/bash
  
searchdate=$(date +%d/%m/%Y)
  
sed -i "s|^|  $searchdate |" myfile


While number or character you can do directly as below:

Code:
sed -i 's/$/ 1000/' myfile

sed -i 's/^/ 1000/' myfile

Last edited by radoulov; 04-23-2012 at 10:47 AM.. Reason: Code tags, please!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Appending date value mmdd to first column in file

Hi , I have a file with a running sequence number. I need to append a date value mmdd format on to the first column. for e.g.: The file contains records as 001 abc 002 cde 003 edf 004 fgh 005 hik The output should be 1111001 abc 1111002 cde 1111003 edf 1111004 ... (1 Reply)
Discussion started by: kalyansid
1 Replies

2. Shell Programming and Scripting

Need to add letters to a column and add in a new column subtracting from another column

So I have this input 1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI 1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI 1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI 1 10583 rs58108140 G A ... (3 Replies)
Discussion started by: kellywilliams
3 Replies

3. UNIX for Dummies Questions & Answers

Delete a row from a file if one column containing a date is greater than the current system date

Hello gurus, I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4: NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies

4. Shell Programming and Scripting

Convert the date format from mdy to ymd in column of file

The date format in the delimited file for one column '6/27/2011 12:00:00 AM' Is it possible o change it to '2011-06-27 12:00:00 AM' for all the records.. Thanks in advance..... (8 Replies)
Discussion started by: infernalhell
8 Replies

5. Shell Programming and Scripting

Need to add a date column (today's date) in file

Hi I have file with number status and date1 and date1 field, want add a column today between column date1 and date2. file1.txt number status date1 date2 ===== ==== === ===== 34567 open 27/06/13 28/06/13 45678 open 27/06/13 28/06/13 43567 open 27/06/13 28/06/13 ... (1 Reply)
Discussion started by: vijay_rajni
1 Replies

6. UNIX for Advanced & Expert Users

Add file creation date as new column

Hi , I have a requirement to append file creation date to each row in a file for all the files in a directory. Please help Thanks, Pavan (2 Replies)
Discussion started by: Pavan Ram B S
2 Replies

7. Shell Programming and Scripting

How to change the format of the date column in a flat file?

Hi, i have a flat file namely temp.txt with this data below ID|name|contact_date 101|Kay|2013-12-26 102|let|2013-12-26 I need to modify the date data in the flat file into MM/DD/YYYY HH24:MI:SS format let me know the code for this. Thank you! (5 Replies)
Discussion started by: srikanth_sagi
5 Replies

8. Shell Programming and Scripting

How to awk or grep the last column in file when date on column contains spaces?

Hi have a large spreadsheet which has 4 columns APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96034 Storage Mgmt Team APM00111803814 server_2 96152 GWP... (6 Replies)
Discussion started by: kieranfoley
6 Replies

9. Shell Programming and Scripting

Get maximum per column from CSV file, based on date column

Hello everyone, I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this: 20170628-23:25:01,1,0,0,1,1,1,1,55,55,1 20170628-23:30:01,1,0,0,1,1,1,1,56,56,1 20170628-23:35:00,1,0,0,1,1,2,1,57,57,2 20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies

10. Shell Programming and Scripting

Adding an extra date column in UNIX file

Hi All, I have a file with only one column of data (without delimiter). For Ex: cat temp.txt 22055 21088 93840 30990 50990 50950 I want to insert an additional column with current date as value. So, i have used below command but didn't get the result as excepted. Could onyone over... (5 Replies)
Discussion started by: Suresh
5 Replies

LEARN ABOUT DEBIAN

replacekey

replacekey(1)						      General Commands Manual						     replacekey(1)

NAME

       replacekey - replace keywords in a FITS header

SYNOPSIS

       replacekey [options] <in>

DESCRIPTION

       replacekey is aimed at replacing keywords in a FITS file's header by new keywords provided by the user on the command-line.

ALGORITHM

       The  user  can provide a new_keyword, an old_keyword, a value and a comment.  first searchs for old_keyword if provided. If it finds it, it
       replaces the associated card by the new one (new_keyword=value/comment).  If old_keyword is either not found or	not  provided,	associated
       card by the new one (new_keyword=value/comment).  new_keyword has to be provided.

       Examples: You want to change the value of VALUE from 32 to 16 in myfile.fits: % replacekey -k "VALUE" -v "16" myfile.fits

       If  you	want  to  replace  the	card with the keyword OLD by "NEW = 3.14 / This is a usefull key" in myfile.fits: % replacekey -k "NEW" -v
       "3.14" -c "This is a usefull key" -K "OLD" myfile.fits

       If your do not care about the HISTORY cards you have in the header, and want to replace the first one by VALUE=32, you would do:
       % replacekey -k "VALUE" -v "32" -K "HISTORY" myfile.fits

OPTIONS

       -k or --key key
	      To provide the new keyword.

       -K or --old key
	      To provide the old keyword.

       -v or --val val
	      To provide the new value.

       -c or --com com
	      To provide the new comment.

SEE ALSO

       hierarch28 to convert HIERARCH ESO keywords to regular 8-char keywords.

FILES

       Files shall all comply with FITS format

BUGS

       Modifications are so far only possible in the main header, not in the extensions.

								    28 Oct 1999 						     replacekey(1)
All times are GMT -4. The time now is 01:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy