parse string

[#1]

Hi,

from a field value like "80-100%" i want to extract the first % value (80) and save it in a field and also the 2nd % value (100) and save it in another field.

How can this be done ?

Thanks.

K

[tresesco]

try:

Load

Subfield(Yourfield, '-', 1) as Field1,

PurgeChar(Subfield(YourField, '-', 2), '%') as Field2

From ...;

[#3]

Hi,

I hope, you can use the function SubField(Field1,'-') for first value to be stored and TextBetween(Field1, '-','%') for second value to be stored in variable.