LAE

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

Originally posted by: Rapkat

I am trying to bring a file which is Tab Delimitered, what do I use for :

1. FieldDelimiter
2. RecordDelimiter

and do I need to complete any of the other boxes e.g FieldNames etc

Thanks.

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

Originally posted by: stonysmith

Use \t for a tab in the FieldDelimiter
Use \n for newline in the RecordDelimiter

Does the file have a header row? If not, you'll have to provide a list of FieldNames. If it does have a proper header row, then you can leave that box empty.

The other options QuoteCharacter, etc can usually be left blank.. their description in the NodeHelp should be enough to get you thru those if you need them.

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

Originally posted by: timonk

Rapkat,

If you are trying to load a tab-delimited file, you would use

1. FieldDelimiter =\t
2. RecordDelimiter =\n

The control characters for tabs and newlines.

And aside from specifying the file, and those fields, you are not required to enter a value for the other parameters. They are optional depending on your input.

The Help section on this node describes each of the parameters, including whether they have default values. For example, if left alone, the FieldNames defaults to the first row of your input data. (i.e. assumes that your file has its own column header row)

Regards
Timon Koufopoulos
MDA Support.

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

Originally posted by: ltolleson

If the file is a standard tab delimited file with a header row you could simply use the BRD File node which by default expects the file format to be tab delimited.

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

Originally posted by: adzmans

I tried to input data from delimiter file but some of the fields are blank. I'm using

1. FieldDelimiter =|
2. RecordDelimiter =\n

I got error message as follows;
Level: 2; Type: 0; Desc: "Field 13 on output has a zero-length or all whitespace

How to skip the blanks?

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

Originally posted by: rboccuzzi

If you create a second output on the node, the second output will be an error output, and those lines will be placed on the second output and skipped from the first. You can then decide if you want to ignore them, fix them in the source, or try to parse them via other means inside the graph.

Cheers
Rich