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
Removing spaces and certain characters in a string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers