Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try:
Load
Subfield(Yourfield, '-', 1) as Field1,
PurgeChar(Subfield(YourField, '-', 2), '%') as Field2
From ...;
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.