using expersion u can create o/p in that write replacestr(1,columnname,&#

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 / sree

7 Answers
11185 Views
I also Faced
E-Mail Answers

Answer Posted / sree

using expersion
u can create o/p in that write
replacestr(1,columnname,'&','and')

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many areas for files does datastage have?

1141

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1373

Explain datastage architecture?

1384

What is the difference between server job and parallel jobs?

1134

Define APT_CONFIG in Datastage?

1061

What are the difference types of stages?

1187

which r the connectors used in san?

2175

What are the job parameters?

1208

Explain connectivity between datastage with datasources?

966

What is the purpose of pivot stage and types of containers in datastage

1028

What are routines in datastage?

1314

What are data elements?

1157

How will you move hashed file from one location to another location?

2142

Nls stands for what in datastage?

1182

How do you register plug-ins?

955