how to search a string and concatenate

[venugopal81]

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

[chulett]

The substring operator will work from the 'end' of a string.

Code: Select all

YourField[1]

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?

[venugopal81]

swap it around to the front.

Please tell me how to swap the values in datastage.

[roy]

Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?

[venugopal81]

parallel Job

Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?

[venugopal81]

parallel Job

Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?