Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Syracuse, NY
    Posts
    2

    Red face Unanswered: delimited output file

    I am doing a simple sql select statement:

    output to custfax.dat without headings
    select t_cuno, t_nama, t_tefx from custtable

    I need to use this in a subsequent unix script and would like to put a delimiter in between the fields so I can just awk them out.

    Is there a way to do this?

  2. #2
    Join Date
    Dec 2002
    Location
    Syracuse, NY
    Posts
    2

    Re: delimited output file

    [Ok. I found the answer to this... I'm using ":"
    however
    Now the output is on seperate lines because the name field is so large.

    Is there a way for me to get the first 15 characters of a 30 character field?

    tanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •