Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Question Unanswered: query output format

    Hey all, another question with the same SQL line:

    AA$SIS$Get_superviser_name(std.superviser_number,s td.location,1)||','||

    If the record is empty for that field, SQL returns "***" However, if the field is full, it returns the superviser name. The output I have is formatted for csv and the superviser name comes back as:

    ***
    Smith, H
    Johnson, P
    ***
    Amid, D

    Is it possible to strip the comma from the Supervisor name records so that it will return:

    ***
    Smith H
    Johnson P
    ***
    Amid D

    ??

    Any help would be appreciated!
    Dee

  2. #2
    Join Date
    Oct 2003
    Location
    Chennai, India
    Posts
    2

    Re: query output format

    Originally posted by psdcc
    Hey all, another question with the same SQL line:

    AA$SIS$Get_superviser_name(std.superviser_number,s td.location,1)||','||

    If the record is empty for that field, SQL returns "***" However, if the field is full, it returns the superviser name. The output I have is formatted for csv and the superviser name comes back as:

    ***
    Smith, H
    Johnson, P
    ***
    Amid, D

    Is it possible to strip the comma from the Supervisor name records so that it will return:

    ***
    Smith H
    Johnson P
    ***
    Amid D

    ??

    Any help would be appreciated!
    Dee
    Hi dee,

    Use oracle replace function for the final output string

    ex : select replace(outputtext, ',',' ')

    regards

Posting Permissions

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