Iterate With VRL

[Lane O’Brien]

I am trying to take a CSV file and transfigure that to a HL7 message. I have done this many times with no issue.

However, with this one I am needing to try and iterate through the CSV and if a column is blank then I need to skip it. I just built the beginnings on an Xlate and tried it in the testing tool and it gives me the error \”Iterations over VRL isn’t supported\”.

I asked Infor support about this and this is what I got back.

“Yes it is possible to do what you are needing.
However, it will require some some tcl code as well to make this work.

Below are a s suggestions from our services and comment from the services team:
You can make a VRL with the max number of fields, then check each one if valued. Or if they’re totally unknown and just repeating a single field an unknown number of times, then you can make a single field VRL and split in a TCL call out to an @ var then use a USER iterate to dynamically get the data out.

When using a tclproc… split based on the delimiter and if length and if it is not what is is supposed to be kill it.”

 

So with all that said I was hoping there were some examples that may be out there that you all could help me find. I am not good with TCL so any help would be very much apricated.

Topic

[Jim Kosloskey]

Depending on the VRL layout, you may not need Tcl but rather use HRL and VRL to get at the repetitions.

If you would like to explore this further and brainstorm some, email me and I will try to help.

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

[Max Drown (Infor)]

Lane, I sent a BOX to Support with an example that might help. Trying to attach it here, too.

Attachments:

You must be logged in to view attached files.

-- Max Drown (Infor)

[Author]

Replies