TrimStrings Parameter (Connect-SAPERP Cmdlet)
A boolean indicating if varchar columns should be trimmed or not.
Syntax
Connect-SAPERP -TrimStrings string
Possible Values
TrimLeft, TrimRight, TrimAll, NoneData Type
cstr
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.
| Setting | Description |
| TrimLeft | Trim the leading spaces of the string value. |
| TrimRight | Trim the trailing spaces of the string value. |
| TrimAll | Trim the leading and trailing spaces of the string value. |
| None | Not trim any spaces of the string value. |