Removing spaces and certain characters in a string

skp · Post by **skp** » 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

RPhani · Post by **RPhani** » Thu Sep 19, 2013 7:27 am

Hi,

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

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

skp · Post by **skp** » Thu Sep 19, 2013 7:31 am

please provide exact logic.

stuartjvnorton · Post by **stuartjvnorton** » Thu Sep 19, 2013 7:32 am

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

Refer to appendix B.

chulett · Post by **chulett** » 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.