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
- 9173 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 mapping lookup
How do you design PX Routines ?
How To find the location of APT_confid file
how to define satge variables in transformer stage
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
How can you join flat file, oracle as a sources?
Explain usage analysis in datastage?
What is the difference between orabulk and bcp stages?
Is there any possibility to generate alphanumeric surrogate key?
Describe the architecture of datastage?
ename like ibm,tcs,hcl need display those records only how?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
Teradata 
