Visit Our UNIX and Linux User Community


Need to append the date | abcddate.txt to the first line of my txt file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to append the date | abcddate.txt to the first line of my txt file
# 1  
Old 08-07-2013
Need to append the date | abcddate.txt to the first line of my txt file

I want to add/append the info in the following format to my.txt file.

20130702|abcd20130702.txt FN|SN|DOB

I tried the below script but it throws me some exceptions.
Code:
<#!/bin/sh
dt = date '+%y%m%d'members;
echo $dt+|+members+$dt;
/usr/bin/awk -f
BEGIN { FS="|"; OFS="|"; } { print $1,$2,$5};>

Can some one please heelp me to sort this out.

Thanks,
Harry

Last edited by Franklin52; 08-08-2013 at 03:21 AM.. Reason: Please use code tags
# 2  
Old 08-07-2013
Please post a sample of the input and desired output...
# 3  
Old 08-07-2013
the input of the file looks like below and the file type is .txt
first Line in the abcd.txt is as follows

FN|LN|DOB|ADDRESS|ZIP

The out put should be the same abcd.txt file and the first line should looks like below

20130807|abcd20130807.txtFN|LN|DOB|ADDRESS|ZIP

Thanks
# 4  
Old 08-07-2013
Code:
#!/bin/bash

v_file="abcd.txt"
v_date="$( date +%Y%m%d )"
v_memb="${v_file%.*}"
v_memb="${v_memb}${v_date}.txt"

while read line
do
        echo "${v_date}|${v_memb}${line}"
done < "$v_file"

# 5  
Old 08-07-2013
Thanks Yoda for your reply,

But some how the script is throwing some exceptions.

I am trying to run this as a AWK script and it throws exceptions.

The file name I am getting is abcd.txt and I need to append the
Code:
20130807|abcd20130807.txtFN|LN|DOB|ADDRESS|ZIP

to the first line.. so I am running a awk script to do this...

I created a awk script like below
Code:
#!/usr/bin/awk -f
BEGIN {system("date '+%d%m%Y''|abcd.")system("date '+%d%m%Y'.txt");FS="|"; OFS="|"; } { print $1,$2,$3,$6,$5};

But the out put I am getting like below
Code:
07082013|abcd
07082013.txt
FN|LN|DOB|ADDRESS|ZIP

I just want to get this in a single line.

Thanks

Last edited by Franklin52; 08-08-2013 at 03:21 AM.. Reason: Please use code tags
# 6  
Old 08-07-2013
Try this:
Code:
awk -v DT="$(date +%Y%m%d)" '{print DT,"abcd"DT".txt"$0}' OFS=\| abcd.txt

Output:
Code:
20130807|abcd20130807.txtFN|LN|DOB|ADDRESS|ZIP

# 7  
Old 08-07-2013
I tried the code, it works, but it appends the syntax to all the lines. I just want to put this in the very first line.
May be some small changes needs to be done Smilie

Previous Thread | Next Thread
Test Your Knowledge in Computers #432
Difficulty: Medium
As of May 2017, 94.5% of the 10 million most popular web pages used JavaScript, according to w3techs.com.
True or False?

10 More Discussions You Might Find Interesting

1. Programming

[Python] replicating "sha256 -C checksum_file.txt file.txt"

Hello everyone, Since my python knowledge is limimted, I've challenged myself to learn as much as possible to help me with my carrere. I'm currently trying to convert a shell script to python, just to give myself a task. There is one section of the script that I'm having issues converting and... (2 Replies)
Discussion started by: da1
2 Replies

2. Shell Programming and Scripting

Bash incert line from 1.txt to 2.txt

i would like to insert a line from 2.txt into 1.txt between " and " or a way of adding to the end of each line " _01_ and have the numbers correspond to the line # 1.txt= foofoo "" _01_ foofoo "" _02_ foofoo "" _03_ foofoo "" _04_ 2.txt= ... (6 Replies)
Discussion started by: klein
6 Replies

3. UNIX for Dummies Questions & Answers

Split Every Line In Txt Into Separate Txt File, Named Same As The Line

Hi All Is there a way to export every line into new txt file where by the title of each txt output are same as the line ? I have this txt files containing names: Kandra Vanhooser Rhona Menefee Reynaldo Hutt Houston Rafferty Charmaine Lord Albertine Poucher Juana Maes Mitch Lobel... (2 Replies)
Discussion started by: Nexeu
2 Replies

4. Shell Programming and Scripting

Desired output.txt for reading txt file using awk?

Dear all, I have a huge txt file (DATA.txt) with the following content . From this txt file, I want the following output using some shell script. Any help is greatly appreciated. Greetings, emily DATA.txt (snippet of the huge text file) 407202849... (2 Replies)
Discussion started by: emily
2 Replies

5. Shell Programming and Scripting

awk append fileA.txt to growing file B.txt

This is appending a column. My question is fairly simple. I have a program generating data in a form like so: 1 20 2 22 3 23 4 12 5 43 For ever iteration I'm generating this data. I have the basic idea with cut -f 2 fileA.txt | paste -d >> FileB.txt ???? I want FileB.txt to grow, and... (4 Replies)
Discussion started by: theawknewbie
4 Replies

6. Shell Programming and Scripting

command to list .txt and .TXT file

Hi expersts, in my directory i have *.txt and *.TXT and *.TXT.log, *.txt.log I want list only .txt and .TXT files in one command... how to ?? //purple (1 Reply)
Discussion started by: thepurple
1 Replies

7. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies

8. UNIX for Dummies Questions & Answers

Binary txt file received when i use uuencode to send txt file as attachment

Hi, I have already read a lot of posts on sending attachments in unix...but none of them were of help for my problem...so here goes.. i wanna attach a text file and send to a mail id..used the following code : uuencode "$File1" "$File1" ;|mail -s "$Mail_sub" abc@abc.com it works... (2 Replies)
Discussion started by: ash22
2 Replies

9. UNIX for Dummies Questions & Answers

echo "ABC" > file1.txt file2.txt file3.txt

Hi Guru's, I need to create 3 files with the contents "ABC" using single command. Iam using: echo "ABC" > file1.txt file2.txt file3.txt the above command is not working. pls help me... With Regards / Ganapati (4 Replies)
Discussion started by: ganapati
4 Replies

10. Shell Programming and Scripting

Need a script to Append date to generated .txt file

Hi, Can anyone plz share their experience with - Building shell script to append the file with date in following format- Filename_MMDDYYYY.txt Thanks in advance (2 Replies)
Discussion started by: prince_of_focus
2 Replies

Featured Tech Videos