Does anyone know of a prg or some utility that will write the code out for Gather Memvar?

I have an SQL remote view with long field names and MANY fields.


I have a DBf with many of the same fields but names only 10 long.(it is a stand alone DBF)


So I need to build this code then drop off the extra characters on short field names


Replace Field_name101 with m.Field_name101
Replace User_Field_name102 with m.user_Field_name102

Then I change it to:

Replace Field_name101 with m.Field_name
Replace User_Field_name102 with m.user_Field