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 / chow

we can do using ltrim and rtrim and concat two words

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the features of complex mapping?

1209


What are the differences between oltp and olap?

1018


tell me 5 session failure in real time how can you solve that in your project?

2392


Different circumstance which drives informatica server to expel records?

1043


what are the Methods For Creating Reusable Transformations?

1257


What is the Process to creating lookup transformation in informatica

1091


Could you explain what is enterprise data warehouse?

1226


What are the uses of etl tools?

1175


What is the use of code page?

1176


What will be the approach?

1039


What are the performance considerations when working with aggregator transformation?

1209


lookup transformation with screenshots

4050


How can one identify whether mapping is correct or not without connecting session?

1498


Describe expression transformation?

1170


How can repository reports be accessed without sql or other transformations?

1268