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
11023 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

What is ds designer?

1041

Differentiate between data file and descriptor file?

1001

What is the process of killing a job in datastage?

969

What is a ds designer?

1032

how to delete one row in target dataset

3075

how to export or import the jobs in .ISX file

1141

how many rows sorted in sort stage by default in server jobs

3943

What is process model?

1930

How many types of views are there in a datastage director?

1245

in oracle target stage when we use load option and when we use upsert option?

2215

Explain the situation where you have applied SCD in your project?

1990

Define APT_CONFIG in Datastage?

1029

Differentiate between operational datastage (ods) and data warehouse?

1131

Where do you see different stages in the designer?

1047

project Steps,hits, Project level HArd things,Solved methods?

2072