Re: awk and date command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Ann:

I'm assuming that the data file is "clean" i.e. NO extraneous lines (i.e. blank, non-printables, etc)

Use a printf statement as follows:

    printf "File No: CGA%03d\n",NR

A little explanation is in order with this one.  The "0" (zero) after the % sign indicates a zero pading.
The 3 indicates the "size" of the numeric pad.  The "d" indicated numeric integer.  The "\n" is newline.
The NR is an awk system variable for the current "record number."  Thus my stipulation before
about the other "stuff" in the file, i.e. blank lines, non-printables, lines before and after the textual body, etc

Hope this helps.

Regards,
Lou
P.S. Awk!  Awk!  Awk!  (that's supposed to be laughter) 

On Nov 22, 2007 1:20 PM, ann kok <annkok2001@xxxxxxxxx > wrote:
Thank you again

here is expectation output

eg:

awk -v DT=`date +%Y%m%d` program.awk record.txt

The result is


File No: CGA001
Name: AAA
Country: USA
Created: 20071122
Updated: 20071122


File No: CGA002
Name: BBB
Country: Australia
Created: 20071122
Updated: 20071122


File No: CGA003
Name: CCC
Country: England
Created: 20071122
Updated: 20071122


The program is program.awk

    BEGIN { RS = "\n" ; FS = "|" }

    {
          print "File No:", CGAxxx <=== how to
change?
          print "Name:", $1
          print "Country:", $2
          printf "Created: %s\n", DT
          printf "Updated: %s\n", DT
          print ""
    }


the record.txt is

AAA|USA
BBB|Australia
CCC|England


Thank you






--- Lou Spironello <lspironello@xxxxxxxxx> wrote:

> Hello Ann:
>
> man (g)awk
>
> :-)
>
> awk -v | --assign  <internal variable
> name>=<variable value> <other awk
> options and stuff>
>
>
> Not quite sure what you want to do do.  Can you show
> the resulting output or
> be a bit more specific.
>
>
> Regards,
> Lou
> On Nov 22, 2007 12:55 PM, ann kok
> <annkok2001@xxxxxxxxx> wrote:
>
> > Hi Lou
> >
> > Thank you very much
> >
> > One more question. how can I put the CGA number as
> > variable?
> >
> > eg: CGA001, CGA002..... when
> > i run the program
> >
> > awk -v CGA=`for loop` program.awk file.txt
> >
> > or any way to do it?
> >
> > Thank you again
> >
> >
> >
> > BEGIN { RS = "\n" ; FS = "|" }
> > {
> > print "File No.: CGA001
> > print ""
> > }
> >
> >
> > --- Lou Spironello <lspironello@xxxxxxxxx> wrote:
> >
> > > awk -v HST=`hostname` -f program.awk file.txt
> > >
> > > inside program.awk
> > > use:
> > >
> > >   printf "from: %s\n",HST
> > >
> > > Regards,
> > > Lou
> > >
> > > On Nov 21, 2007 3:41 PM, ann kok
> > > <annkok2001@xxxxxxxxx > wrote:
> > >
> > > > Thank you
> > > >
> > > > but i don't know how to put the hostname in
> awk
> > > > program
> > > >
> > > > eg: my program is "program.awk
> > > >
> > > > awk -f program.awk file.txt
> > > >
> > > > Thank you again
> > > >
> > > > BEGIN { RS = "\n" ; FS = "|" }
> > > >
> > > >  {
> > > > print "Name:", $9
> > > > print "Created: `date`"
> > > > print "from: `hostname`"
> > > > print ""
> > > > }
> > > >
> > > >
> > > > --- Lou Spironello < lspironello@xxxxxxxxx>
> wrote:
> > > >
> > > > > Hope this helps.
> > > > >
> > > > > echo "test" | awk -v mydate=`date +%Y%m%d`
> > > '{printf
> > > > > "standard input is
> > > > > %s\nmy variable value is %s\n",$1,mydate}'
> > > > >
> > > > > :-)
> > > > >
> > > > >
> > > > > Regards,
> > > > > Lou
> > > > >
> > > > > On Nov 21, 2007 12:22 PM, ann kok
> > > > > < annkok2001@xxxxxxxxx> wrote:
> > > > >
> > > > > > Hi all
> > > > > >
> > > > > > how can I print date in this date format?
> > > 20071122
> > > > > >
> > > > > > Can command "date, hostname" run in awk
> > > program
> > > > > > itself?
> > > > > >
> > > > > > program.awk
> > > > > >
> > > > > >     BEGIN { RS = "\n" ; FS = "|" }
> > > > > >
> > > > > >     {
> > > > > >           print "Name:", $9
> > > > > >           print "Created: `date`"
> > > > > >           print "from: `hostname`"
> > > > > >           print ""
> > > > > >     }
> > > > > >
> > > > > > Thank you
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
____________________________________________________________________________________
> > > > > > Be a better pen pal.
> > > > > > Text or chat with friends inside Yahoo!
> Mail.
> > > See
> > > > > how.
> > > > > > http://overview.mail.yahoo.com/
> > > > > >
> > > > > > --
> > > > > > fedora-list mailing list
> > > > > > fedora-list@xxxxxxxxxx
> > > > > > To unsubscribe:
> > > > >
> > >
> https://www.redhat.com/mailman/listinfo/fedora-list
> > > > > >
> > > > > > --
> > > > > fedora-list mailing list
> > > > > fedora-list@xxxxxxxxxx
> > > > > To unsubscribe:
> > > >
> > >
> https://www.redhat.com/mailman/listinfo/fedora-list
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
____________________________________________________________________________________
> > > > Get easy, one-click access to your favorites.
> > > > Make Yahoo! your homepage.
> > > > http://www.yahoo.com/r/hs
> > > >
> > > > --
> > > > fedora-list mailing list
> > > > fedora-list@xxxxxxxxxx
> > > > To unsubscribe:
> > >
> https://www.redhat.com/mailman/listinfo/fedora-list
> > > >
> > > > --
> > > fedora-list mailing list
> > > fedora-list@xxxxxxxxxx
> > > To unsubscribe:
> >
> https://www.redhat.com/mailman/listinfo/fedora-list
> >
> >
> >
> >
> >
>
____________________________________________________________________________________
> > Be a better pen pal.
> > Text or chat with friends inside Yahoo! Mail. See
> how.
> > http://overview.mail.yahoo.com/
> >
> > --
> > fedora-list mailing list
> > fedora-list@xxxxxxxxxx
> > To unsubscribe:
> https://www.redhat.com/mailman/listinfo/fedora-list
> >
> > --
> fedora-list mailing list
> fedora-list@xxxxxxxxxx
> To unsubscribe:
https://www.redhat.com/mailman/listinfo/fedora-list



     ____________________________________________________________________________________
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how.   http://overview.mail.yahoo.com/

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux