Hi all,
I need search for the character '-' in the last position if the last position is '-' then move it to the front of the number.
Thanks & regards
venu
how to search a string and concatenate
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 49
- Joined: Sat Mar 26, 2005 12:19 am
The substring operator will work from the 'end' of a string.
Tells it to take the first character from the end of the string. You could then compare that to "-" and if equal, swap it around to the front.
Hmm... you posted in the Server forum but marked your job type as Parallel. Are you looking for a Server or PX answer?
Code: Select all
YourField[1]
Hmm... you posted in the Server forum but marked your job type as Parallel. Are you looking for a Server or PX answer?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 49
- Joined: Sat Mar 26, 2005 12:19 am
How to swap it arount to the front
Please tell me how to swap the values in datastage.swap it around to the front.
Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 49
- Joined: Sat Mar 26, 2005 12:19 am
Parallel job
parallel Job
roy wrote:Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?
-
- Participant
- Posts: 49
- Joined: Sat Mar 26, 2005 12:19 am
Parallel job
parallel Job
roy wrote:Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?