Simple.....use da delimiter as -- SCH-AS--1010 Does dat solve ur prob

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

5 Answers
9462 Views
I also Faced
E-Mail Answers

Answer Posted / palgun

Simple.....use da delimiter as --

SCH-AS--1010

Does dat solve ur prob??

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the devoleper roles in real time? plz tell i am new to datastage....

2212

What is apt_config in datastage?

1194

What are system variables and sequencers in datastage

1182

What is the use of datastage designer?

1218

What is the difference between operational data stage (ods) and data warehouse?

1294

What is the difference between an operational datastage and a data warehouse?

1210

Define oconv () and iconv () functions in datastage?

1468

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2928

What are routines in datastage? Enlist various types of routines.

1154

Can you explain link buffering?

1222

describe the Steps to confiure a Qlogic switch

2438

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

2323

What are stage variables?

1254

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3403

To see hidden files in LINIX?

1589