Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Up to 100,000 records can be processed with the freeware version!
Flowheater Chart

String Trim Heater, remove characters at the beginning/end

Trim Heater, Removing white space characters

The String Trim Heater can be used to remove any specified or whitespace characters from the beginning and/or end of a string. Depending on the option selected, the characters are removed at the beginning, at the end or both.

 

String Trim Heater - ConfigurationString Trim Heater - Configuration

Settings

Trim type: The options available are “All”, “Beginning” and “End”

All) removes all occurrences of the characters specified from both the beginning and the end of the string
Beginning) removes all occurrences of the characters specified from just the beginning of the string
End) removes all occurrences of the characters specified from just the end of the string

Trim specific characters: If you enter one or more characters here, only these characters are trimmed. Any characters entered are considered a list of characters, each of which are trimmed individually, it is not a string to match. If no characters are entered here, the String Trim Heater removes white space characters at the beginning and/or end of the string. White space characters include spaces as well as other non-printable characters such as tabs and line breaks from the string.

Note

Only characters at the beginning and/or end of the string are truncated until the first occurrence of a character that is not specified. The characters or spaces that do not occur beyond this point in the text will remain. If instead you wish to replace characters along the length of a string, a better tool is the String Replace Heater.

 

Please also refer to the general information on the use of Heaters (functions)

 

FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.