Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to get rid of non ascii characters in a string?
Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件

to

United States Microsoft Visual Studio Tools for Applications 2012 x86.

Answer Posted / aa

Use reg_replace

reference
https://etltechsolutions.wordpress.com/

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

996


What is dimensional table? Explain the different dimensions.

1108


How you can differentiate between connected lookup and unconnected lookup?

1003


have u done any performance tuning? how u ll do?

2248


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1994


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2206


What is olap (on-line analytical processing?

1005


Performance tuning( what you did in performance tuning)

1907


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1929


Explain in detail scd type 2 through mapping.

985


How union transformation is used?

952


How do you remove duplicate records in informatica? And how many ways are there to do it?

1106


What are mapplets? How is it different from a Reusable Transformation?

1028


What is rank transform?

940


Explain the difference between a data warehouse and a data mart?

999