" Many users access the OPAC on their phones, so I was trying to make records as clean and clutter-free as possible with concise and uniform lines. I wanted "pages" to show as "p." and "illustrations" as "ill.". Any assistance you provide would be welcomed and appreciated. "
Before making any changes to your data, please follow these steps:
When analyzing the text, consider if it is part of a longer word. For example, the word "page" appears in "unpaged."
You can review the content of the field using the Advanced Search feature.
You have two options for applying global changes: you can use the REPLACE function or the Run SQL feature.
Before you execute the Replace function, it's advisable to perform an Advanced Search to see where the substring occurs.
Performing an Advanced Search before the replacement operation can reduce the time needed for the replacement.
REPLACE
The Replace function reviews each record and replaces "illustrations" with "ill." Depending on your computer's speed, this process may take one minute or longer.
Note: To ensure that only whole words are replaced and not parts of words, you can add a space before and/or after the text
(e.g., " illustrations").
RUN SQL
You can make global changes in SQL using the UPDATE and REPLACE functions.
The REPLACE() function substitutes a specified substring within a string with another substring. Typically, the SQL REPLACE() function modifies all occurrences of the specified substring within a given table. Text manipulation is crucial in SQL as it helps cleanse your library data for more efficient representation.
To replace the word "illustrations" with "ill.," use the following SQL statement in the Execute SQL box:
UPDATE LIBRARY SET PHYSICAL = REPLACE(PHYSICAL, 'illustrations', 'ill.');
LIBRARY: The name of the table being updated.
PHYSICAL: The name of the field being updated.
REPLACE: The SQL function used to perform the replacement.
To replace the word "pages" with "p.," use the following SQL statement in the Execute SQL box:
UPDATE LIBRARY SET PHYSICAL = REPLACE(PHYSICAL, 'pages', 'p.');
This will effectively update the specified words in the PHYSICAL field of the LIBRARY table.
Handy Library Manager 4.4, review new features
Labels Printing Software for Windows
Library Web Search, review new web search
Library Search 4.0, review new desktop search
Getting started library video lessons
How to include library name on labels
Library, Data Entry Form Designer
Edit item or borrower data in the check-in/check-out window?
Link item lost fine with the PRICE data field?
Handy v3.2 supports letter tabs?
How to predefine library email messages?
How to update library data from the web with ISBN?
How to predefine library email messages?
Compilation of questions and answers from library requests will help you to make purchase decision.
How to verify if the item is checked out in the library main catalog window?
How to create a new record using Copy Selected Item?
Special Library, how to manage digital and paper document library?
What is the maximum number of library items?
Library Software for Small Libraries, Windows application
Handy Library Manager
small library software
library tour
library features
try now, download
cloud
library software reviews
Copyright © 2024 · All Rights Reserved · PrimaSoft PC