An Easy Way Of Achieving The Output Will Be :- select length(column

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

Question Posted / ankit kansal

5 Answers
9542 Views
I also Faced
E-Mail Answers

Answer Posted / ankit kansal

An Easy Way Of Achieving The Output Will Be :-

select length(column_name)-(length(cloumn_name)-length(replace(column_name,'|',''))) from table_name;

http://deepinopensource.blogspot.in/

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2000

What is a repository manager?

1093

COM components can be used in Informatica

2390

What is workflow manager?

1047

Explain lookup transformation source types in informatica

1097

What is informatica etl tool?

999

In warehouses how many schemas are there?

1073

What are active transformations.

1654

Can you use flat files in Mapplets.

2648

generate date / time dimension in informatica

1125

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012

What is the command used to run a batch?

1062

What are the new features of Power Center 5.0?

1777

What is informatica metadata and where is it stored?

991

Under which circumstances, informatica server creates reject files?

1093