Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 11 Answers
- 17019 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumaravelu
substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)
| Is This Answer Correct ? | 6 Yes | 0 No |
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 |
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 |
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 |
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 |
Answer / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / erqf
2)if findc(emailid,'@','company.com')=0 then
emailid=emailid;
| Is This Answer Correct ? | 0 Yes | 3 No |
What is grain of fact?
what is the main role of FI on business
what is dynamic insert?
how would u estimate the size of Lookup transform data and index cache?
what is the use of server manager?
what are the different forms of normalization?
What is cube grouping?
What is initial load and what is full load?
Need Informatica Power Center 9.1 free download(for all windows version)
When do we analyze the tables? How do we do it?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
how do u set partition points in the mapping?
Teradata 
