Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / srinu

using sequential file using unix command sed s/&/and/g we
will get answer

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Distinguish between informatica & datastage. Which one would you choose and why?

1043


What are routines in datastage?

1379


What is the flow of loading data into fact & dimensional tables?

1110


How to reverse the string using SQL?

1592


What is oci?

1352


How to implement complex jobs in data stage?

1157


Why we use surrogate key?

1304


Explain usage analysis in datastage?

1223


How and where you used hash file?

1222


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1457


Is the value of staging variable stored temporarily or permanently?

1052


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2284


What is ibm datastage flow designer?

1203


how to export or import the jobs in .ISX file

1250


How do you generate sequence number in datastage?

1139