Enhance Controls table fied atf_field_data.

[Namasiva]

Hello,
I have a question how to filter data out of one field. I need this for a report for show the sod_due_date before and after change, which is stored in the Enhance Controls table fied atf_field_data.
I have the following field contents of atf_field_data
"sod_due_date2008/08/072008/07/03sod_promise_date2008/08/072008/08/05"
The field is used for store changed on the field sod_due_date and sod_promised_date.
the file contents means the following
sod_due_date = value-field for which a change is done, in this case sod_due_date
2008/08/07 = value after change
2008/07/03 = value before change
sod_promise_date = value-field for which a change is done, in this case sod_due_date
2008/08/07 = value after change
2008/08/05 = value before change
For a report in need to display the value before change for sod_due_date and sod_promise_date.
I know how to find this but not in Progress languege.
for sod_due_date changes:
For each atf_field_data search for "sod_due_date" and then take the value after the space. this is need be assigned to soddue_after, then find the second value after sod_due_date, thus must assigned to soddue_before.
for sod_promise_date changes:
For each atf_field_data search for "sod_promise_date" and then take the value after the space. this is need be assigned to sodpromise_after, then find the second value after sod_promise_date, thus must assigned to sodpromise_before.
Can you help me with this ?

 

[Kishor Chari]

If the field length is fixed then use substring function to parse each field value.