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
- 11046 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
Define Merge?
Difference between sequential file and data set?
What is job control?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Define APT_CONFIG in Datastage?
Differentiate between data file and descriptor file?
What are the partitioning techniques available in link partitioner?
Terminate Activity
EXPLAIN SCD
How do you remove duplicate values in datastage?
What are the types of hashed files in data stage
What are the types of containers?
What are the different layers in the information server architecture?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the enhancements made in datastage 7.5 compare with 7.0?
