Jump to content

Please Help match an imported field

Recommended Posts

Hi Guys can anyone advise me please with my following problem.

I have a database (FM15) containing a field populated with the following example "AB12343-02-12345"

I want to import a csv using "match existing records" matching only the "AB12343" element of the existing records.

Then a new field is used to store the imported "AB12343" because i don't want to overwrite the completed field of "AB12343-02-12345" if no match exists it will create a new record.

A big thank you for any Guru help on this! 

Share this post

Link to post
Share on other sites

OK I can answer my own question now, i created another field to target the import to and I used replace field contents "Left (Design) (7) ) to look up the target data.

This new field then only held the "AB12343" part.. which i could use to update matching records in found set.

If any other newbies have a similar puzzle..

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

By using this site, you agree to our Terms of Use.