Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 5 Answers
- 9219 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
How to find value from a column in a dataset?
What are iconv and oconv?
What is the difference between in process and inter process?
What is meta stage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the purpose of pivot stage?
how to implement scd2 in datastage 7.5 with lookup stage
Why do we use exception activity in Datastage?
Describe the architecture of datastage?
How a routine is called in datastage job?
What is ds designer?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How can one find bugs in job sequence?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is the method of removing duplicates, without the remove duplicate stage?
