Skip to main content
  • EN

Hi,

 

I am working on two excel-files that I wanted to merge with address.

 

Unfortunately I am struggling to merge with the address since they are formatted differently for each excel file.

 

For example: Alex Olssons Road 50 - Alex Olssons road 50

 

There are more strange cases where there are lower and upper case letters between each spaces. I wanted change the attribute for addresses in both files so that all the letters are in uppercase and all spaces are removed to make it easier to merge.

 

For example: ALEXOLSSONSROAD50

 

Any ideas what transformer I should use?

 

 

 

 

 

You can use the StringReplacer. Just type a space in the Text to Replace parameter. Another method if you prefer: I'm assuming you are using the FeatureMerger? If so, you can use this expression in the Requestor and Supplier parameters to assume everything is uppercase and also remove spaces before the comparison (att being your attribute). That way you don't actually have to modify the value. 

@ReplaceString(@UpperCase(@Value(att))," ","")

 

Reply


Community Stats

30,163
Posts
114,500
Replies
37,814
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.