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...

I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?

Answer Posted / bob

Repacechr(1,""TCS"MUMBAI",'"',null)

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain your project of banking domian.

1624


can anyone explain me about retail domain project in informatica?

7911


How to configure mapping in informatica?

1143


What is a filter transformation?

1007


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1040


Explain the different lookup methods used in informatica?

1000


Can we create a Integration service without a Repository service and vice versa?

1191


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2006


What are the different components of powercenter?

1013


What is update strategy transform?

1061


What are mapplets?

1231


Differentiate between Load Manager and DTM?

2119


What is a standalone command task?

1166


What is the surrogate key?

1191


What is expression transformation?

1061