Subfield command for "Any" (wildcard)

[alexis]

I wish to expand the Combis table to replace the delimited "Tec" and "Class" fields into individual rows.

Most of it can be done REALLY easily by saying (in the Combi load):

subfield (Tec, '|') as TecID          // this will join it with the Tec table

subfield (Class, '|') as ClassID    // this will join it with the Classes table

Any ideas how to expand/handle the Any (in Tec) and Any (in Class) ?

Thanks in advance

Alexis

[jonathandienst]

Alexis

My proposal is rather a quick & dirty solution to the problem as I had very limited time to work on it. The complexity arises because the application is "wildcarding" 2 fields.

I would be very interested in seeing the results of anyone successfully optimising this script.

Regards

Jonathan

[alexis]

Hi Sivaraj,

I have taken your latest version and adapted it slightly to give me what I wanted (see attached).

Thank you once again for your help.

Best regards

Alexis

[alexis]

Thanks Henric - a very useful read!

Regards

Alexis