Script to change 10-14 to 10,11,12,13,14

[MattPage]

Hi all,

We have a v5 database and need a script to update a field value.

The field (Page_Numbers) has been entered as 10-14 for example, but we need it to list all the page numbers like this 10,11,12,13,14

Could someone suggest a script for doing this, kind of new to FM scripting so I am not too sure where to start.

Thanks

[-Queue-]

Add two global number fields, then use this script.

Set Field [globalnum1, LeftWords( Page_Numbers, 1 )]

Set Field [globalnum2, RightWords( Page_Numbers, 1 )]

Set Field [Page_Numbers, globalnum1]

Loop

Exit Loop If [RightWords( Page_Numbers, 1 ) = globalnum2]

Set Field [Page_Numbers, Page_Numbers & ", " & NumToText(RightWords( Page_Numbers, 1 ) + 1)]

End Loop