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

Enlist some properties of sessions.

1062


What is a joiner transformation?

981


differences between service based and product based?

2001


What is status code in informatica?

1007


How to load data in informatica ?

996


what is index?how it can work in informatica

2033


What do you mean by blocking transformation?

1028


What is a connected transformation?

1110


What is substr in informatica?

1192


Can we change Dynamic to Static or Persistent cache? If so what happens?

2199


During the running session, output files are created by informatica server. Enlist few of them.

974


What are pre and post-session shell commands?

1297


What is the benefit of session partitioning?

1109


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1572


Differences between connected and unconnected lookup?

1208