?
Solved

In SQR, how do I remove special character from a selected field and replace it with a space.

Posted on 2008-09-29
1
Medium Priority
?
1,459 Views
Last Modified: 2012-06-21
I am writing an SQR and extracting data from a PeopleSoft record and creating a text file.  One of the fields is PS_LAST_NAME and I need to exclude the hyphen from the name and print a space instead.
0
Comment
Question by:VanBro
1 Comment
 

Accepted Solution

by:
VanBro earned 0 total points
ID: 22609812
I found resolution....translate
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month17 days, 12 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question