Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to insert date in a statement?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to insert date in a statement?
# 1  
Old 07-09-2011
How to insert date in a statement?
Hi Guys,

Can somebody help me in inserting today's DATE format (20110709) in my awk statement. I have a script but its not working.


inputfile.txt:
Code:
269,1,0,AAA,430
231,2,0,BBB,430
252,3,0,CCC,430
214,4,0,DDD,430



script.sh
Code:
#!/bin/bash
DATE="`date +%Y%m%d`"
cd /var/opt/
awk -F"," '{if($5==430) print $1",,,TEST,1,1,8,$DATE"}' inputfile.txt

But it's not giving me my desired output. The DATE is not showing.


DESIRED OUTPUT:
Code:
269,,,TEST,1,1,8,20110709
231,,,TEST,1,1,8,20110709
252,,,TEST,1,1,8,20110709
214,,,TEST,1,1,8,20110709



Thanks in advance.


Br,
Pinpe
# 2  
Old 07-09-2011
Use this AWK line:
Code:
awk -F"," -vDATE=$DATE '{if($5==430) print $1",,,TEST,1,1,8,"DATE}' inputfile.txt

# 3  
Old 07-09-2011
Quote:
Originally Posted by bartus11
Use this AWK line:
Code:
awk -F"," -vDATE=$DATE '{if($5==430) print $1",,,TEST,1,1,8,"DATE}' inputfile.txt

Hi bartus,

This is great! Thanks! But what if I want to put the DATEfor tomorrow like this format 20110710

Thanks again in advance. Really appreciate your help.


Br,
Pinpe
# 4  
Old 07-09-2011
From the first link in Google:
Code:
date -d tomorrow +%Y%m%d

# 5  
Old 07-09-2011
Quote:
Originally Posted by bartus11
From the first link in Google:
Code:
date -d tomorrow +%Y%m%d

Hi bartus,

It is giveing me error as shown below.

Code:
root>date -d tomorrow +%Y%m%d
date: illegal option -- d
usage:  date [-u] mmddHHMM[[cc]yy][.SS]
        date [-u] [+format]
        date -a [-]sss[.fff]


Thanks.


Br,
Pinpe
# 6  
Old 07-09-2011
What system are you using?
# 7  
Old 07-09-2011
Quote:
Originally Posted by bartus11
What system are you using?

Hi bartus,

Sun Microsystems Inc. SunOS 5.10
UNIX

Br,
pinpe
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Single quotes insert statement using awk

Hi, Need help, using awk command to insert statement awk -v q="'" '{ print "db2 connect to repolab > /dev/null; " "\n" "db2 -x \" select name from IBMPDQ.PROFILE where managed_database = " q $1"_"$3"__0" q "\"" } ' profile.txt | sh - | awk -v i="'" ' { print "db2 connect to repolab >... (1 Reply)
Discussion started by: Mathew_paul
1 Replies

2. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies

3. Shell Programming and Scripting

How to insert numbers to a in between statement

Hi Guys, I want to create a shell script that will give me the output below. I want to insert the numbers from the input file to my url addresses below. And from the numbers below, I want to separate the last digit with a period (i.e. from 222222222222 to 22222222222.2). Appreciate any help.... (14 Replies)
Discussion started by: pinpe
14 Replies

4. Programming

Assign variable for INSERT INTO statement

Hello, Can anyone tell me that, How can I assign variable to shell script variable, which i need to use in INSERT INTO statement? my shell script variables are, EMPNAME=`regular expression` EMPID=`regular expression` EMPBDATE=`regular expression` Now through ksh script I am... (16 Replies)
Discussion started by: Poonamol
16 Replies

5. Programming

Dynamic Insert statement

I have a form , where i will put the values to a table. I wrote a insert statement for the same. Table structure is ename | character varying(30) | eadd | character varying(30) | eid | integer | sal | integer In the statements, i don't... (1 Reply)
Discussion started by: pritish.sas
1 Replies

6. Shell Programming and Scripting

error in insert statement

hi, When i try to run the code below, i get the following error "ksh: syntax error: `(' unexpected" i am not able to figure it out. Can anyone help me? Code: (2 Replies)
Discussion started by: ragavhere
2 Replies

7. Shell Programming and Scripting

How is use sselect statement o/p in insert statement.

Hi All, I am using Unix ksh script. I need to insert values to a table using the o/p from a slelect statement. Can anybody Help! My script looks like tihs. ---`sqlplus -s username/password@SID << EOF set heading off set feedback off set pages 0 insert into ${TB_NAME}_D... (2 Replies)
Discussion started by: nkosaraju
2 Replies

8. Shell Programming and Scripting

Script does not execute Insert Statement

Hi I have a text file , contents are Line1:field1,field2,field3,field4,field5,field6.......field20 Line2:field1,field2,field3,field4,field5,field6.......field20 Line3:field1,field2,field3,field4,field5,field6.......field20 ....and so on... I want to read this file and insert the data into... (4 Replies)
Discussion started by: Amruta Pitkar
4 Replies

9. Shell Programming and Scripting

Insert TAB in echo statement

Hi, Can some1 help me to output a tab in an echo statement. I have tried echo "RNC: \t NODEB" but dont get the correct output. I am a beginnger to unix, so pls hold back the laughs....if u can (5 Replies)
Discussion started by: sunils27
5 Replies

10. Shell Programming and Scripting

awk command for INSERT statement

Hi, I sometimes bulk upload data in oracle. The problem is that I sometimes get an INSERT statemnt like this: INSERT INTO ALL_USER_HOTSPOT_DETAILS (USR_LOGIN,USR_LASTNAME,USR_FIRSTNAME,USR_EMAIL, PROPERTYNR) VALUES ('SABRDAG','D'AGOS','SABRINA','sabrina_d'agos@sheraton.com',70) I... (4 Replies)
Discussion started by: nattynatty
4 Replies
Login or Register to Ask a Question