Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I am getting data from sequential file like below
column1
A&B
C&D
A&E
X&Y&Z
v&x
But I need the target column as like below
column1
A and B
C and D
A and E
X and Y and Z
v and x
- 7 Answers
- 11014 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmi srinivas
By using convert function in transformer,we can implement
that....
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / manish
Using Convert function we can achieve this:
Convert('&',' and ',column string)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srinu
using sequential file using unix command sed s/&/and/g we
will get answer
| Is This Answer Correct ? | 2 Yes | 1 No |
hi,
please take a look on below,
seq_src------->ext_flter----->seq_tgt
in external filter give the
filter command = sed s/"&"/" And "/g command.
**Note: on ampersand (&) symbol you must give the double
quotes (""). With out this it doesn't populate.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sree
using expersion
u can create o/p in that write
replacestr(1,columnname,'&','and')
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / srinu
hi blueboys
only that answer is proper answer.....interview expected
that answer only.........datastage it is not possible........
| Is This Answer Correct ? | 1 Yes | 1 No |
Highlight the main features of datastage?
what is the use of materialized view?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
What is the difference between odbc and drs stage?
what is the best stage in datastage parller jobs to use full out join and why
why dataset ?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
How to transfer file from one system to another system in UNIX?which command to be use?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
What are the different common services in datastage?
I have 100 records how can I load at a time from the single time
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
Teradata 
