LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mmarinelli

I have a data file which is delimited by the special character "��" [chr(199)], which I want to load using the Delimited File node. How can I do this? I've tried using \\x00C7,\\0xC7,\\u00C7 and several other values in the Field Delimiter parameter, but none of them produce the desired output. When I use "��" (with quotes), the node seems to enter an infinite loop. When I use �� (no quotes), the value is lost as soon as the node editor is closed.

How do I use such characters as delimiters?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

This is a bug, PR1356, which will probably be fixed in the next release of BRAIN (4.1.2). The Delimited Node doesn't allow a specification of a delimiter that is higher then 127 (\\x7F).

$Rich<br><br>Post edited by: rboccuzzi, at: 2008/06/07 23:59

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: kai

Hi guys,
I am using BRE 4.1.3., and I do not find the option to specify a column delimiter. I do see in the documentation that there should be a field "FieldDelimiter" and "RecordDelimiter", but it is not there... and when I open the help, it says it is out of date.
How can I specify e.g. a TAB instead of a comma as columns now are NOT recognized.
Thanks,
Kai

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mmarinelli

Which node are you using? If you are using the "CSV File" node, you will not see the delimiter fields exposed because they are set by default to comma and new line; this node will only accept CSV files. If you are using the "Delimited File" node, you can set the FieldDelimiter to &amp;bsol;t and the RecordDelimiter to &amp;bsol;n in order to do what you describe.

Post edited by: mmarinelli, at: 2009/06/02 18:46

EDIT: evidently this forum software cannot recognize certain characters when it renders the pages. The &amp;bsol; above should be replaced with the BACKSLASH character in your nodes.<br><br>Post edited by: mmarinelli, at: 2009/06/02 18:47

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: kai

Hi Mark,
thanks for that. Of course, I used the wrong node type when experimenting.
Backslahes, however, cannot be typed directly into the "Delimited File" nodes text field, they just do not appear. Therefore, one has to copy and paste the "backslash-t" from e.g. notepad into this field.
Talk to you tomorrow,
cheers,
Kai