 |
|
List Archives >
Procite List Archive >
Archive by date >
This Month By Date >
This Month By Topic
Copying text from one field to another in same record
| Copying text from one field to another in same record |
|
Author: STANLEY: Dr Philip
Posted: Thu, 8 Mar 2001 15:23:54 -0000
|
Date: Thu, 8 Mar 2001 15:23:54 -0000
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "STANLEY: Dr Philip"
Subject: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0000_01C0A7E3.C97B4E10"
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C0A7E3.C97B4E10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I wonder if anyone knows of a way within ProCite 5 of **copying** the
contents of one field into another within the same record.
A partial solution involves exporting as Tab delimited text, importing this
into say Excel and then copying the required field into a new field and then
re-importing into ProCite. But then you loose bold, italic superscript etc
etc.
I have about 30 thousand records to edit.
********************************************************************
Dr Philip STANLEY
Email:
Web site: http://www.lumiweb.com
Tel: +44 1223-460888
FAX: +44 1223-461777
Cambridge Research & Technology Transfer Ltd
48 Glisson Road
Cambridge CB1 2HF
England
********************************************************************
------=_NextPart_000_0000_01C0A7E3.C97B4E10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D234051415-08032001>I=20
wonder if anyone knows of a way within ProCite 5 of **copying** the =
contents of=20
one field into another within the same record. </SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D234051415-08032001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D234051415-08032001>A=20
partial solution involves exporting as Tab delimited text, importing=20
this into say Excel and then copying the required field into a new =
field=20
and then re-importing into ProCite. But then you loose bold, italic =
superscript=20
etc etc.</SPAN></FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV><SPAN =
class=3D234051415-08032001></SPAN><FONT=20
face=3DArial><FONT color=3D#0000ff><FONT=20
size=3D2>I have about 30 thousand records t=
o edit.<SPAN=20
class=3D234051415-08032001></SPAN></FONT></FONT></FONT><BR>
<P><FONT=20
size=3D2>****************************************************************=
****<BR>Dr=20
Philip STANLEY<BR><BR>Email: =
site: <A=20
target=3D_blank=20
href=3D"http://www.lumiweb.com/">http://www.lumiweb.com</A><BR><BR>Tel:=20
+44 1223-460888<BR>FAX: +44=20
1223-461777<BR><BR>Cambridge Research & Technology Transfer =
Ltd<BR>48=20
Glisson Road<BR>Cambridge CB1=20
2HF<BR>England<BR><BR>***************************************************=
*****************<BR> </FONT>=20
</P></BODY></HTML>
------=_NextPart_000_0000_01C0A7E3.C97B4E10--
|
| Re: Copying text from one field to another in same record |
|
Author: Dirk Enneking
Posted: Thu, 8 Mar 2001 16:45:53 +0100
|
Date: Thu, 8 Mar 2001 16:45:53 +0100
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Dirk Enneking
Subject: Re: Copying text from one field to another in same record
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
in procite 5 menu -> database / edit marked records/ global move field
hope this helps
Dirk
|
| Re: Copying text from one field to another in same record |
|
Author: STANLEY: Dr Philip
Posted: Thu, 8 Mar 2001 16:09:48 -0000
|
Date: Thu, 8 Mar 2001 16:09:48 -0000
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "STANLEY: Dr Philip"
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thank you for your reply. Problem I have is not that I want to MOVE a field
but rather I need to COPY the contents of one field into another field.
********************************************************************
Dr Philip STANLEY
Email:
Web site: http://www.lumiweb.com
Tel: +44 1223-460888
FAX: +44 1223-461777
Cambridge Research & Technology Transfer Ltd
48 Glisson Road
Cambridge CB1 2HF
England
********************************************************************
|-----Original Message-----
|From: PROCITE The Personal Bibliographic Software Discussion List
Behalf Of Dirk Enneking
|Sent: 08 March 2001 15:46
|To:
|Subject: Re: Copying text from one field to another in same record
|
|
|in procite 5 menu -> database / edit marked records/ global move field
|hope this helps
|
|Dirk
|
| Re: Copying text from one field to another in same record |
|
Author: Suat Tuzgöl
Posted: Thu, 8 Mar 2001 20:46:09 +0100
|
Date: Thu, 8 Mar 2001 20:46:09 +0100
Reply-To:
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Suat Tuzgöl
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
| Thank you for your reply. Problem I have is not that I want to MOVE a
field
| but rather I need to COPY the contents of one field into another field.
After moving (Database, Edit Marked records, Global Move Field), you can
delete the "moved field" content via Database, Edit Marked records, Global
Edit. Choose the CHANGE option "Clear the entire Field". It's a 2-step
action, but the result is the same.
Suat Tuzgöl
DISC * P.O. Box 423 | 2100 AK Heemstede, The Netherlands
Ph +31 (0)23 547 1855 | Fax +31 (0)23 547 1859
www.disc-net.nl |
**** NEW **** WWW.RESEARCHSOFTWARE.NL ****
|
| Re: Copying text from one field to another in same record |
|
Author: Mary HUXLIN
Posted: Fri, 9 Mar 2001 08:23:51 +1100
|
Date: Fri, 9 Mar 2001 08:23:51 +1100
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Mary HUXLIN
Subject: Re: Copying text from one field to another in same record
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Since ProCite is a Windows application, a simple COPY (CTLL+C) and PASTE
(CTRL+V) would do what you want to do. See information included in the
online Help of ProCite
"You can copy text within or between applications by using the clipboard.
Select the text to be copied and use either the Edit menu Copy and Paste
commands, the buttons on the toolbar, or the equivalent keyboard shortcuts."
Regards,
Mary
<>**<><><>**<><><>**<><><>**<><><>**<><><>**
Mary E HUXLIN
INIS Liaison Officer
ANSTO - Information Management Div.
Lucas Heights Science & Technology Centre
Private Mail Bag 1
MENAI, NSW 2234
AUSTRALIA
Phone: 61 2 9717 3259
Fax: 61 2 9717 9294
E-mail:
> >Australian INIS Centre:
http://www.ansto.gov.au/info/library/inis1.html
<http://www.ansto.gov.au/info/library/inis1.html>
<>**<><><>**<><><>**<><><>**<><><>**<><><>**
-----Original Message-----
From: STANLEY: Dr Philip
Sent: Friday, 9 March 2001 3:10
To:
Subject: Re: Copying text from one field to another
in same record
Thank you for your reply. Problem I have is not that I want
to MOVE a field
but rather I need to COPY the contents of one field into
another field.
********************************************************************
Dr Philip STANLEY
Email:
Web site: http://www.lumiweb.com
Tel: +44 1223-460888
FAX: +44 1223-461777
Cambridge Research & Technology Transfer Ltd
48 Glisson Road
Cambridge CB1 2HF
England
********************************************************************
|-----Original Message-----
|From: PROCITE The Personal Bibliographic Software
Discussion List
Behalf Of Dirk
Enneking
|Sent: 08 March 2001 15:46
|To:
|Subject: Re: Copying text from one field to another in same
record
|
|
|in procite 5 menu -> database / edit marked records/ global
move field
|hope this helps
|
|Dirk
|
| Re: Copying text from one field to another in same record |
|
Author: Suat Tuzgöl
Posted: Thu, 8 Mar 2001 23:48:30 +0100
|
Date: Thu, 8 Mar 2001 23:48:30 +0100
Reply-To:
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Suat Tuzgöl
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
| Since ProCite is a Windows application, a simple COPY (CTLL+C) and PASTE
| (CTRL+V) would do what you want to do. See information included in the
| online Help of ProCite
I believe ctrl-c and ctrl-v is just fine for one or perhaps 20 records.
However, for 20,000 records, ctrl-v and ctrl-c would cause repetitive strain
injury ;).
Rgds,
Suat Tuzgöl
DISC * P.O. Box 423 | 2100 AK Heemstede, The Netherlands
Ph +31 (0)23 547 1855 | Fax +31 (0)23 547 1859
www.disc-net.nl |
**** NEW **** WWW.RESEARCHSOFTWARE.NL ****
|
| Re: Copying text from one field to another in same record |
|
Author: Walmor Piccinini
Posted: Fri, 9 Mar 2001 08:55:53 +0000
|
Date: Fri, 9 Mar 2001 08:55:53 +0000
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Walmor Piccinini
Organization: Webmaster da ABP
Subject: Re: Copying text from one field to another in same record
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi Dr. Stanley. I think that your problem is 30.000 changes and you intend to
do asap. The only way that we know is one by one. copy and paste. It's a huge
task, lots of hours. By the way, I'm doing bibliographic databank and wanna
make one CD-Rom to publish. In the past I used Procite 3.2 read only. I upgrade
to Procite 5 and the new version do not permit read only version. I need some
help here. Thanks. Walmor
Dr. Walmor Piccinini
webmaster of the Brazilian Psychiatric Association (
http://www.abpbrasil.org.br)
Porto Alegre, RS. Brazil
STANLEY: Dr Philip wrote:
> Thank you for your input, Suat.
>
> I think that I have not clearly explained what I am trying to do. I need to
> COPY the contents of one field (say # 30) into another field (say #32 which
> is empty).
>
> In this way I wish to finish up with each marked record having both these
> fields (original #30 and target #32) with exactly the same content.
>
> ********************************************************************
> Dr Philip STANLEY
>
> Email:
>
> Web site: http://www.lumiweb.com
>
> Tel: +44 1223-460888
> FAX: +44 1223-461777
>
> Cambridge Research & Technology Transfer Ltd
> 48 Glisson Road
> Cambridge CB1 2HF
> England
>
> ********************************************************************
>
> |-----Original Message-----
> |From: PROCITE The Personal Bibliographic Software Discussion List
> Behalf Of Suat Tuzgl
> |Sent: 08 March 2001 19:46
> |To:
> |Subject: Re: Copying text from one field to another in same record
> |
> |
> || Thank you for your reply. Problem I have is not that I want to MOVE a
> |field
> || but rather I need to COPY the contents of one field into another field.
> |
> |After moving (Database, Edit Marked records, Global Move Field), you can
> |delete the "moved field" content via Database, Edit Marked records, Global
> |Edit. Choose the CHANGE option "Clear the entire Field". It's a 2-step
> |action, but the result is the same.
> |
> |Suat Tuzgl
> |
> |DISC * P.O. Box 423 | 2100 AK Heemstede, The Netherlands
> |Ph +31 (0)23 547 1855 | Fax +31 (0)23 547 1859
> |www.disc-net.nl |
> |
> |**** NEW **** WWW.RESEARCHSOFTWARE.NL ****
|
| Re: Copying text from one field to another in same record |
|
Author: STANLEY: Dr Philip
Posted: Fri, 9 Mar 2001 09:23:44 -0000
|
Date: Fri, 9 Mar 2001 09:23:44 -0000
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "STANLEY: Dr Philip"
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Thank you for your input, Suat.
I think that I have not clearly explained what I am trying to do. I need to
COPY the contents of one field (say # 30) into another field (say #32 which
is empty).
In this way I wish to finish up with each marked record having both these
fields (original #30 and target #32) with exactly the same content.
********************************************************************
Dr Philip STANLEY
Email:
Web site: http://www.lumiweb.com
Tel: +44 1223-460888
FAX: +44 1223-461777
Cambridge Research & Technology Transfer Ltd
48 Glisson Road
Cambridge CB1 2HF
England
********************************************************************
|-----Original Message-----
|From: PROCITE The Personal Bibliographic Software Discussion List
Behalf Of Suat Tuzgl
|Sent: 08 March 2001 19:46
|To:
|Subject: Re: Copying text from one field to another in same record
|
|
|| Thank you for your reply. Problem I have is not that I want to MOVE a
|field
|| but rather I need to COPY the contents of one field into another field.
|
|After moving (Database, Edit Marked records, Global Move Field), you can
|delete the "moved field" content via Database, Edit Marked records, Global
|Edit. Choose the CHANGE option "Clear the entire Field". It's a 2-step
|action, but the result is the same.
|
|Suat Tuzgl
|
|DISC * P.O. Box 423 | 2100 AK Heemstede, The Netherlands
|Ph +31 (0)23 547 1855 | Fax +31 (0)23 547 1859
|www.disc-net.nl |
|
|**** NEW **** WWW.RESEARCHSOFTWARE.NL ****
|
| Re: Copying text from one field to another in same record |
|
Author: Suat Tuzgöl
Posted: Fri, 9 Mar 2001 12:37:48 +0100
|
Date: Fri, 9 Mar 2001 12:37:48 +0100
Reply-To:
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Suat Tuzgöl
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Dear Philip,
| I think that I have not clearly explained what I am trying to do.
| I need to COPY the contents of one field (say # 30) into another field
(say
| #32 which is empty).
Sorry for the misinterpret. It was late in the evening :)). And you're
right. There seems no quick or global solution for this.
Rgds,
Suat Tuzgöl
|
| Re: Copying text from one field to another in same record |
|
Author: David Jacobowitz
Posted: Fri, 9 Mar 2001 07:21:58 -0500
|
Date: Fri, 9 Mar 2001 07:21:58 -0500
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: David Jacobowitz
Organization: University of Vermont
Subject: Re: Copying text from one field to another in same record
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Here's what I'd do. I'd export the selected records to a delimited file. Then I'd
use a great text editor such as TextPad (demo free at http://www.textpad.com) to
edit it. I'd write a macro to grab the information from the 32nd field and paste it
into the 33rd (whatever) field. Then import the modified delimited file into
ProCite.
Dave
Walmor Piccinini wrote:
> Hi Dr. Stanley. I think that your problem is 30.000 changes and you intend to
> do asap. The only way that we know is one by one. copy and paste. It's a huge
> task, lots of hours. By the way, I'm doing bibliographic databank and wanna
> make one CD-Rom to publish. In the past I used Procite 3.2 read only. I upgrade
> to Procite 5 and the new version do not permit read only version. I need some
> help here. Thanks. Walmor
> Dr. Walmor Piccinini
> webmaster of the Brazilian Psychiatric Association (
> http://www.abpbrasil.org.br)
> Porto Alegre, RS. Brazil
>
> STANLEY: Dr Philip wrote:
>
> > Thank you for your input, Suat.
> >
> > I think that I have not clearly explained what I am trying to do. I need to
> > COPY the contents of one field (say # 30) into another field (say #32 which
> > is empty).
> >
> > In this way I wish to finish up with each marked record having both these
> > fields (original #30 and target #32) with exactly the same content.
> >
> > ********************************************************************
> > Dr Philip STANLEY
> >
> > Email:
> >
> > Web site: http://www.lumiweb.com
> >
> > Tel: +44 1223-460888
> > FAX: +44 1223-461777
> >
> > Cambridge Research & Technology Transfer Ltd
> > 48 Glisson Road
> > Cambridge CB1 2HF
> > England
> >
> > ********************************************************************
> >
> > |-----Original Message-----
> > |From: PROCITE The Personal Bibliographic Software Discussion List
> > Behalf Of Suat Tuzgl
> > |Sent: 08 March 2001 19:46
> > |To:
> > |Subject: Re: Copying text from one field to another in same record
> > |
> > |
> > || Thank you for your reply. Problem I have is not that I want to MOVE a
> > |field
> > || but rather I need to COPY the contents of one field into another field.
> > |
> > |After moving (Database, Edit Marked records, Global Move Field), you can
> > |delete the "moved field" content via Database, Edit Marked records, Global
> > |Edit. Choose the CHANGE option "Clear the entire Field". It's a 2-step
> > |action, but the result is the same.
> > |
> > |Suat Tuzgl
> > |
> > |DISC * P.O. Box 423 | 2100 AK Heemstede, The Netherlands
> > |Ph +31 (0)23 547 1855 | Fax +31 (0)23 547 1859
> > |www.disc-net.nl |
> > |
> > |**** NEW **** WWW.RESEARCHSOFTWARE.NL ****
--
802.656.2539
ASEBA - Child Behavior Checklist
http://ASEBA.uvm.edu/ http://www.uvm.edu/~djacobow
|
| Re: Copying text from one field to another in same record |
|
Author: C Anthony Lewis
Posted: Fri, 9 Mar 2001 13:01:54 GMT
|
Date: Fri, 9 Mar 2001 13:01:54 GMT
Reply-To:
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "C. Anthony Lewis"
Organization: University of Plymouth
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
Hello,
I don't use Procite (so why am I here?) but how about something
like:
1. Export entire database as a tagged text (ascii) file
2. Read into a word processor and use a macro to insert a copy of
the required field
3. Import the file back into Procite
Step 2. could also be achieved with a small text processing program
(PERL, VisualBasic etc.) or by manipulation in a spreadsheet. Of
course, any fancy formatting that Procite allows will be lost!
I've recently been converting my old SCIMATE database to RefManager
which has required a lot of messing about...
Good luck,
Anthony Lewis
>
> I think that I have not clearly explained what I am trying to do. I need to
> COPY the contents of one field (say # 30) into another field (say #32 which
> is empty).
>
> In this way I wish to finish up with each marked record having both these
> fields (original #30 and target #32) with exactly the same content.
>
> Dr Philip STANLEY
>
> Email:
> Web site: http://www.lumiweb.com
> Tel: +44 1223-460888
> FAX: +44 1223-461777
> Cambridge Research & Technology Transfer Ltd
> 48 Glisson Road
> Cambridge CB1 2HF
> England
C. Anthony Lewis
Petroleum & Environmental Geochemistry Group,
Department of Environmental Sciences,
University of Plymouth,
Plymouth, Devon PL4 8AA, U.K.
tel: +44 (0)1752 233000 ext. 2988
FAX: +44 (0)1752 233035
e-mail:
|
| Re: Copying text from one field to another in same record |
|
Author: Leo Rose
Posted: Fri, 9 Mar 2001 09:07:50 -0500
|
Date: Fri, 9 Mar 2001 09:07:50 -0500
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Leo Rose
Subject: Re: Copying text from one field to another in same record
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
C'mon guys, are you seriously suggesting that Dr. Stanley Ctrl+C and Ctrl+V
20,000 records? That is ludicrous! I just did exactly what Dr. Stanley
wants to do in less than 5 minutes on my computer.
1. Simply export the all the marked records in comma delimited format
(Procite's default setting) as a text file.
2. Open the text file in Excel Follow Excel's prompts to format it correctly
(Comma delimited).
3. Copy the portion of the column (should be below the workform information)
and paste it where you want (It is easier than it sounds).
4. "Save As" choose a txt extension
5. Import into Procite (open the txt file in procite and choose where you
want it to go)
20,000 records copied
I hope this has helped. You DON'T need to Ctrl+C and Ctrl+V every record.
It is really a very easy thing to do. I copied the record ID field into the
Call number field and it worked fine. Now the same number is in both
fields.
Practice on a smaller database if you like.
Leo Rose
|
| Re: Copying text from one field to another in same record |
|
Author: STANLEY: Dr Philip
Posted: Fri, 9 Mar 2001 17:12:24 -0000
|
Date: Fri, 9 Mar 2001 17:12:24 -0000
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "STANLEY: Dr Philip"
Subject: Re: Copying text from one field to another in same record
In-Reply-To: <DFFD733ACE9ED4119B1900D0B70622DC1BEF1F@CPNTA>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Thanks to all for your helpful suggestions.
As I mentioned at the beginning of this thread my difficulty with exporting
say as an ASCI comma delimited, importing into Excel and duplicating the
column in question and re-exporting to ProCite is that one loses all the
bold and italic attributes on the first export. My database file has a large
number of plant names in Latin which by convention are given in italics.
I had thought of writing a style which allowed me to "export" the file as a
bibliography with bold and italic attributes intact. Then use a macro to
duplicate the field in question. Then re-import into a new ProCite database.
The problem here is that the final import does not recognise bold and italic
attributes.
Then I thought of using a macro to write an ASCI "begin tag" and "end tag"
for begin and end italic and bold. However as you will know there is no
Find and Replace in ProCite which allows one to insert a bold or italic
attribute.
09MAR01
********************************************************************
Dr Philip STANLEY
Email:
Web site: http://www.lumiweb.com
Tel: +44 1223-460888
FAX: +44 1223-461777
Cambridge Research & Technology Transfer Ltd
48 Glisson Road
Cambridge CB1 2HF
England
********************************************************************
|-----Original Message-----
|From: PROCITE The Personal Bibliographic Software Discussion List
Behalf Of Leo Rose
|Sent: 09 March 2001 14:08
|To:
|Subject: Re: Copying text from one field to another in same record
|
|
|C'mon guys, are you seriously suggesting that Dr. Stanley Ctrl+C and Ctrl+V
|20,000 records? That is ludicrous! I just did exactly what Dr. Stanley
|wants to do in less than 5 minutes on my computer.
|
|1. Simply export the all the marked records in comma delimited format
|(Procite's default setting) as a text file.
|2. Open the text file in Excel Follow Excel's prompts to format it
|correctly
|(Comma delimited).
|3. Copy the portion of the column (should be below the workform
|information)
|and paste it where you want (It is easier than it sounds).
|4. "Save As" choose a txt extension
|5. Import into Procite (open the txt file in procite and choose where you
|want it to go)
|
|20,000 records copied
|
|I hope this has helped. You DON'T need to Ctrl+C and Ctrl+V every record.
|It is really a very easy thing to do. I copied the record ID
|field into the
|Call number field and it worked fine. Now the same number is in both
|fields.
|
|Practice on a smaller database if you like.
|
|Leo Rose
|
| Re: Copying text from one field to another in same record |
|
Author: E John Sadler
Posted: Fri, 9 Mar 2001 12:16:58 -0500
|
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
All,
This activity reminds me of my request to the group a month or so ago. I
have several free-text (almost) databases of several hundreds of records and
was looking for a way to edit and import these and, using the same
procedure, fix a bad import of a 1200- record database that had some fields
in error. My first thought was to export into ASCII, comma-delimited or
otherwise, edit, and re-import. All the ProCite people said not to do this,
and recommended doing everything inside ProCite.
Most of the recommendations for this large-file problem sound like they
would help me. However, I am still a little unsure of one aspect of that
problem. I believe the original query was worried about losing special
formatting, and the export/re-import suggestions so far still lose this,
don't they?
Cheers,
John
|
| Re: Copying text from one field to another in same record |
|
Author: Steve Johnson
Posted: Fri, 9 Mar 2001 12:20:11 -0500
|
Date: Fri, 9 Mar 2001 12:20:11 -0500
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Steve Johnson
Organization: Wildlife Conservation Society
Subject: Re: Copying text from one field to another in same record
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
The rub here is that any method involving comma delimited export is not
acceptable to Dr. Stanley as a means of duplicating the field because the
ProCite comma delimited export routine strips out typographical styles. If the
style indicators could be found and replaced with unique text strings to
indicate start italics and stop italics, text export, manipulation and text
import would solve the problem at hand.
--
Steven Johnson
Wildlife Conservation Society
718 220-6874 voice
718 220-7114 fax
|
| Re: Copying text from one field to another in same record |
|
Author: Slater, Linda
Posted: Fri, 9 Mar 2001 10:26:40 -0700
|
Date: Fri, 9 Mar 2001 10:26:40 -0700
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "Slater, Linda"
Subject: Re: Copying text from one field to another in same record
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
I have no solutions to your problem, Philip, but in reading all the messages
that have gone back and forth on this topic, I've become curious about why
you need to have the same info in two different fields? This is, of course,
really none of my business, but if you're willing to share what it is you're
ultimately trying to accomplish, I'd be interested in hearing it.
Linda
Linda Slater
John W. Scott Health Sciences Library
University of Alberta
Edmonton, AB T6G 2R7
Tel: 780-492-7948
Fax: 780-492-6960
Email:
>-----Original Message-----
>From: STANLEY: Dr Philip
>Sent: Friday, March 09, 2001 10:12 AM
>To:
>Subject: Re: Copying text from one field to another in same record
>
>
>Thanks to all for your helpful suggestions.
>
>As I mentioned at the beginning of this thread my difficulty
>with exporting
>say as an ASCI comma delimited, importing into Excel and
>duplicating the
>column in question and re-exporting to ProCite is that one
>loses all the
>bold and italic attributes on the first export. My database
>file has a large
>number of plant names in Latin which by convention are given
>in italics.
>
>I had thought of writing a style which allowed me to "export"
>the file as a
>bibliography with bold and italic attributes intact. Then use
>a macro to
>duplicate the field in question. Then re-import into a new
>ProCite database.
>The problem here is that the final import does not recognise
>bold and italic
>attributes.
>
>Then I thought of using a macro to write an ASCI "begin tag"
>and "end tag"
>for begin and end italic and bold. However as you will know
>there is no
>Find and Replace in ProCite which allows one to insert a bold or italic
>attribute.
>
>
>
>09MAR01
>********************************************************************
>Dr Philip STANLEY
>
>Email:
>
>Web site: http://www.lumiweb.com
>
>Tel: +44 1223-460888
>FAX: +44 1223-461777
>
>Cambridge Research & Technology Transfer Ltd
>48 Glisson Road
>Cambridge CB1 2HF
>England
>
>********************************************************************
>
>
>|-----Original Message-----
>|From: PROCITE The Personal Bibliographic Software Discussion List
Behalf Of Leo Rose
>|Sent: 09 March 2001 14:08
>|To:
>|Subject: Re: Copying text from one field to another in same record
>|
>|
>|C'mon guys, are you seriously suggesting that Dr. Stanley
>Ctrl+C and Ctrl+V
>|20,000 records? That is ludicrous! I just did exactly what
>Dr. Stanley
>|wants to do in less than 5 minutes on my computer.
>|
>|1. Simply export the all the marked records in comma delimited format
>|(Procite's default setting) as a text file.
>|2. Open the text file in Excel Follow Excel's prompts to format it
>|correctly
>|(Comma delimited).
>|3. Copy the portion of the column (should be below the workform
>|information)
>|and paste it where you want (It is easier than it sounds).
>|4. "Save As" choose a txt extension
>|5. Import into Procite (open the txt file in procite and
>choose where you
>|want it to go)
>|
>|20,000 records copied
>|
>|I hope this has helped. You DON'T need to Ctrl+C and Ctrl+V
>every record.
>|It is really a very easy thing to do. I copied the record ID
>|field into the
>|Call number field and it worked fine. Now the same number is in both
>|fields.
>|
>|Practice on a smaller database if you like.
>|
>|Leo Rose
>
|
| Re: Copying text from one field to another in same record |
|
Author: Leon Zimlich
Posted: Fri, 9 Mar 2001 09:34:22 -0800
|
Date: Fri, 9 Mar 2001 09:34:22 -0800
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: Leon Zimlich
Subject: Re: Copying text from one field to another in same record
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Am I mistaken in thinking that ProCite's Output Styles contain the "tags" for text attributes such as bold and italic? If this text formatting is lost through the Export/Import via Excel procedure would it be regained via ProCite's bibliography output features? Or, might it be recovered through Global editing?
Best wishes,
Leon E. Zimlich
History of Art and Architecture
University of California Santa Barbara
|
| Re: Copying text from one field to another in same record |
|
Author: STANLEY: Dr Philip
Posted: Fri, 9 Mar 2001 18:06:15 -0000
|
Date: Fri, 9 Mar 2001 18:06:15 -0000
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "STANLEY: Dr Philip"
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
I am pleased to share with you my reason for having two fields with
duplicate contents.
I am producing a large index. One field will be kept intact with the full
citation and its duplicate will be edited to conform to the formatting
requirements of the index. The full citation is required to ensure that I
don't forget the details of the original citation!!!
Each citation is presently one field and volumes and pages are in other
fields. I have now completed entering all the citations. Unfortunately to
make an alphabetic listing in the format required for the index means that
many citations need to be modified. Thus I may have "Report, Secretary,
1900" thru' "Report, Secretary, 2000" and similarly "Report, Treasurer, 1900
etc. --- each set giving 101 citations. In the index the first one is:
"Report, Secretary, 1900" but the next one would be ", , 1901" thru ", ,
2000" and then
"Report, Treasurer, 1900" but the next one would be ", , 1901" thru ", ,
2000"
Keeping track of these editings is crucial to ensure accuracy. Having tried
to do this in a word processor I know just how easy it is to loose whole
citations or groups of citations -- I have tried it!!
The sequence of citations would initially be done by the Procite alphabetic
sequence. This database will then be re-numbered so I have a pre-index which
can be re-sorted by record number and subsequently handled in record number
sequence. The record number of any record can then be manipulated one at a
time to move individual records to specific places in the sequence as
needed. For example I might want to manually move "Report, Secretary,
Special Business Meeting, 1950" to a specific place in the sequence, e.g. at
the end of "Report, Secretary,....
Hope this helps to understand my need for duplicating a field.
********************************************************************
Dr Philip STANLEY
Email:
Web site: http://www.lumiweb.com
Tel: +44 1223-460888
FAX: +44 1223-461777
Cambridge Research & Technology Transfer Ltd
48 Glisson Road
Cambridge CB1 2HF
England
********************************************************************
|-----Original Message-----
|From: PROCITE The Personal Bibliographic Software Discussion List
Behalf Of Slater, Linda
|Sent: 09 March 2001 17:27
|To:
|Subject: Re: Copying text from one field to another in same record
|
|
|I have no solutions to your problem, Philip, but in reading all
|the messages
|that have gone back and forth on this topic, I've become curious about why
|you need to have the same info in two different fields? This is,
|of course,
|really none of my business, but if you're willing to share what it
|is you're
|ultimately trying to accomplish, I'd be interested in hearing it.
|
|Linda
|
|Linda Slater
|John W. Scott Health Sciences Library
|University of Alberta
|Edmonton, AB T6G 2R7
|Tel: 780-492-7948
|Fax: 780-492-6960
|Email:
|
|
|>-----Original Message-----
|>From: STANLEY: Dr Philip
|>Sent: Friday, March 09, 2001 10:12 AM
|>To:
|>Subject: Re: Copying text from one field to another in same record
|>
|>
|>Thanks to all for your helpful suggestions.
|>
|>As I mentioned at the beginning of this thread my difficulty
|>with exporting
|>say as an ASCI comma delimited, importing into Excel and
|>duplicating the
|>column in question and re-exporting to ProCite is that one
|>loses all the
|>bold and italic attributes on the first export. My database
|>file has a large
|>number of plant names in Latin which by convention are given
|>in italics.
|>
|>I had thought of writing a style which allowed me to "export"
|>the file as a
|>bibliography with bold and italic attributes intact. Then use
|>a macro to
|>duplicate the field in question. Then re-import into a new
|>ProCite database.
|>The problem here is that the final import does not recognise
|>bold and italic
|>attributes.
|>
|>Then I thought of using a macro to write an ASCI "begin tag"
|>and "end tag"
|>for begin and end italic and bold. However as you will know
|>there is no
|>Find and Replace in ProCite which allows one to insert a bold or italic
|>attribute.
|>
|>
|>
|>09MAR01
|>********************************************************************
|>Dr Philip STANLEY
|>
|>Email:
|>
|>Web site: http://www.lumiweb.com
|>
|>Tel: +44 1223-460888
|>FAX: +44 1223-461777
|>
|>Cambridge Research & Technology Transfer Ltd
|>48 Glisson Road
|>Cambridge CB1 2HF
|>England
|>
|>********************************************************************
|>
|>
|>|-----Original Message-----
|>|From: PROCITE The Personal Bibliographic Software Discussion List
Behalf Of Leo Rose
|>|Sent: 09 March 2001 14:08
|>|To:
|>|Subject: Re: Copying text from one field to another in same record
|>|
|>|
|>|C'mon guys, are you seriously suggesting that Dr. Stanley
|>Ctrl+C and Ctrl+V
|>|20,000 records? That is ludicrous! I just did exactly what
|>Dr. Stanley
|>|wants to do in less than 5 minutes on my computer.
|>|
|>|1. Simply export the all the marked records in comma delimited format
|>|(Procite's default setting) as a text file.
|>|2. Open the text file in Excel Follow Excel's prompts to format it
|>|correctly
|>|(Comma delimited).
|>|3. Copy the portion of the column (should be below the workform
|>|information)
|>|and paste it where you want (It is easier than it sounds).
|>|4. "Save As" choose a txt extension
|>|5. Import into Procite (open the txt file in procite and
|>choose where you
|>|want it to go)
|>|
|>|20,000 records copied
|>|
|>|I hope this has helped. You DON'T need to Ctrl+C and Ctrl+V
|>every record.
|>|It is really a very easy thing to do. I copied the record ID
|>|field into the
|>|Call number field and it worked fine. Now the same number is in both
|>|fields.
|>|
|>|Practice on a smaller database if you like.
|>|
|>|Leo Rose
|>
|
| Re: Copying text from one field to another in same record |
|
Author: STANLEY: Dr Philip
Posted: Fri, 9 Mar 2001 18:20:47 -0000
|
Date: Fri, 9 Mar 2001 18:20:47 -0000
Reply-To: PROCITE The Personal Bibliographic Software Discussion List
Sender: PROCITE The Personal Bibliographic Software Discussion List
From: "STANLEY: Dr Philip"
Subject: Re: Copying text from one field to another in same record
In-Reply-To:
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Yes, certainly Output Styles does retain/permits insertion of attributes.
However import into ProCite looses attributes and there is no global edit
with enables their re-insertion by say Find & Replace.
********************************************************************
Dr Philip STANLEY
Email:
Web site: http://www.lumiweb.com
Tel: +44 1223-460888
FAX: +44 1223-461777
Cambridge Research & Technology Transfer Ltd
48 Glisson Road
Cambridge CB1 2HF
England
********************************************************************
|-----Original Message-----
|From: PROCITE The Personal Bibliographic Software Discussion List
Behalf Of Leon Zimlich
|Sent: 09 March 2001 17:34
|To:
|Subject: Re: Copying text from one field to another in same record
|
|
|Am I mistaken in thinking that ProCite's Output Styles contain the
|"tags" for text attributes such as bold and italic? If this text
|formatting is lost through the Export/Import via Excel procedure
|would it be regained via ProCite's bibliography output features?
|Or, might it be recovered through Global editing?
|
|Best wishes,
|
|Leon E. Zimlich
|History of Art and Architecture
|University of California Santa Barbara
|
Previous by date: Re: Database conversion, Roger J Cooper
Next by date: Re: Copying text from one field to another in same record, Dirk Enneking
Previous thread: NEW Z39.50 Indiana University Library connection information, Mark Tyler Day
Next thread: Copying text from one field to another in same record, STANLEY: Dr Philip
|
|
|
RSS Feeds
collection