topic Re: Need help on date variable in Operating System - Linux

Need help on date variable

Gaby1110 — Wed, 21 Oct 2009 06:03:08 GMT

Hi,

Need your help.I need to get the date from the second line of a file

[devuser@vfabuser ~]$ head -n2 ETCTRN4010000A.092309.023021001.txt | tail -n1

02,3009483,121000248,1,090922,,,/
[devuser@vfabuser ~]$

If you see above, I need 090922 stored to a variable as ‘22-SEP-2009’

Please help.

Thanks
Gaby

Re: Need help on date variable

Goran Koruga — Wed, 21 Oct 2009 06:51:58 GMT

Hello.

| cut -d',' -f5

Regards,
Goran

Re: Need help on date variable

Jared Middleton — Wed, 21 Oct 2009 22:22:49 GMT

Once you have the initial value (090922) captured in a variable...

# Set var for test below
$ dt="090922"

You can convert the display format using 'date', e.g.:
$ date -d"${dt}" +"%d-%h-%Y"
22-Sep-2009

Re: Need help on date variable

Goran Koruga — Thu, 22 Oct 2009 04:17:54 GMT

Doh, I missed the part where you need this in a different format. See above for a solution.

info date

will give you more details how to use this with examples (or info coreutils -> date).

Regards,
Goran

Re: Need help on date variable

H.Becker — Thu, 22 Oct 2009 07:49:26 GMT

Just combining what was already said ...

You can write a small script and use a temporary variable to hold the digits, but you can also do this in one line:

dt=$(date -d $(head -n2 ETCTRN4010000A.092309.023021001.txt |tail -n1 |cut -d ',' -f5) +"%d-%h-%Y")

Re: Need help on date variable

Dennis Handly — Sat, 24 Oct 2009 03:55:57 GMT

A link to your same question on HP-UX, where you have to work harder:
http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1380285