2.5. Defining Configurations
- To define fields in XML configurations you must use a comma-separated list of names in the fields attribute.
- Make sure the field names follow the same naming rules as XML element names:
- they can contain letters, numbers, and other characters
- they cannot start with a number or punctuation character
- they cannot start with the letters xml (or XML or Xml, etc)
- they cannot contain spaces
- Set the rootElementName and recordElementName attributes so you can modify the csv-set and csv-record element names. The same rules apply for these names.
- You can define string manipulation functions on a per-field basis. These functions are executed before the data is converted into SAX events. Define them after the field name, separating the two with a question mark:
<?xml version="1.0"?> <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd" xmlns:csv="http://www.milyn.org/xsd/smooks/csv-1.2.xsd"> <csv:reader fields="lastname?trim.capitalize,country?upper_case" /> </smooks-resource-list> - To get Smooks to ignore fields in a CSV record, you must specify the $ignore$ token as the field's configuration value. Specify the number of fields to be ignored simply by following the $ignore$ token with a number (so use
$ignore$3to ignore the next three fields.) Use$ignore$+to ignore all of the fields to the end of the CSV record.<?xml version="1.0"?> <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd" xmlns:csv="http://www.milyn.org/xsd/smooks/csv-1.2.xsd"> <csv:reader fields="firstname,$ignore$2,age,$ignore$+" /> </smooks-resource-list>
