Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »

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.

  • No labels