use substr in transformer and divide it in to 2 fields as required

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

5 Answers
9477 Views
I also Faced
E-Mail Answers

Answer Posted / madan

use substr in transformer and divide it in to 2 fields as
required

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the differences between datastage and informatica?

1229

What is the project in datastage?

1171

How many types of sorting methods are available in datastage?

1116

Where the datastage stored his repository?

1142

What are the primary usages of datastage tool?

1134

Can you explain kafka connector?

1380

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2329

How do you register plug-ins?

1004

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2330

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2444

How to implement complex jobs in data stage?

1163

Explain connectivity between datastage with datasources?

1043

Where do you see different stages in the designer?

1147

What is the difference between datastage and datastage tx?

1119

How can one find bugs in job sequence?

1497