STEP 5 Character replacement

August 2022 - NOTE - all tasks listed below can now be handled by the BAT file at

FAA-PROCESS.TXT

–

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

Open