Hi,
I am getting data from sequential file like below
column1
A&B
C&D
A&E
X&Y&Z
v&x
But I need the target column as like below
column1
A and B
C and D
A and E
X and Y and Z
v and x
Answer Posted / manish
Using Convert function we can achieve this:
Convert('&',' and ',column string)
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
What is staging variable?
Could anyone give brief explanation bout datastage admin
What are the main differences you have observed between 7.x and 8.x version of datastage?
Differentiate between Join, Merge and Lookup stage?
What is the difference between account and directory options ?
How to reverse the string using unix?
I have a few records just I want to store data in to targets cycling way how?
What is the use of datastage director?
What is the purpose of pivot stage?
What is a merge in datastage?
What is size of a transaction and an array means in a datastage?
How can one find bugs in job sequence?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Is possible to create skid in dim,fact tables?