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
- 9306 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madan
use substr in transformer and divide it in to 2 fields as
required
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ashutosh g
use Row splitter as tranform stage and specified the column
name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / balu
We are using LEFT and RIGHT TRIM function in transform stage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / palgun
Simple.....use da delimiter as --
SCH-AS--1010
Does dat solve ur prob??
| Is This Answer Correct ? | 0 Yes | 4 No |
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
Difference between JOIN,LOOKUP,MERGE?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
Terminate Activity
Differentiate between validated and Compiled in the Datastage?
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
How can we run same job in 1 day 2 times
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How to clean the datastage repository?
what is the difference between datasatge and datastage TX?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
what is the unix script to run the job? Please mention commands which we use often?
Teradata 
