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 / srinu
using sequential file using unix command sed s/&/and/g we
will get answer
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Distinguish between informatica & datastage. Which one would you choose and why?
What are routines in datastage?
What is the flow of loading data into fact & dimensional tables?
How to reverse the string using SQL?
What is oci?
How to implement complex jobs in data stage?
Why we use surrogate key?
Explain usage analysis in datastage?
How and where you used hash file?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Is the value of staging variable stored temporarily or permanently?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is ibm datastage flow designer?
how to export or import the jobs in .ISX file
How do you generate sequence number in datastage?