Dear Srinu, I am accepting your answer , but I need it b

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

Question Posted / blueboys

7 Answers
11461 Views
I also Faced
E-Mail Answers

Answer Posted / blueboys

Dear Srinu,

I am accepting your answer , but I need it by
using data stage functions

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to write server Routine coding?

2179

What is the flow of loading data into fact & dimensional tables?

1110

What is the difference between the local container and shared container?

1142

What is ibm datastage?

1022

How do you import and export the datastage jobs?

1209

What is the method of removing duplicates, without the remove duplicate stage?

1078

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?

2281

What is "fatal error/rdbms code 3996" error?

1342

How and where you used hash file?

1222

which r the connectors used in san?

2227

What are the different common services in datastage?

1337

What is the sortmerge collector?

1174

How to RD using transformer?

1472

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3810

Can you explain engine tier in information server?

1182