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 ‘|’ .
- 5 Answers
- 9727 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shaik
write dql command replace to remove the | and save the result in variable port.find the length of that port by using lenth().....
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / abhinav prakash
Replacechr(1,Column_name,'|',NULL)..write the query in
expression and pass it to Output.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / abhinaw prakash
We can find the position of the "|" using INSTR function and
then we can use the SUBSTR function to extract the strings.
We can use Normalizer t/r to put the strings in one column
and then use LENGTH function to find the length of the string.
| Is This Answer Correct ? | 2 Yes | 3 No |
What is a passive transformation?
Where do you create/define mapping parameter and mapping variable?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
what is the difference between Informatica 7.1 and Abinitio?
where to store informatica rejected data?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What is aggregate cache in aggregator transforamtion?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
What are the types of schemas we have in data warehouse.
How to load the data from people soft hrm to people soft erm using informatica?
Teradata 
