Using Convert function we can achieve this: Convert('&',&#

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

7 Answers
11459 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

Please Help Members By Posting Answers For Below Questions

EXPLAIN SCD

1448

Difference between sequential file and data set?

1260

What is the difference between validated and compiled in the datastage?

1369

What is oci?

1352

Where do you see different stages in the designer?

1141

What are the steps needed to create a simple basic datastage job?

1303

Describe the main features of datastage?

1123

What is the difference between datastage and datastage tx?

1114

How many types of sorting methods are available in datastage?

1114

Explain usage analysis in datastage?

1223

What are the functionalities of link partitioner?

1065

What are the important features of datastage?

1197

Explain ibm infosphere information server and highlight its main features?

1137

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

1110

What is a quality stage in datastage tool?

1127