LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  whitespace , how to mitigate?

    Employee
    Posted 03-29-2010 18:00

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

    Originally posted by: PGeee

    where I get errors like "Field 8 on output has a zero-length or all whitespace name."; i've always fixec up the input file and reran. However, it would be nice to handle it rather than fix the file, eg. ignore the column. is this possible? the node is a csv read


  • 2.  RE: whitespace , how to mitigate?

    Employee
    Posted 03-30-2010 08:57

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

    Originally posted by: xathras

    Hi,
    Could you give an example?
    Will all values in the column be blank?


  • 3.  RE: whitespace , how to mitigate?

    Employee
    Posted 03-30-2010 14:09

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

    Originally posted by: stonysmith

    Attached is a node that we've developed that handles some of the more common problems with CSV files.

    It has an option called "Remove Blanks From Column Names" that can be used to change "EC ID" into "EC_ID"

    Plus, it will handle the situation where you sometimes find that a column name is completely blank.
    Attachments:
    ConvertCSV.txt