Element Details: Trim+String
 Back


Available in: Logi Info Source code name: TrimString

Removes all occurrences of a specified character from the beginning and/or end of a value. The default character removed is a space.

The returned string can update the original column, or be stored in a new column. To save the updated strings in a new column use the NewColumnNames attribute.

Element Group:String Elements



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
Change
Right
Left
All
The type of transformation to apply to the column value.
ColumnNames
UserDefined
(Required) A list of column names, separated by commas. For example: OrderID, CustomerID, EmployeeID, OrderDate
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
NewColumnNames
UserDefined
A list of column names, separated by commas. The number of items in this list must match the number in the ColumnNames attribute. For example: OrderID, CustomerID, EmployeeID, OrderDate
TrimCharacter
UserDefined
The character or string to remove. Defaults to space.



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.Cached
DataLayer.CSV
DataLayer.Definition List
DataLayer.Directory
DataLayer.ETL
DataLayer.Excel
DataLayer.Fixed Format File
DataLayer.Google App
DataLayer.Google Spreadsheet
DataLayer.JSON
DataLayer.LDAP
DataLayer.Linked
DataLayer.Plugin
DataLayer.REST
DataLayer.SimpleDB
DataLayer.SP
DataLayer.SQL
DataLayer.Static
DataLayer.Twitter
DataLayer.Web Feed
DataLayer.Web Scraper
DataLayer.Web Service
DataLayer.XML


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


 Chart Debug