?
Solved

Is it possible to export first and last names separately in Goldmine 6.7?

Posted on 2010-04-01
3
Medium Priority
?
636 Views
Last Modified: 2013-11-15
I would like to export some contact names from Goldmine into Excel but I need to have the first and last name separated. Goldmine puts them together as "Contact Name". There is a last name export option but I cant find a first name option.  Please help!

Thank you!
0
Comment
Question by:Cari_Energie
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
stevengraff earned 2000 total points
ID: 29367639
In the Export Wizard, choose the contact field and the last name field. Then, highlight the contact entry on the right, and click Edit Expr. Change the expression as you see it to:

word(contact,1)

and this will give you the first name.

See: http://screencast.com/t/MTIwNmNiNzc
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 29368886
By the way, I should point out that the answer I'm giving does not entail use of the Excel/GoldMine integration module... we're merely exporting from GoldMine using Tools | Export, and then importing into Excel afterward.
0
 

Author Closing Comment

by:Cari_Energie
ID: 31710007
You are a genius!  Thank you. Your solution worked perfectly. I would never have figured that out on my own.  
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question