Use field function in transformer stage. This function performs based on

Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result "SCH-AS" in onee column and "1010" in
another column.. Can any one tell the answer...

Question Posted / swamy

5 Answers
9283 Views
I also Faced
E-Mail Answers

Answer Posted / swamy

Use field function in transformer stage. This function
performs based on delimeter... so, you can use that field
function. like field(delimeter, occurance) - field means
(input column) delimeter ("-") occurance(2) ...

Is This Answer Correct ?

10 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many Key we can define in remove duplicate stage?

1382

What is quality stage?

987

Explain Quality stage?

1155

Where do the datastage jobs get stored?

1216

What is the project in datastage?

1114

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3124

What is difference between server jobs & parallel jobs?

1038

Demonstrate experience in maintaining quality process standards?

2549

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

What are the stages in datastage?

1083

Differentiate between datastage and informatica?

1181

AGGREGATOR default datatype

1460

Enlist various types of routines in datastage.

1255

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

what is repositery?

1843