Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: NPI
  • Content: Threads
  • Order by date
  1. NPI

    avoiding cartesian results

    I am working with a 3 way join that is giving me a cartesian result that I do not want. :-( There are two unique IDs in A and B. C provides the translation from ID to NAME. The TIME is stored in both A and B. This query: select C.NAME, A.TIME, A.DATA1, A.DATA2, A.DATA3...
  2. NPI

    printing leading zeros

    How can I get awk to print out the leading zeros when padding a field width? The command: awk ' BEGIN{ v_nmbr=1 printf( "%3d\n", v_nmbr ) } ' outputs 1. I would like to get 001. We hope that this helps. Regards, NPI
    • NPI
    • Thread
    • Replies: 3
    • Forum: AWK

Part and Inventory Search

Back
Top