on 2012 Jan 30 11:55 PM
During address cleansing, region names in the addresses being processed by BODS are coming in their local country language names. For example one german region name output is coming as "Nordrhein-Westfalen" instead of the English description "Nrth Rhine Westfalia".
I have set the script code to Latin and Output Country Language to English in the address cleanse transform. But still I am getting the same output.
Also I am using the German Address pack for the address cleanse transform mentioned above.
Any pointers to solve the issue mentioned above would be greatly be appreciated.
Thanks.
The LATIN script code tells the address engine to use the Latin character set used by English and the Western European languages. The OUTPUT_COUNTY_LANGUAGE option applies to the country field only. If you want to post the regions in English you can use a lookup table or search/replace table to convert.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Below is the Source data, which has complete address in one single column, however Client wants
this address column into 3 columns as Add_line1, Add_line2, Add_line3....
Would somebody please help me...on this
This Address has different formats: For example…
Nos | Source |
1 | 55444, 212th Main, ITI L/O Mallathahalli Bnaglore-42145 |
2 | 18446 B,Ranka Colony,Bilekahalli,Bannarghatta Road,Hyderabad-143121 |
3 | #301, 65th main, 125th Cross, Cross extension, Vivek Nagar,Hyderabad-874545 |
4 | Plot # 542,BHS Layout,101th A Cross,184th Main,SanthnagarBommanahalli,Bangalore-1245454 |
5 | #0542427, GF, 24540th Main,455th Cross, Sector 1, HSR Lay Out,Hyderabad-624515 |
6 | King Apartment, Sumana Nagar, Near 5454 Main Hospital, Vijay Nagar, Marol-Mahroshi Road, Andheri East, Hyderabad 400059. |
7 | Residency Jet Mumbai,Opp. Techniplex Compamy Off S.V.Road, Goregaon (W), Pune |
8 | Pop & Ben Corporate Stay,B706, 107th Floor, Joy Valencia.Near Majas Bus Depot Jogeshwari East Thane |
9 | Sao Ashok Nagar, Borla, Govandi Hyderabad 400088 |
10 | Plot No.54534/6Yet Home Colony Opp.Of Maharaja LightKarvenagar |
11 | Room No.2orgage ColonySr.No.487/8DAzadwadiKothrudHyderabad545745 |
12 |
|
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As mentioned by Paul, it has been confirmed by SAP that Region descriptions will be provided only in the local Language. I am going to use a Lookup table to convert German region names into English.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
65 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.