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 | 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 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.
Add Comment