cancel
Showing results for 
Search instead for 
Did you mean: 

Address cleanse output to be in English instead of German.

Former Member
0 Kudos
132

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.

Accepted Solutions (1)

Accepted Solutions (1)

paul_kessler
Active Participant
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

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…

  1. 1. Few address has ‘,’ COMMA separated
  2. 2. Few with SPACE separated
  3. 3. Few with NOTHING

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

  1. Sr.No.14352/149454Building No-202Ajmera ColonyPimpriHyderabad-411018
Former Member
0 Kudos

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