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
- 11259 Views
- I also Faced
- E-Mail Answers
Answer Posted / manish
Using Convert function we can achieve this:
Convert('&',' and ',column string)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is datastage?
How many types of stage?
What are stage variables and constants?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the project in datastage?
Define repository tables in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Differentiate between validated and Compiled in the Datastage?
What is the sortmerge collector?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Difference between in process and inter process?
What are the functionalities of link partitioner and link collector?
What is data partitioning?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to Remove Duplicate using SQL?
