.csv file with pipe lines to separate the fields

[santiago guzman]

How do I tell Cloverleaf that after a | a new field starts? I have a .csv file for example:

0445|CATH ALL PURPOSE 22FR||EA|1.00|EA|

How which setting in the VRL tool do I set the | to break the field and start a new one, like:

MESSAGE 1

                ITEM: ch >0445<    DESCRIPTION: ch >CATH ALL PURPOSE 22FR<  DESCRIPTION2: ch ><      STOCK_UOM: ch >EA<

Topic

[Jim Kosloskey]

In the VRL configuration go to the Global Options in the menu bar. That should give you a place to indicate the separator.

Just make sure the data won’t have the separator inside.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Alice Kazin]

Global Options is part of Options

[santiago guzman]

I keep getting this messag for the command output when I pick | for the separator: (Also I made sure the data doesn’t have spaces) Any ideas as to what I’m doing wrong?

Usage: d:Healthvisioncis5.8integratorbinhcivrltest.exe [-a] [-e enc] [-d n] [-f format] vrl [file]

   -a        = process all records in file

   -e enc    = change encoding from enc to utf-8

   -d n      = show data at detail level ‘n’

   -f format = file format specifier

   vrl       = name of VRL to test

   file      = data file to test with

format values:

   len10     = 10-byte length encoded

   nl        = newline-terminated (default)

   eof       = eof-terminated

[santiago guzman]

The reason why I kept getting that message was because the test file I was using had spaces, EX:

test one.csv

As soon as I got rid of the space it worked like a charmed.

testone.csv or test_one.csv

Thanks for the help!

[Author]

Replies