Can we use TRIM in WRKQRY?

15 pts.
Tags:
TRIM function
Work with Query
WRKQRY
I am formaing up one field in Define Result Fields Field JOBNM Expression x9jbno||'/'||x9jbus||'/'||x9jbnm Here can I use TRIM function with x9jbus filed to avoid blanks If anybody knows pls let me know at pankajmahajan@hsbc.co.in

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes, you use the VARCHAR function when defining your field

<pre>VARCHAR(x9jbno)||’/’||VARCHAR(x9jbus)||’/’||VARCHAR(x9jbnm) </pre>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Gilly400
    Hi, If you use VARCHAR you still get the blanks from your original field in your result field. If you try using LENGTH and then substring for the length of the command you also get the blanks. I don't think this is possible in normal Query/400 - maybe with QM Query? (afraid that's something I don't know too much about). Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • Pankaj2rmca
    Yes I agree with Martin as I have tried in my Query. One sample example I am giving you: When I am giving JOBNM varchar(x9jbno)||'/'||varchar(x9j bus)||'/'||varchar(x9jbnm) then result is coming as 043800 /Profile /LBULL10HUB that is blank after 1st and 2nd field that is not required. I have thousands of similar data Thanks and regards Pankaj MAHAJAN
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following