In what type of field did these hyperlinks get stored in. Text or container fields?
Either way, you can do a batch update of the field in all records in the table with Replace Field Contents, using the calculation option.
"F" & Right ( YourTable::YourField ; Length ( YourTable::yourField ) - 1 )
Works for a text field. For a container field, use:
"F" & Right ( YourTable::YourField ; Length ( GetAsText ( YourTable::yourField ) ) - 1 )
Thanks for your quick answer.
I'm going to try this a.s.a.p.