LAE

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

Originally posted by: joanaramada

Hi,

I'm trying to import a .txt file that has some blank fields but I'm not abble to. This is the error that appears "Field 39 on output has a zero-lenght or all whitespace name".

I'm using the node "Delimited File".

Is there anything that I should put on the parameters so that it can import the blank values anyway?

Thanks,
Joana

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

Originally posted by: rboccuzzi

It looks like you have data with empty field names, which is not allowed inside our software. There are a couple of ways you could solve this. One is to edit the .txt file and make sure each field has a valid name. Another is to include the names in the FieldNames parameter instead of using the first row of data in the .txt file. A third would be to try changing the FieldDelimiter, and processing the data inside the LAE after you acquire the dataset.

I have attached a graph that should work using this third approach. If you change your FieldDelimiter to a "\n", and then name output field (in the FieldNames parameter) to FullRecord; assuming your delimeter is a ",", the attached graph should be able to read and split your data appropriately.

Note, I have changed the default action on this composite to Edit, so if you want to see what I did, you need to right click on the node and choose "Open" to see the nodes inside.

Let me know if you have any questions on this approach.

Cheers
Rich
Attachments:
ImportDataWithBlankFields.brg