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
- 13640 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
where is the cache (lookup, index) created and how can you see it.
what happens if the info.server doesn't find the session parameter in the parameter file?
explain the methodology of Data Warehousing?(Polaries)
Compare ETL & Manual development?
Define Dynamic push down optmization?
What is tracing level? How many types of transformations supported by sorted input?
can be used COM component in Informatica ?
Is hadoop a etl tool?
What is a mapping?
What are dimensions?
how would u estimate the size of Aggregator transform data and index cache?
What are snapshots?
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 are the concerns of OLTP and DSS systems?
What is etl process?
