Removing blank spaces

An attributetrimmer should work here.

If you wanted to use an string searcher with a regular expression \\s should work

It might be that your fields actually contain non-printing characters rather than spaces, in which case it might be easier to pick out the digits with a string searcher using regex such as [0-9\\.]*

Hi @tobiasp Just an idea, replace missing, empty and null with -9999 (NullAttributeMapper) and replace -9999 with nothing (StringReplacer)

You can actually do all this and what @egomm suggests about regular expressions in the NullAttributeMapper, the only down side is that you cannot map it to nothing

Hi @tobiasp, sounds strange. The AttributeTrimmer should work to trim both leading and trailing whitespaces.

Could you please post an Excel file containing some rows that reproduces the same situation?

Hey!

Thanks for your efforts!

Here is the excel-file I am trying to clean from whitespaces.

example.xlsx

//Tobias

Hey!

Thanks for your efforts!

Here is the excel-file I am trying to clean from whitespaces.

example.xlsx

//Tobias

This might be stupid question. But here it goes. Is it possible that it's not actual space sign but some other unicode whitespace character?

Replace everything that's not a number or a comma with nothing, e.g.

Beautiful!

There are apparently several kinds of blank spaces... :)

//Tobias

@zzupljanin is right. The invisible character was the "non-breaking space". The AttributeTrimer also works if you copy and paste the character into the "Trim Characters" parameter.

I think that copy and paste is the quickest way, but found other interesting ways. For what it's worth...

1.
The character code in hexadecimal of non-breaking space is C2A0 in the UTF-8 encoding. This workflow trims both leading and trailing non-breaking spaces.

def trimSpaces(feature):
    x = feature.getAttribute('x')
    y = feature.getAttribute('y')
    feature.setAttribute('x', x.strip())
    feature.setAttribute('y', y.strip())

I've just finally resolved a similar problem. In my case I was trying to figure out why the concatenation of two attributes and adding some text wasn't working (@Value(REF) @Value(COMMENTS).jpg).

Figuring it out was made harder by the fact that when I added an Inspector, this showed the result I was expecting, but what was written to the FGDB layer was missing the .jpg bit at the end of the value. No warnings or errors were recorded in the Translation Log.

It turned out that there is a null character (Char 0 - you learn something new every day!) at the end of the value in one of the attributes in the source CSV file. This doesn't show up in Excel and in TextPad appears as a space. I only started to figure it out when I tried to copy a row from the CSV to make a test file and TextPad said "Cannot cut, copy, or drag and drop text containing null (code = 0) characters"

This topic was useful because it put me on the track of looking for funny character, and using StringReplacer and Regular Expressions to fix it. A quick Google gave me the Regular Expression (\\0 see https://stackoverflow.com/questions/7578632/what-is-the-difference-between-char0-and-0-in-c) which I replace with nothing. I'm still struggling with the metaphysical aspect of replacing null with nothing but my translation now works! :-)

AttributeTrimmer doesn't seem to accept Regular Expressions. Is there another transformer that will do this? If not I'll submit an idea for AttributeTrimmer to allow Regular Expressions.