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
- 17262 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar
Use trim(columnname,'_','a') to remove the '-' values from
the columns
2) use field function: field(columnname,'@'2) to get the
company.com
Thanks
Kumar
| Is This Answer Correct ? | 2 Yes | 7 No |
what are Lookup caches options? Including persistent caches.
What is virtual Data Warehousing?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is a mapping, session, worklet, workflow, mapplet?
Compare etl & elt?
how do u extract data from different data sources explain with an example?
what is the difference between cubes and package in cognos
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the facilities provided by data warehouse to analytical users?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what make u disappointmnets in u r career
What is a lookup table in etl?
Teradata 
