John,

You can use macro substitution. One thing to keep in mind is that macro substitution works only with memory variables, not with fields. So you might do something like this:

m.lcReplace='REPLACE '+mytable.SourceField+' WITH '+mytable.Protocol
&lcReplace

Hope this helps.

>I am working on doing routine data imports from remote systems utilizing two data structures that are different from the local data structures, and cannot be changed.
>
>As a result, we have to map the incoming data to match the local fields, possibly performing some other manipulations. Currently, this mapping is hardcoded into the import routines.
>
>What I would like to do is drive the mapping out of a table. The MAPTABLE will contain the source table and fieldnames, the destination table and fieldnames, and the mapping protocol. For example, a last name may come over from field "last_name" all in UPPER case. I want to put it into "name1l", in PROPER case. The map protocol would look like this : PROPER(sourcetable.last_name)
>
>How do I get this to work in code, where the procedure/method/function reads the protocol and then applies it?
>
>Thanks,
>
>John