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 can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  

Explain about enterprise scalability and roi of data integration suite?

0 Answers  

What is tracing level? How many types of transformations supported by sorted input?

0 Answers  

what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  

how would u estimate the size of Lookup transform data and index cache?

1 Answers  




Explain the difference between etl tool and olap tools?

0 Answers  

What is lookup table in etl testing?

0 Answers  

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

what is pmrep command?

0 Answers  

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

What are the key benefits of ETL Testing?

0 Answers  

What is data modeling and data mining?

0 Answers  

For more ETL Interview Questions Click Here
Categories