Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 10967 Views
- I also Faced
- E-Mail Answers
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
Define project in datastage?
What is the project in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How complex jobs are implemented in datstage to improve performance?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is staging variable?
What are the different type of jobs in datastage?
what is the use of skid in reporting?
Define orabulk and bcp stages?
What are the enhancements made in datastage 7.5 compare with 7.0?
Define Merge?
What is the purpose of pivot stage?
What is the process of killing a job in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Why do we use exception activity in Datastage?
