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
- 11253 Views
- I also Faced
- E-Mail Answers
Answer Posted / bharath
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 |
Post New Answer View All Answers
Can you explain link buffering?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Is it possible to query a hash file?
What a datastage macro?
What is active and passive stage?
In Datastage, how you can fix the truncated data error?
What are the areas of application?
What is the purpose of interprocessor stage in server jobs?
Lookup constraints
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is size of a transaction and an array means in a datastage?
how to sort two columns in single job in datastage.
What is quality stage?
What is difference between join, merge and lookup stage?
What are orabulk and bcp stages?
