Iterate With VRL

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.