A CSV file can contain multiple data records, with each record spanning multiple columns. Each column value for a record is also known as a token.
The CSV file must include delimiter characters to separate tokens within each record and to separate records. The CSV data reader uses these delimiter characters to identify each record and token.
- Tokens are separated by a tokenDelimiter character. By default, the tokenDelimiter character is a comma ( , ).
- Token values are separated by a tokenValueDelimiter character. By default, the tokenValueDelimiter character is a comma ( “” ). For Example-
"Men's fashions for business, casual, and formal occasions" - Records are separated by a lineDelimiter character, which can also be called a record delimiter. By default, the lineDelimiter character is the new line character.
The following code snippet demonstrates how to use the parameters. This code snippet uses all default values:
<_config:DataReader lineDelimiter="\n" tokenDelimiter="," tokenValueDelimiter='"'
charset="UTF-8" firstLineIsHeader="false" useHeaderAsColumnName="false" />For just reference you can use following IBM knowledge center URL
https://www.ibm.com/support/knowledgecenter/en/SSZLC2_8.0.0/com.ibm.commerce.data.doc/tasks/tmlcsvdataload.htm
Note:- We can change the delimiter character as per our requirement in the mediator files.
I am extremely impressed with your writing talents as well as
with the format in your blog. Is that this a paid topic
or did you customize it yourself? Either way stay up the excellent
quality writing, it’s rare to see a great
weblog like this one these days..
Thanks Socopa.
I loved your blog article.Really thank you! Cool.
Hmm is anyone else having problems with the images on this blog loading?
I’m trying to find out if its a problem on my end or if it’s the blog.
Any responses would be greatly appreciated.