Excel Add-In for SAP ERP

Build 25.0.9434

TrimStrings

Specifies which, if any, leading and trailing whitespaces are omitted from varchar columns.

Possible Values

TrimLeft, TrimRight, TrimAll, None

データ型

string

デフォルト値

"TrimAll"

解説

In SAP, the RFC_READ_TABLE function module pads Varchar columns with spaces.

Typically, trailing spaces are not deliberately added to SAP table records, so the 本製品 defaults to removing any trailing spaces in query results.

If, however, you have deliberately added trailing spaces in your SAP table records, you may use this connection property to customize (or disable) this behavior.

Value of TrimStringsDescription
TrimLeftTrim the leading spaces of the string value.
TrimRightTrim the trailing spaces of the string value.
TrimAllTrim the leading and trailing spaces of the string value.
NoneDo not trim any spaces from the string value.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434