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

How etl testing is different from database testing?

0 Answers  

Explain about round-robi?

0 Answers  

Eliminating of duplicate records without using dynamic lookups

1 Answers  

what are variable ports and list two situations when they can be used?

4 Answers   Satyam,

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,




Explain about power designer data modeling software?

0 Answers  

what are the production issues in datastage?

0 Answers  

explain the methodology of Data Warehousing?(Polaries)

0 Answers  

What is a staging area? What is the purpose of a staging area?

0 Answers  

What is data cleaning?

0 Answers  

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

0 Answers  

what is the advantage of persistent cache? when it should be used?

2 Answers  

For more ETL Interview Questions Click Here
Categories