MARCEDIT-L Archives

November 2023

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Glass, Joe" <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Wed, 29 Nov 2023 20:14:15 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (1 lines)
regex101.com is a handy site for testing regular expressions -- for working with regex in MarcEdit, select .NET (C#) under the "FLAVOR" menu.

-----Original Message-----
From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of MARCEDIT-L automatic digest system
Sent: Wednesday, November 29, 2023 12:02 AM
To: [log in to unmask]
Subject: MARCEDIT-L Digest - 27 Nov 2023 to 28 Nov 2023 (#2023-172)

*** CAUTION: This email originated from outside of NDC. Do not click or open attachments unless you recognize the sender and know the content is safe. ***

There are 8 messages totaling 6469 lines in this issue.

Topics of the day:

  1. Replacing Final Comma in 100$a (5)
  2. Convert to UTF-8 automation? (3)

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

----------------------------------------------------------------------

Date:    Tue, 28 Nov 2023 20:41:32 +0000
From:    "Williams, Peter" <[log in to unmask]>
Subject: Replacing Final Comma in 100$a

Hello,

I deleted 100$e and want to replace the final comma in 100$a with a period.

Is there a way to replace this final comma without replacing the comma between the last and first name?

Take care,

Peter Williams


----------------------------

[SERC Logo]<http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377
Direct Phone:   (860) 740-4268


http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org<http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org>

We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------


________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGN

------------------------------

Date:    Tue, 28 Nov 2023 15:48:02 -0500
From:    Terry Reese <[log in to unmask]>
Subject: Re: Replacing Final Comma in 100$a

I’m going to assume that there is an addition subfield following the $a.  If so, then you could use an regular expression in the replace function that looks like this:



Find: (=100.*\$a[^$]*)(,)(\$.*)

Replace: $1.$3



If this potentially is at the end of the field or may have a subfield following it, then you could use this:



Find: (=100.*\$a[^$]*)(,)(\$*|.*$)

Replace: $1.$3







--tr



From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of Williams, Peter
Sent: Tuesday, November 28, 2023 3:42 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] Replacing Final Comma in 100$a



Hello,



I deleted 100$e and want to replace the final comma in 100$a with a period.



Is there a way to replace this final comma without replacing the comma between the last and first name?



Take care,



Peter Williams



----------------------------

 <http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377


Direct Phone:

(860) 740-4268



 <http://secure-web.cisco.com/1RtgUEfQScpSN-Oc1KnblfxZ2-C8QDO9eOOtPcL4-7MZ81CB4UMXq6kcW_TcNo2ej3EyFBKab5Ql_wKbtDN4s-AoWbG2OCJI2yN400qW7S77faW8Y-M66u4wxecfgoP-gP3qicMs4vnNJgB84bxU3gjBgJAwDs1-lcuwLKU8fuz_3iqS7v3cWO37ld3cRBb6eyVIgRYPBaCRnPbP2-EJ7H93DfuiqEve-elLscNq1A60AoaR1b92zAo4H2KVwIW7_6ckeFt1DyJo2UNsm-gH905k5K6RFtWgXVS6cE7Ra-ZC3_26ci2lCysKyfO2rrygLZ2q8352YqFf2uNTPKMX88SK4ykcue5M8YCJryORJXittgNQueE5jsKjPxh_o6PcNT3e0wPOsycuTbsIPZNEfoZ1NESYOT_GGXag1AgswRb7GN0q_c5LnuCnRf2s7FdxZ/http%3A%2F%2Fwww.ctserc.org> http://secure-web.cisco.com/1RtgUEfQScpSN-Oc1KnblfxZ2-C8QDO9eOOtPcL4-7MZ81CB4UMXq6kcW_TcNo2ej3EyFBKab5Ql_wKbtDN4s-AoWbG2OCJI2yN400qW7S77faW8Y-M66u4wxecfgoP-gP3qicMs4vnNJgB84bxU3gjBgJAwDs1-lcuwLKU8fuz_3iqS7v3cWO37ld3cRBb6eyVIgRYPBaCRnPbP2-EJ7H93DfuiqEve-elLscNq1A60AoaR1b92zAo4H2KVwIW7_6ckeFt1DyJo2UNsm-gH905k5K6RFtWgXVS6cE7Ra-ZC3_26ci2lCysKyfO2rrygLZ2q8352YqFf2uNTPKMX88SK4ykcue5M8YCJryORJXittgNQueE5jsKjPxh_o6PcNT3e0wPOsycuTbsIPZNEfoZ1NESYOT_GGXag1AgswRb7GN0q_c5LnuCnRf2s7FdxZ/http%3A%2F%2Fwww.ctserc.org



We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------

________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] <mailto:[log in to unmask]> . To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask] <mailto:[log in to unmask]> .


________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

------------------------------

Date:    Tue, 28 Nov 2023 20:56:31 +0000
From:    "Williams, Peter" <[log in to unmask]>
Subject: Re: Replacing Final Comma in 100$a

I will definitely give this a try!

I am still learning MarcEdit and am not familiar with regular expressions. Is there a resource where I could learn more about them?


----------------------------

[SERC Logo]<http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377
Direct Phone:   (860) 740-4268


http://secure-web.cisco.com/11QyL6ufwqI0yX1M7dH4AVWZTltRIVrfq3HvM9L1vfrAH-CsPXb7HiNzDyUl4lqHdp-FcsOOxTMWBqPXAuWeOQs68G3Ff7_yn_47eE1SRmNuo33O_7CWuAGXqcXCXItYvxt3q1lZDcWcC4RsmzQu9TUAopRTVbfUKCSnkAZErA6akgntOzYhLAHbKPfY2rj30iPcjhWE15n72b2G8C-BAczHLJfa5v_5_aRgffNjbQnBejXZtNl61pfST6KvxR_tVEIvrXq3DLaaXvLRL_a46PVlh5lj31A5izwHURmHDKEH4T_IrcIYtYCU-dk_E3g4MjFbkivaYUQRV6zzlD0TPOm57zH63jserkrtrCPJxN6X04FpdzdaSTnBNJFpzTv0cP_gaRrEkt4J1DzrGrMzmublz_YxtovR17ydlzSAvJWXjCrZ6Zl-jDGV1zqzJp73X/http%3A%2F%2Fwww.ctserc.org<http://secure-web.cisco.com/11QyL6ufwqI0yX1M7dH4AVWZTltRIVrfq3HvM9L1vfrAH-CsPXb7HiNzDyUl4lqHdp-FcsOOxTMWBqPXAuWeOQs68G3Ff7_yn_47eE1SRmNuo33O_7CWuAGXqcXCXItYvxt3q1lZDcWcC4RsmzQu9TUAopRTVbfUKCSnkAZErA6akgntOzYhLAHbKPfY2rj30iPcjhWE15n72b2G8C-BAczHLJfa5v_5_aRgffNjbQnBejXZtNl61pfST6KvxR_tVEIvrXq3DLaaXvLRL_a46PVlh5lj31A5izwHURmHDKEH4T_IrcIYtYCU-dk_E3g4MjFbkivaYUQRV6zzlD0TPOm57zH63jserkrtrCPJxN6X04FpdzdaSTnBNJFpzTv0cP_gaRrEkt4J1DzrGrMzmublz_YxtovR17ydlzSAvJWXjCrZ6Zl-jDGV1zqzJp73X/http%3A%2F%2Fwww.ctserc.org>

We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------

From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of Terry Reese
Sent: Tuesday, November 28, 2023 3:48 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] Replacing Final Comma in 100$a

I’m going to assume that there is an addition subfield following the $a.  If so, then you could use an regular expression in the replace function that looks like this:

Find: (=100.*\$a[^$]*)(,)(\$.*)
Replace: $1.$3

If this potentially is at the end of the field or may have a subfield following it, then you could use this:

Find: (=100.*\$a[^$]*)(,)(\$*|.*$)
Replace: $1.$3

[cid:image002.png@01DA2213.73C11E50]

--tr

From: MarcEdit support in technical and instructional matters <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Williams, Peter
Sent: Tuesday, November 28, 2023 3:42 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: [MARCEDIT-L] Replacing Final Comma in 100$a

Hello,

I deleted 100$e and want to replace the final comma in 100$a with a period.

Is there a way to replace this final comma without replacing the comma between the last and first name?

Take care,

Peter Williams


----------------------------

[SERC Logo]<http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377
Direct Phone:

(860) 740-4268



http://secure-web.cisco.com/11QyL6ufwqI0yX1M7dH4AVWZTltRIVrfq3HvM9L1vfrAH-CsPXb7HiNzDyUl4lqHdp-FcsOOxTMWBqPXAuWeOQs68G3Ff7_yn_47eE1SRmNuo33O_7CWuAGXqcXCXItYvxt3q1lZDcWcC4RsmzQu9TUAopRTVbfUKCSnkAZErA6akgntOzYhLAHbKPfY2rj30iPcjhWE15n72b2G8C-BAczHLJfa5v_5_aRgffNjbQnBejXZtNl61pfST6KvxR_tVEIvrXq3DLaaXvLRL_a46PVlh5lj31A5izwHURmHDKEH4T_IrcIYtYCU-dk_E3g4MjFbkivaYUQRV6zzlD0TPOm57zH63jserkrtrCPJxN6X04FpdzdaSTnBNJFpzTv0cP_gaRrEkt4J1DzrGrMzmublz_YxtovR17ydlzSAvJWXjCrZ6Zl-jDGV1zqzJp73X/http%3A%2F%2Fwww.ctserc.org<http://secure-web.cisco.com/1RtgUEfQScpSN-Oc1KnblfxZ2-C8QDO9eOOtPcL4-7MZ81CB4UMXq6kcW_TcNo2ej3EyFBKab5Ql_wKbtDN4s-AoWbG2OCJI2yN400qW7S77faW8Y-M66u4wxecfgoP-gP3qicMs4vnNJgB84bxU3gjBgJAwDs1-lcuwLKU8fuz_3iqS7v3cWO37ld3cRBb6eyVIgRYPBaCRnPbP2-EJ7H93DfuiqEve-elLscNq1A60AoaR1b92zAo4H2KVwIW7_6ckeFt1DyJo2UNsm-gH905k5K6RFtWgXVS6cE7Ra-ZC3_26ci2lCysKyfO2rrygLZ2q8352YqFf2uNTPKMX88SK4ykcue5M8YCJryORJXittgNQueE5jsKjPxh_o6PcNT3e0wPOsycuTbsIPZNEfoZ1NESYOT_GGXag1AgswRb7GN0q_c5LnuCnRf2s7FdxZ/http%3A%2F%2Fwww.ctserc.org>
We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------
________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask]<mailto:[log in to unmask]>. To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]<mailto:[log in to unmask]>.
________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask]<mailto:[log in to unmask]>. To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]<mailto:[log in to unmask]>.

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "

------------------------------

Date:    Tue, 28 Nov 2023 16:09:51 -0500
From:    Terry Reese <[log in to unmask]>
Subject: Re: Replacing Final Comma in 100$a

MarcEdit’s regular expression engine is the one found in .NET.  So, this is the language reference:

Regular Expression Language - Quick Reference - .NET | Microsoft Learn <https://learn.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference>



And this an online tool that allows you to test expressions:

.NET Regex Tester - Regex Storm <http://secure-web.cisco.com/1Yf2-K9iY1WPfabsF2cX_QIHCTml9AjxeP7mxVUGuPRG6Jyx04hW3BfKHecAIR9M983m8MdrlgcsaGeIFcNLd3g-mHXfolWSiUDaOka1OufT1X73dy14bBytaO1y68wTsViOvHOqVjNbiXOvCrptFYM42dUB3Ygz3htiSuTgXzc-1z5LvI6IY_sMBIii8Pvorm1QL9qJ8H7fOXgLP1FdV519GrSYlOGlwvB8x46MSIfUTI-_lIc36puRmn586IeDRZFB79-y82wA411KcMePKzZjNf3czW8AEOHhK8ealw9aI2GKp5-zdGRKZAjxCv-dKNvdesJmWfM1X7zqRikvXW53OepOEJjiav9Uam3Izkm9RmrPc0_RjEmmSystIef-7TndHNzxUhHQNL5BxgRVlI-0macRYHl4P89x56TpiYRaYrhPGAIRpA-kKDu7ybgkZ/http%3A%2F%2Fregexstorm.net%2Ftester>



--tr



From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of Williams, Peter
Sent: Tuesday, November 28, 2023 3:57 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] Replacing Final Comma in 100$a



I will definitely give this a try!



I am still learning MarcEdit and am not familiar with regular expressions. Is there a resource where I could learn more about them?



----------------------------

 <http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377


Direct Phone:

(860) 740-4268



 <http://secure-web.cisco.com/11QyL6ufwqI0yX1M7dH4AVWZTltRIVrfq3HvM9L1vfrAH-CsPXb7HiNzDyUl4lqHdp-FcsOOxTMWBqPXAuWeOQs68G3Ff7_yn_47eE1SRmNuo33O_7CWuAGXqcXCXItYvxt3q1lZDcWcC4RsmzQu9TUAopRTVbfUKCSnkAZErA6akgntOzYhLAHbKPfY2rj30iPcjhWE15n72b2G8C-BAczHLJfa5v_5_aRgffNjbQnBejXZtNl61pfST6KvxR_tVEIvrXq3DLaaXvLRL_a46PVlh5lj31A5izwHURmHDKEH4T_IrcIYtYCU-dk_E3g4MjFbkivaYUQRV6zzlD0TPOm57zH63jserkrtrCPJxN6X04FpdzdaSTnBNJFpzTv0cP_gaRrEkt4J1DzrGrMzmublz_YxtovR17ydlzSAvJWXjCrZ6Zl-jDGV1zqzJp73X/http%3A%2F%2Fwww.ctserc.org> http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org



We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------

From: MarcEdit support in technical and instructional matters <[log in to unmask] <mailto:[log in to unmask]> > On Behalf Of Terry Reese
Sent: Tuesday, November 28, 2023 3:48 PM
To: [log in to unmask] <mailto:[log in to unmask]>
Subject: Re: [MARCEDIT-L] Replacing Final Comma in 100$a



I’m going to assume that there is an addition subfield following the $a.  If so, then you could use an regular expression in the replace function that looks like this:



Find: (=100.*\$a[^$]*)(,)(\$.*)

Replace: $1.$3



If this potentially is at the end of the field or may have a subfield following it, then you could use this:



Find: (=100.*\$a[^$]*)(,)(\$*|.*$)

Replace: $1.$3







--tr



From: MarcEdit support in technical and instructional matters <[log in to unmask] <mailto:[log in to unmask]> > On Behalf Of Williams, Peter
Sent: Tuesday, November 28, 2023 3:42 PM
To: [log in to unmask] <mailto:[log in to unmask]>
Subject: [MARCEDIT-L] Replacing Final Comma in 100$a



Hello,



I deleted 100$e and want to replace the final comma in 100$a with a period.



Is there a way to replace this final comma without replacing the comma between the last and first name?



Take care,



Peter Williams



----------------------------

 <http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377


Direct Phone:

(860) 740-4268



 <http://secure-web.cisco.com/1RtgUEfQScpSN-Oc1KnblfxZ2-C8QDO9eOOtPcL4-7MZ81CB4UMXq6kcW_TcNo2ej3EyFBKab5Ql_wKbtDN4s-AoWbG2OCJI2yN400qW7S77faW8Y-M66u4wxecfgoP-gP3qicMs4vnNJgB84bxU3gjBgJAwDs1-lcuwLKU8fuz_3iqS7v3cWO37ld3cRBb6eyVIgRYPBaCRnPbP2-EJ7H93DfuiqEve-elLscNq1A60AoaR1b92zAo4H2KVwIW7_6ckeFt1DyJo2UNsm-gH905k5K6RFtWgXVS6cE7Ra-ZC3_26ci2lCysKyfO2rrygLZ2q8352YqFf2uNTPKMX88SK4ykcue5M8YCJryORJXittgNQueE5jsKjPxh_o6PcNT3e0wPOsycuTbsIPZNEfoZ1NESYOT_GGXag1AgswRb7GN0q_c5LnuCnRf2s7FdxZ/http%3A%2F%2Fwww.ctserc.org> http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org

We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------

________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] <mailto:[log in to unmask]> . To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask] <mailto:[log in to unmask]> .

________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] <mailto:[log in to unmask]> . To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask] <mailto:[log in to unmask]> .

________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] <mailto:[log in to unmask]> . To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask] <mailto:[log in to unmask]> .


________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

------------------------------

Date:    Tue, 28 Nov 2023 21:12:48 +0000
From:    "Williams, Peter" <[log in to unmask]>
Subject: Re: Replacing Final Comma in 100$a

Excellent. Thank you for your help!



----------------------------

[SERC Logo]<http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377
Direct Phone:   (860) 740-4268


http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org<http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org>

We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------

From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of Terry Reese
Sent: Tuesday, November 28, 2023 4:10 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] Replacing Final Comma in 100$a

MarcEdit’s regular expression engine is the one found in .NET.  So, this is the language reference:
Regular Expression Language - Quick Reference - .NET | Microsoft Learn<https://learn.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference>

And this an online tool that allows you to test expressions:
.NET Regex Tester - Regex Storm<https://secure-web.cisco.com/1u2LsFJHlcMiK6LO3Hh_7e9pz7O5-EJszXV1XyZVqTruwRJtzcCMt8AlK6qZI2mkG0KcmMWvFfU5mfTl_C6mFYLX7Ru0S088QETR-tGrIHGrg9tw8IyMJEqdPhlTnWl5N3Aa1lU5o_EcCKlkZRVGzfyCDOTe2WHg0WIuYSpFvOMgp4b3YfPWA7K1K3hhDHbA0IdJdWJYUiOlwCqTVVk8tEotTId3f25w2otXqUaWgX2MR7CthaDUg-l8LBf-E2I95rqU8t6GKjRD72LzTHRfOvCcxuHAOGG9oKyjzln4AlbWbzb4kQQTAWSWMIWIvLXu8-ART4DfBC6GV3FkqQqDks9qzrJmJ7FQ1x7TPZc3kLlVyCbx9d0jM8OgVUow3Gpit674SEVYyAZkH4RKE4Mn5TMnJ_yleHNYPIEeiWenLdI624H4KK_mEDWOWNp-Tz6Uq/https%3A%2F%2Flinkprotect.cudasvc.com%2Furl%3Fa%3Dhttp%253a%252f%252fregexstorm.net%252ftester%26c%3DE%2C1%2CHqRMsnE5Yb9vsye4Sn5k3BdOahhj7KpzwdCIVAKI094DYz0iPzAFmM318uFpPPomAao6civWMR3Jd0TR4XLDYuY5x8EbYlMG9fkSewqdNDEdnOy0coSMYY7-ig%2C%2C%26typo%3D1>

--tr

From: MarcEdit support in technical and instructional matters <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Williams, Peter
Sent: Tuesday, November 28, 2023 3:57 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: [MARCEDIT-L] Replacing Final Comma in 100$a

I will definitely give this a try!

I am still learning MarcEdit and am not familiar with regular expressions. Is there a resource where I could learn more about them?


----------------------------

[SERC Logo]<http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377
Direct Phone:

(860) 740-4268



http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org<http://secure-web.cisco.com/11QyL6ufwqI0yX1M7dH4AVWZTltRIVrfq3HvM9L1vfrAH-CsPXb7HiNzDyUl4lqHdp-FcsOOxTMWBqPXAuWeOQs68G3Ff7_yn_47eE1SRmNuo33O_7CWuAGXqcXCXItYvxt3q1lZDcWcC4RsmzQu9TUAopRTVbfUKCSnkAZErA6akgntOzYhLAHbKPfY2rj30iPcjhWE15n72b2G8C-BAczHLJfa5v_5_aRgffNjbQnBejXZtNl61pfST6KvxR_tVEIvrXq3DLaaXvLRL_a46PVlh5lj31A5izwHURmHDKEH4T_IrcIYtYCU-dk_E3g4MjFbkivaYUQRV6zzlD0TPOm57zH63jserkrtrCPJxN6X04FpdzdaSTnBNJFpzTv0cP_gaRrEkt4J1DzrGrMzmublz_YxtovR17ydlzSAvJWXjCrZ6Zl-jDGV1zqzJp73X/http%3A%2F%2Fwww.ctserc.org>
We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------
From: MarcEdit support in technical and instructional matters <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Terry Reese
Sent: Tuesday, November 28, 2023 3:48 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: [MARCEDIT-L] Replacing Final Comma in 100$a

I’m going to assume that there is an addition subfield following the $a.  If so, then you could use an regular expression in the replace function that looks like this:

Find: (=100.*\$a[^$]*)(,)(\$.*)
Replace: $1.$3

If this potentially is at the end of the field or may have a subfield following it, then you could use this:

Find: (=100.*\$a[^$]*)(,)(\$*|.*$)
Replace: $1.$3

[cid:image002.png@01DA2215.B98E4FA0]

--tr

From: MarcEdit support in technical and instructional matters <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Williams, Peter
Sent: Tuesday, November 28, 2023 3:42 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: [MARCEDIT-L] Replacing Final Comma in 100$a

Hello,

I deleted 100$e and want to replace the final comma in 100$a with a period.

Is there a way to replace this final comma without replacing the comma between the last and first name?

Take care,

Peter Williams


----------------------------

[SERC Logo]<http://>


Peter Williams
Librarian
State Education Resource Center
Main Telephone: (860) 632-1485 x377
Direct Phone:

(860) 740-4268



http://secure-web.cisco.com/1O-FRNxROru__SOQ1oEfLh6rQO7syA-V3l4q9Nnx671iyYWzGAdwxgV2mm05tTvyeV6igrcPo7XwwIhJYcy9XboaLMhrGqfsBhSNhQPRA5LXb9ZYk3MM0dmWpv5G5sdAL5AjRw373tTqMYDAPh0RcL9gc6tvRYRV1m_A6qWqA85m__W86W0y8ehs0wDTgun5I4Fq90gogX_naC6HA3BVcKbzU9OOn2Xjz6_l9SSOzNNjt2Om57Xrblo7JS0ksHnHL-qE5D1UVoZTZbKCnvKyTkeDYIMIclh3eBer-TVITyyybuDgbvss7hbX0K42U0wuuyR7U-MO4RAVKPheCso2ioDnWdkoyrmGJhY6m4n3ui2SHmDspkYDPRNcJktXr0A7vDUpqfdH2lLGwW1nFdLnHvz4OHksu9d2wFWfg5VaGO3jPKbdMzNGkSQmXPbKsH5SU/http%3A%2F%2Fwww.ctserc.org<http://secure-web.cisco.com/1RtgUEfQScpSN-Oc1KnblfxZ2-C8QDO9eOOtPcL4-7MZ81CB4UMXq6kcW_TcNo2ej3EyFBKab5Ql_wKbtDN4s-AoWbG2OCJI2yN400qW7S77faW8Y-M66u4wxecfgoP-gP3qicMs4vnNJgB84bxU3gjBgJAwDs1-lcuwLKU8fuz_3iqS7v3cWO37ld3cRBb6eyVIgRYPBaCRnPbP2-EJ7H93DfuiqEve-elLscNq1A60AoaR1b92zAo4H2KVwIW7_6ckeFt1DyJo2UNsm-gH905k5K6RFtWgXVS6cE7Ra-ZC3_26ci2lCysKyfO2rrygLZ2q8352YqFf2uNTPKMX88SK4ykcue5M8YCJryORJXittgNQueE5jsKjPxh_o6PcNT3e0wPOsycuTbsIPZNEfoZ1NESYOT_GGXag1AgswRb7GN0q_c5LnuCnRf2s7FdxZ/http%3A%2F%2Fwww.ctserc.org>
We've Moved!
SERC’s Administrative Offices and Library will now be located at
175 Union St, Waterbury, CT 06706
Please visit our website for updated information regarding hours of operation.

----------------------------
________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask]<mailto:[log in to unmask]>. To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]<mailto:[log in to unmask]>.
________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask]<mailto:[log in to unmask]>. To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]<mailto:[log in to unmask]>.
________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask]<mailto:[log in to unmask]>. To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]<mailto:[log in to unmask]>.
________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask]<mailto:[log in to unmask]>. To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]<mailto:[log in to unmask]>.

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to list

------------------------------

Date:    Tue, 28 Nov 2023 22:04:09 +0000
From:    Tamarack Hockin <[log in to unmask]>
Subject: Convert to UTF-8 automation?

Hello all, We receive MARC files from one vendor as MARC8 (indicated by special characters in curly braces, such as {copy} or {acute}e).  Is there any way to convert these without MarcBreaker?

Running the files through MarcBreaker is an extra pre-processing step that takes time, and I would love to, for example, have it as part of an assigned task that runs in the editor. (For other files, our cataloguer is able to just run an assigned task, so these MARC8 files are a friction point in the workflow). While I'm pursuing the vendor side (i.e., send us UTF-8 records!), are there any quicker processing options I may be missing?

Many thanks in advance,

Tamarack Hockin

Metadata Strategies Librarian | Contact + about me<https://library.capilanou.ca/about-the-library/library-team/tamarack-hockin/>

Liaison for School of STEM | Liaison for School of Access and Academic Preparation


Capilano University is named after Chief Joe Capilano, an important leader of the Skwxwú7mesh (Squamish) Nation of the Coast Salish Peoples. We respectfully acknowledge that our campuses are located on the territories of the LíỈwat, xʷməθkʷəỷəm (Musqueam), shíshálh (Sechelt), Skwxwú7mesh (Squamish) and SəỈílwətaʔ/Selilwitulh (Tsleil-Waututh) Nations.


________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

------------------------------

Date:    Tue, 28 Nov 2023 17:19:25 -0500
From:    Terry Reese <[log in to unmask]>
Subject: Re: Convert to UTF-8 automation?

No, this isn’t something you can replace in a task.  This is due to the large number of diacritics the tool has to process when handling the data (and the fact that you’d lose the data if printed into the editor while it is reading data as UTF8).



You could, however, not have to convert the data UTF8 via the marcbreaker – but save the file as UTF8 when completed.  When compiling the data to MARC, select the UTF8 option in the dropdown list.  The program will assume the data is MARC8 or a mixture of MARC8 and utf8.







--tr



From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of Tamarack Hockin
Sent: Tuesday, November 28, 2023 5:04 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] Convert to UTF-8 automation?



Hello all, We receive MARC files from one vendor as MARC8 (indicated by special characters in curly braces, such as {copy} or {acute}e).  Is there any way to convert these without MarcBreaker?



Running the files through MarcBreaker is an extra pre-processing step that takes time, and I would love to, for example, have it as part of an assigned task that runs in the editor. (For other files, our cataloguer is able to just run an assigned task, so these MARC8 files are a friction point in the workflow). While I'm pursuing the vendor side (i.e., send us UTF-8 records!), are there any quicker processing options I may be missing?



Many thanks in advance,

Tamarack Hockin

Metadata Strategies Librarian |  <https://library.capilanou.ca/about-the-library/library-team/tamarack-hockin/> Contact + about me

Liaison for School of STEM | Liaison for School of Access and Academic Preparation



Capilano University is named after Chief Joe Capilano, an important leader of the Skwxwú7mesh (Squamish) Nation of the Coast Salish Peoples. We respectfully acknowledge that our campuses are located on the territories of the LíỈwat, xʷməθkʷəỷəm (Musqueam), shíshálh (Sechelt), Skwxwú7mesh (Squamish) and SəỈílwətaʔ/Selilwitulh (Tsleil-Waututh) Nations.



________________________________________________________________________ This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] <mailto:[log in to unmask]> . To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask] <mailto:[log in to unmask]> .


________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

------------------------------

Date:    Tue, 28 Nov 2023 17:30:15 -0500
From:    Tamarack Hockin <[log in to unmask]>
Subject: Re: Convert to UTF-8 automation?

Terry, thank you so much for highlighting the dropdown option for UTF-8 mrc! This is the time-saving step I was hoping for. My cataloguer likewise thanks you enormously :)

-Tamarack

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

------------------------------

End of MARCEDIT-L Digest - 27 Nov 2023 to 28 Nov 2023 (#2023-172)
*****************************************************************

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

ATOM RSS1 RSS2