Iterate on a VRL

[David Garcia]

Is it possible to iterate over a VRL? We have a comma-delimited file with repeating fields on the same line. There does not appear to be any way to specify a basis for a field in an FRL.

I seem to recall a method involving appending a counter variable to the field name to access the data. This just results in the xlate placing the name of the field instead of the contents into the output.

I’ve searched the archives, others have posted similar questions but there was never a solution. Any ideas?

Thanks!

David Garcia

Topic

[James Cobane]

David,

If your fields are named such that they have a sequential naming convention (i.e. field1, field2, field3), you can use an iterate with a list basis {1 2 3 4 5 …} and reference your field within the iteration using the iteration variable you assigned (i.e. %l1); thus, your field reference in the xlate action would be field%l1.

Hope this helps.

Jim Cobane

PHNS, Inc.

[Author]

Replies