Monday, March 12, 2012

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!
DeeOriginally 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

No comments:

Post a Comment