DSXchange

Posted: **Thu Sep 19, 2013 7:19 am**

Hi all,

My Input
-------
Jun Fujimoto/Singapore/IBM@IBMSG

output should be in (trim ,upper case and removal of the last characters after @) like

Output
-------

JUNFUJIMOTO/SINGAPORE/IBM

please provide the logic for this conversion.

Thanks

Posted: **Thu Sep 19, 2013 7:27 am**

Hi,

Try with Trim(),Upcase() and Field() functions.

----------------------------
Phani

Posted: **Thu Sep 19, 2013 7:31 am**

please provide exact logic.

Posted: **Thu Sep 19, 2013 7:32 am**

http://publibfp.boulder.ibm.com/epubs/pdf/c1938270.pdf

Refer to appendix B.

Posted: **Thu Sep 19, 2013 7:32 am**

Come on... how about you put a little effort into solving the problem first? Then show us what you've tried and what's not working and we'll help nail it down for you.

If the Field() suggestion is throwing you, you can use it to take the first field from your "@" delimited string. The rest should be very straight-forward.

DSXchange

Removing spaces and certain characters in a string

Removing spaces and certain characters in a string