Use Case Accelerators > How to Remove White Space from Fields

How to Remove White Space from Fields

Article #: Product: Version:

Summary

Frequently, data contains leading and/or trailing white-space characters, such as spaces and tabs, which may need to be removed prior to further processing. In DMExpress, such white space can be removed from data in the following ways:

While the Trim function provides more flexibility, the Compress all fields option may perform better if many fields require white space removal.

Resolution

Additional Information

For more information on the Trim function, see Trim function in the DMExpress Help.

For more information on expressions, see Expressions in the DMExpress Help and Named vs. Inline Expressions.

For more information on the effect of Compress all fields for different data types, see Reformat Target Layout dialog in the DMExpress Help.

Last updated: