This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
public:nnels:etext:regex [2017/11/02 18:46] farrah.little |
public:nnels:etext:regex [2024/05/29 18:37] rachel.osolen |
||
---|---|---|---|
Line 2: | Line 2: | ||
Regular expressions (aka regex) is useful for replacing patterns of text, such as headers/ | Regular expressions (aka regex) is useful for replacing patterns of text, such as headers/ | ||
- | ====Tips==== | + | With regex, you can define patterns of text in a number of different ways, but the most commonly used ones for our purposes are **Ranges** and **Groups**. For more information about others, you can take a look at [[https://wordmvp.com/FAQs/General/UsingWildcards.htm|this helpful webpage]]: |
- | + | * Ranges | |
- | [[https://support.office.com/en-ca/article/Find-and-replace-text-and-other-data-in-your-Word-2010-files-c6728c16-469e-43cd-afe4-7708c6c779b7? | + | * Square brackets are always used in pairs and are used to identify //specific characters// |
+ | * [A-Z] will find any upper case letter; | ||
+ | * [a-z] will find any lower case letter; | ||
+ | * [A-z] will find any letter (upper or lower case); | ||
+ | * [0-9] will find any number | ||
+ | * [abc] will find any of the letters a, b, or c. | ||
+ | * [F] will find upper case “F” | ||
+ | * [Fred] will find " | ||
+ | * Groups | ||
+ | * Round brackets are used in pairs to enclose //groups//. For example: | ||
+ | * '' | ||
+ | * They must be used in pairs and are addressed by number in the replacement. In the replace field, \1 represents the first group, \2 represents the second group, and so on. For example: | ||
+ | * If you wanted to remove the hyphen from " | ||
+ | * Another example: '' | ||
- | * Word has a lot of options to find letters (^$) and numbers (^#) but these only work with the wildcard option //off// (which it is by default). Only turn the wildcard option on if you're using regex options. Read the info page carefully on when things apply with the wildcard option on/off. | + | <note tip>Word has a lot of options to find letters (^$) and numbers (^#) when using the non-regex [[public: |
+ | </ | ||
+ | |||
+ | <note tip>A lot of the codes for special characters (e.g. page break) are under the " | ||
+ | </ | ||
- | * A lot of the codes for special characters (e.g. page break) are under the " | + | < |
- | {{: | + | |
- | ==== In LibreOffice & OpenOffice ==== | + | |
- | Make sure that the '' | + | |
- | [[https:// | + | =====Problems and Solutions Using Regular Expressions===== |
- | [[https:// | + | |
- | ===== Conversion Fixes ===== | + | In this section |
- | The following fixes assume | + | |
- | < | + | < |
---- | ---- | ||
+ | <WRAP center round box 80%> | ||
**PROBLEM**: | **PROBLEM**: | ||
- | **SOLUTION**: | + | **SOLUTION**: |
In Word, this will only work with wildcards turned on. | In Word, this will only work with wildcards turned on. | ||
Line 33: | Line 46: | ||
Replace with: '' | Replace with: '' | ||
- | This looks for the pattern: any-letter space paragraph-break any-letter | + | This looks for the pattern: |
The parentheses are used to group what it finds, so \1 refers to the first " | The parentheses are used to group what it finds, so \1 refers to the first " | ||
In this way, you are putting back exactly what it found minus the paragraph break. | In this way, you are putting back exactly what it found minus the paragraph break. | ||
+ | </ | ||
---- | ---- | ||
+ | <WRAP center round box 80%> | ||
**PROBLEM**: | **PROBLEM**: | ||
Line 52: | Line 67: | ||
You will likely have to do it again for lines that end with a comma, and possibly en and em dash. Look through your document for patterns of anything else it might have missed. | You will likely have to do it again for lines that end with a comma, and possibly en and em dash. Look through your document for patterns of anything else it might have missed. | ||
+ | </ | ||
---- | ---- | ||
- | **PROBLEM**: | + | <WRAP center round box 80%> |
+ | **PROBLEM**: | ||
- | **SOLUTION**: | + | **SOLUTION**: |
- | Find: '' | + | Find: '' |
- | Replace with: '' | + | Replace with: '' |
+ | |||
+ | Using a-z restricts what it finds to lowercase. | ||
+ | |||
+ | You will likely have to do it again for lines that end with a comma, and possibly en and em dash. Look through your document for patterns of anything else it might have missed. | ||
+ | </ | ||
---- | ---- | ||
- | **PROBLEM**: There are newlines/line breaks (↵) instead of paragraph marks (¶). | + | <WRAP center round box 80%> |
+ | **PROBLEM:** OCR converted some " | ||
- | **SOLUTION**: Find and remove all line breaks and replace with a single paragraph break. | + | **SOLUTION:** Replace " |
- | Find: '' | + | - |
+ | - Find: '' | ||
+ | - Replace: '' | ||
+ | - | ||
+ | - Find: '' | ||
+ | - Replace: '' | ||
+ | </ | ||
- | Replace with: '' | + | ---- |
- | In LibreOffice, | ||
- | **PROBLEM**: | + | <WRAP center round box 80%> |
- | '' | + | |
- | **SOLUTION**: Without using wildcards: | + | **PROBLEM:** OCR did not recognize spaces around quotation marks. |
+ | * Example A: As one of Montgomery' | ||
+ | * Example B: The "nasty little '' | ||
+ | This problem has an added complexity; the pattern has two different solutions: | ||
+ | * Example A will need to say: ... later put '' | ||
+ | * Example B will need to say: The "nasty little troublemaker''," | ||
- | Find: '' | + | **SOLUTIONS:** |
+ | Example A:\\ | ||
- | Replace with: nothing. If you're doing a paginated title, replace with page breaks. | + | Find: ''([,])([" |
+ | Replace: '' | ||
- | You will need to remove one of the ^# at the beginning and after the .indd to remove it for 2 digit page numbers, and one last time for single digit page numbers. The following screenshot is an example with a 1-digit page number (see below), followed by the command used to isolate all such instances. | + | Example B: |
- | <WRAP center round box 60%> | + | Find: '' |
+ | Replace: '' | ||
- | {{:nnels: | + | Notes: |
+ | * You will **not** be able to use " | ||
+ | * You will also need to re-do this, searching for periods instead of commas. | ||
- | Find: ^# | ||
</ | </ | ||
- | You will also need to do it with the leading ^#^p to catch the footer text that do not have any page numbers | + | ---- |
+ | |||
+ | |||
+ | <WRAP center round box 80%> | ||
+ | **PROBLEM**: | ||
+ | |||
+ | **SOLUTION**: | ||
+ | </ | ||
+ | |||
+ | ---- | ||
+ | |||
+ | <WRAP center round box 80%> | ||
+ | **PROBLEM**: | ||
+ | |||
+ | **SOLUTION**: | ||
+ | </ | ||
+ | |||
+ | ---- | ||
+ | |||
+ | <WRAP center round box 80%> | ||
+ | **PROBLEM**: | ||
+ | '' | ||
+ | |||
+ | **SOLUTION**: | ||
+ | </ | ||
In LibreOffice: | In LibreOffice: | ||
Line 108: | Line 168: | ||
* '' | * '' | ||
* '' | * '' | ||
+ | |||
+ | |||
+ | [[public: | ||