August 2022 - NOTE - all tasks listed below can now be handled by the BAT file at
–
Open DATA.TXT and replace the following characters
Quote ' becomes ` Grave Accent
could use '', but we selected this one '`' many years back
Ampersand & becomes + plus sign
Vertical Bar Bar | becomes ' ' blank space
we 're going to use the Bar as a delimiter later, so we need it out of the data, for now
Square bracket [ becomes ( round bracket
] becomes )
we use these as a replacement value to form insert statements, later
...
TAB delimiter becomes Vertical Bar '|'
its far easier to work with a delimiter that we can see
Double space space becomes single space
click this a few times to reduce the size of the text file
click SAVE
Data.txt will now look like this. Notice the Reviewed-date is our leftmost value.
...