LAE

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

Originally posted by: RogierW

Hi,

I have a file whereby the first line is empty. If I try to use the "delimietd file" node, I get the error message "Field 1 on output has a zero-length or all whitespace name."
If I use the directory list, followed by "Multiple BRD files" I can read all lines, but the field name is empty. Also, the preview results in errors:

Traceback (most recent call last):
File "wx\_core.pyc", line 14640, in <lambda>
File "brdViewer.py", line 1152, in open
File "brdViewer.py", line 483, in __init__
File "brdViewer.py", line 483, in <lambda>
File "brdViewer.py", line 1234, in addColumn
File "wx\_core.pyc", line 11049, in Append
wx._core.PyAssertionError: C++ assertion "wxAssertFailure" failed at ..\..\src\common\stockitem.cpp(166) in wxGetStockLabel(): invalid stock item ID

How can I read this file without manual adjustments in the file?

Thanks,
Rogier

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

Originally posted by: rboccuzzi

Unfortunately, there is no easy way to read the data cleanly using just the LAE. There is an enhancement request (PR3881) to skip rows for the delimited file node, but that won't help you right now. The best way to solve this now is either to 1) write a Python or Java node to remove the first line and re-write the file, then use the standard input node or 2) use a delimited node and provide a delimiter that is not in the data, and provide a fieldname, such as "data", and then parse the data inside the LAE. Note, you could solve this using our Lavastorm Data Reader, which is available for an extra cost to Lavastorm Enterprise Server customers, but that is probably over-kill for this problem.

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

Originally posted by: Murali

Has this enhancement request (PR3881) been implemented? If so, in what version?
Thanks.

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

Originally posted by: ltolleson

I checked and this feature has not been added to the delimited file input node.

In the interim you can use the nodes from the attached graph to do the same thing.

Note: You will need to change the file path in the delimited file nodes to point to your directory structure.

Thanks,
Larry
Attachments:
InputSkipLines.zip