TrimStrings Parameter (Connect-SAPERP Cmdlet)
Specifies which, if any, leading and trailing whitespaces are omitted from varchar columns.
Syntax
Connect-SAPERP -TrimStrings string
Possible Values
TrimLeft, TrimRight, TrimAll, NoneData Type
cstr
Default Value
"TrimAll"
Remarks
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 TrimStrings | 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 | Do not trim any spaces from the string value. |