Sonny Software

Hi --
Many apologies if this has been covered (just send me to the link) but I've done some searching and can't find what I'm looking for.

My primary problem is that the Journal wants:

12. Brown JE. Vancouver style: formatting references. J Med Style. 2007 Jan;5(10 Suppl 1):516-28.

Note the "Jan" after the 2007 year (but no 'day'). My date fields have full dates: "Jan 31, 2007" (of course sometimes the formats differ depending on the source). Dates gets messy but can be managed with dedicated PERL modules. What I would like to do is export the date field (and the record identifier), manipulate the dates to get three consistent fields ("Month", "Day", "Year"). Then I'd like to reimport (merge on record ID) the resulting file into three custom userX fields.

Does BE allow merging like this? Do I need to export the full DB as XML and do it outside of BE and then import as a new DB?

Am I barking up the wrong tree? Again, apologies if this is old news.

Thanks,
Eric
(Registered owner 11.1.5, OS X)

You can export as XML or tab-delimited, modify the text, and import to a fresh database (the unique id's will be retained with XML, I'm not sure about tab-delimited). But data will go back into the same field they "came from". To assign to other fields, you can use Global Change -> Move one the metadata are in the database.

Jon
Sonny Software