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

Find a way to implement the following logic :
You have column like :
Column 1

AA|BB|CC
DD|EE|FF
WW|AA
I need to get the length of the column without the ‘|’ .

Answer Posted / hariprasad_pulluru

Hi,

You can also parse the string using replace chr to
elminate '|' and find the length of the column

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you join a node to the already existing domain?

1127


What is the status code in stored procedure transformation?

1182


What is meant by lookup transformation?

1101


How can we improve session performance in aggregator transformation?

1115


Please let me know how to make encryption and decryption with example?

1900


what is unit testing?tell me proceedure

2219


How to elaborate tracing level?

1172


What is a joiner transformation and why it is an active one?

1076


can u any challenge your project?

2031


What is workflow? What are the components of workflow manager?

1173


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1763


How to do unit testing in informatica?

1169


Different sorts of metadata that stores in the storage facility?

1010


What are the different clients of powercenter?

1059


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1261