Qv table (field) transformation

[pamaxeed]

Hi,

i need some help to get rid with this issue.

I have a table with n fields in my .qv application.

The field x in my table can contain the following value "50% = 430501, 50% = 440511"

My task should to parse this value and in the case it contains more elements (think it like a string array) split it into n (2 in the example i gave above) records (with deliimiter is ',').

How i can accomplish it in .qv?

Input: Field value array with the following format "50% = 430501, 50% = 440511"

Output: n records for n elements in the array

Thanks,

Patric

[hic · Accepted solution]

The Subfield function will loop through the string, and create one record per value:

     Subfield( <Field>, ',' ) as NewField

HIC

[pamaxeed]

Thanks!

It was more easy as i thought