VRL output with "|" delimiter

[Tim Pashon]

This may be an easy one.  I’m creating a variable length file and want to use a pipe character, “|”, as a delimiter.  I’ve created the file and have tested and have the comma delimeter without problems.  How do I get my |?

Also, is there any way to output the field names as a header line?

Topic

[Levy Lazarre]

Tim,

To change the delimiter, open your VRL file in the GUI editor (Vrl Configurator).

Then on the IDE menu bar, select OPTIONS —> Global Properties. This will present you with a dialogue allowing you to change the field separator from the default (comma) to a pipe. You usually should do this before defining your fields.

[Tim Pashon]

I knew it had to be something pretty simple that I just wasn’t finding.

Thank you!

[Levy Lazarre]

The VRL is just a template.

In order to output the field names as a header line, you could hard copy the field names to the first iteration in your Xlate, for example

COPY =LASTNAME  —-> vrl field for last name

COPY =FIRSTNAME

---

>vrl field for first name

Then you can start the regular iteration to output the data values.

[Author]

Replies