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
- 11231 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 |
What are the different types of lookups in datastage?
Name the command line functions to import and export the DS jobs?
how can we extract data with out having any common column
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is the purpose of pivot stage and types of containers in datastage
What are the types of jobs we have in datastage?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
What is process model?
what are the different type of errors in datastage?
What is active and passive stage?
detail about sdlc
Teradata 
