Login or Register to Ask a Question and Join Our Community


Emergency UNIX and Linux Support

Trying to add currrent date as the first the first column in the file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Homework and Emergencies Emergency UNIX and Linux Support Trying to add currrent date as the first the first column in the file
# 1  
Old 04-23-2012
Trying to add currrent date as the first the first column in the file
Hi Experts,

I am trying to add one variable value as the first value in a file speparated by "" (space) delimiter. Can you please let me know how I can do this using bash script.

Following is my file.
Code:
1635 ABCD 3m9ka COMPLETE
0526 AJAY 3m1da COMPLETE
0419 INDIA 3m3zi INCOMPLETE

The variable I want to add as the first column in the file is searchdate=`date "+%d/%m/%Y"`.

In Summary , currrent date should be added as the first the first column in the file.
FYI I am using SUN OS
Code:
uname -v
Generic_122300-60

Thanks,
Ajay
Last edited by zaxxon; 04-23-2012 at 07:36 AM.. Reason: code tags
# 2  
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!
# 3  
Old 04-23-2012
Hi ajaypatil_am,

One way using perl:
Code:
$ cat infile
1635 ABCD 3m9ka COMPLETE
0526 AJAY 3m1da COMPLETE
0419 INDIA 3m3zi INCOMPLETE
$ perl -ane 'my ($mday,$mon,$year) = (localtime)[3..5]; $date = sprintf q[%02d/%02d/%4d], ($mday, ++$mon, $year+=1900); printf qq[%s %s\n], $date, qq[@F]' infile
23/04/2012 1635 ABCD 3m9ka COMPLETE
23/04/2012 0526 AJAY 3m1da COMPLETE
23/04/2012 0419 INDIA 3m3zi INCOMPLETE

# 4  
Old 04-25-2012
Code:
 
searchdate=$(date "+%d/%m/%Y")
while read line
do
echo "$searchdate $line" >> output.txt
done  < input.txt

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question