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 / aa
Use reg_replace
reference
https://etltechsolutions.wordpress.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the benefit of partitioning a session?
Why we use lookup transformations?
How to create Target definition for flat files?
my source is junk data how will u remove that junk data by using unix please any one replay me
In joiner, how to load Master table in Target?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
what is confirmed dimension?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
Explain scd type 3 through mapping.
what is difference between dimention table and fact table?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?