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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment