[SOLVED] Need help with string manipulation. (sed or awk)

beckss · 03-06-2012, 07:15 AM

Hi.
I need a help with transform strings (for example 12Jun2011) to mm/dd/yyyy format.
I can make extraction of Jun by setting case clause, but when I try to use awk with match I can't transfer to it substitution (I mean $month)

stas=12Jun2012
echo $stas | awk 'match($0,"Jun"){print substr($0,0,RSTART-1)}'
--
12
echo $stas | awk 'match($0,"Jun"){print substr($0,RSTART+3)}'
--
2012
But I need use Jun as parameter for next calculation.

Please advice and thanks for all.
Best regards, Stas

grail · 03-06-2012, 07:20 AM

How about:

Code:

 date -d 12Jun2011 '+%d/%m/%Y'

beckss · 03-06-2012, 07:24 AM

Hi
Thanks for you quick replay.
Not need case, not need addtional calculations.
Thank you again.
Stas.

beckss · 03-06-2012, 07:35 AM

Hi
But addtional question about awk/sed
If in the future I need use parameter (as I described) how I can make this.
Thanks and best regards, Stas.

grail · 03-06-2012, 07:54 AM

Use -v option in awk

beckss · 03-06-2012, 08:58 AM

Can you give me small example for this option.
Thanks Stas

catkin · 03-06-2012, 09:25 AM

If the day-of-month is always two characters:

Code:

stas=12Jun2012

day_of_month=${stas:0:2}
mon=${stas:2:3}
yyyy=${stas:5:4}

grail · 03-06-2012, 10:56 AM

Code:

stas=12Jun2012

awk -vdate=$stas 'BEGIN{print date}'