AttributeTrimmer

Removes specified leading and trailing characters from selected attributes.

Jump to Configuration

Typical Uses

  • Cleaning attribute data
  • Removing white space (non-printing characters) from attribute values

How does it work?

The AttributeTrimmer removes specific characters from the beginning and/or end of chosen attribute values.

It does not match specific character patterns, rather, as long as the next character is included in the list of Trim Characters, it will continue to remove them until it encounters a character that is not in the list.

For example, suppose the attribute to trim had the value "This is a test" and Trim Type was set to Both (trimming from both the beginning and end of the value).

  • If Trim Characters had the value "hit", the result would be "This is a tes".
  • If Trim Characters had the value "HhIiTt", the result would be "s is a tes".

Trim Characters may be alphanumeric, and can include control characters. If Trim Characters is left blank (unspecified), “white space” will be removed - non-printing characters such as spaces, tabs, newlines, and carriage returns.

The attributes are output with any matching characters trimmed. Attributes that do not have matching Trim Characters are output untouched.

Examples

Usage Notes

  • To trim a specific prefix or suffix, or match any consistent string pattern, consider using the StringReplacer.

Configuration

Input Ports

Output Ports

Parameters

Editing Transformer Parameters

Using a set of menu options, transformer parameters can be assigned by referencing other elements in the workspace. More advanced functions, such as an advanced editor and an arithmetic editor, are also available in some transformers. To access a menu of these options, click beside the applicable parameter. For more information, see Transformer Parameter Menu Options.

Defining Values

There are several ways to define a value for use in a Transformer. The simplest is to simply type in a value or string, which can include functions of various types such as attribute references, math and string functions, and workspace parameters. There are a number of tools and shortcuts that can assist in constructing values, generally available from the drop-down context menu adjacent to the value field.

Dialog Options - Tables

Transformers with table-style parameters have additional tools for populating and manipulating values.

Reference

Processing Behavior

Feature-Based

Feature Holding

No

Dependencies  
FME Licensing Level FME Base Edition and above
Aliases StringTrimmer
History  

FME Community

The FME Community is the place for demos, how-tos, articles, FAQs, and more. Get answers to your questions, learn from other users, and suggest, vote, and comment on new features.

Search for all results about the AttributeTrimmer on the FME Community.

 

Examples may contain information licensed under the Open Government Licence – Vancouver and/or the Open Government Licence – Canada.