SSIS Components for SAP ERP

Build 23.0.8839

TrimStrings

A boolean indicating if varchar columns should be trimmed or not.

Possible Values

TrimLeft, TrimRight, TrimAll, None

Data Type

string

Default Value

"TrimAll"

Remarks

In SAP, RFC_READ_TABLE will necessarily pad the response of varchar columns with spaces. This is due to the structure where any instance of an empty value will be represented by a space. This makes it impossible to accurately determine if leading and trailing spaces are in fact intentional or simply due to how RFC_READ_TABLE works. The most correct behavior in most cases is to simply trim the string, but this option is available in cases where there are purposeful leading or trailing spaces that should be captured.

SettingDescription
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.
NoneNot trim any spaces of the string value.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839