I would start by attaching the source table to the target DB. Then run a query that creates a temporary table. In the process of creating the temporary table, strip the undesired characters using the Left() function.
In your target DB, have the list control's source be the temporary table.

Milton