1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"

Question Posted / sreedhar

Answers were Sorted based on User's Feedback



CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / kumaravelu

replace ('323-237-2323','-', '')

Is This Answer Correct ?    14 Yes 0 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / kumaravelu

substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)

Is This Answer Correct ?    6 Yes 0 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / again kuttu!!

select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual

Is This Answer Correct ?    4 Yes 0 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / kuttu

select trim(replace('2-3-4','-',NULL)) from dual

Is This Answer Correct ?    2 Yes 0 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / arun a

REPLACECHR( CaseFlag, InputString, OldCharSet, NewChar )

EXAMPLE:

TO_CHAR(REPLACECHR(1,'323-237-2323','-',''))

When CaseFlag is a number other than 0,
the function is case sensitive

Is This Answer Correct ?    3 Yes 1 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / satish

select replace ('323-237-2323','-') from dual

select substr('test@company.com',6,11) from dual

Is This Answer Correct ?    3 Yes 1 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / kkr

select replace ('323-237-2323','-') from dual

select substr('abc@co.com',-7) from dual

Is This Answer Correct ?    3 Yes 2 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / venkateswara rao

--Written in sqlserver
declare @num varchar(100) ='323-237-2323'
, @str varchar(100) ='TEST@COMPANY.COM'
, @ind int

set @ind= CHARINDEX('@',@str)
select SUBSTRING(@str,@ind+1,LEN(@str))
print @ind
select REPLACE(@num,'-','')

Is This Answer Correct ?    0 Yes 0 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / bilas

use TRANSLATE function

select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;

Is This Answer Correct ?    2 Yes 3 No

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-23..

Answer / erqf

2)if findc(emailid,'@','company.com')=0 then
emailid=emailid;

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More ETL Interview Questions

what is the difference steps for data modeling?

0 Answers  

what is Forward,Reverse and Re_engineering?

0 Answers  

how to connect to a flatfile through ftp in informatica

1 Answers   TCS,

Can there be sub steps of etl steps?

0 Answers  

Explain the use lookup tables and Aggregate tables?

0 Answers  




What is the difference between Data Warehousing and Data Mining?

0 Answers  

Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers  

Explain and compare etl & manual development?

0 Answers  

what is meant by drill through?(Mascot)

1 Answers  

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

what are the different Reporting and ETL tools available in the market?

3 Answers  

What are dimensions?

0 Answers  

For more ETL Interview Questions Click Here
Categories