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
- 16513 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
when will use SQL override in a lookup transformation?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Which transformation we use to convert 'NA' to 'Not Available'
what is pmrep command?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are dimensions?
what is the difference between cubes and package in cognos
How many types of transformations supported by sorted input?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
What is tracing level? How many types of transformations supported by sorted input?
what is the difference steps for data modeling?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how would u estimate the size of Aggregator transform data and index cache?
What is etl process?
Explain what are the various etl tools in the market?
