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

Explain the difference between etl tool and olap tools?

0 Answers  

What is data modeling and data mining?

0 Answers  

what are Lookup caches options? Including persistent caches.

1 Answers  

What are the different etl testing categories as per their function?

0 Answers  

list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  




HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

0 Answers  

Explain etl mapping sheets?

0 Answers  

What is virtual Data Warehousing?

0 Answers  

what is a worklet?

0 Answers  

dimension object created in oracle can be imported in designer?how?

0 Answers  

hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,

what are the production issues in datastage?

0 Answers  

For more ETL Interview Questions Click Here
Categories