List the Markers

• On a Linux system, you can get the marker list with a command line expression:

  • cat filename.db | perl -CSD -pe "s/ .*$//" | sort | uniq -c > sfm-list.txt   

or 

• • dos2unix < filename.db | perl -CSD -pe "s/ .*$//" | sort | uniq -c > sfm-list.txt 

[Note: there is a space before the .* in this command, and there is no space in the // part of the command]

• • The result will be a file called sfm-list.txt with a list of all the SFMs and a count of how many times each occurs.

• Open that file in Notepad++.  Use search/replace to change the space between the counts and the markers into a tab, so this file will be tab-delimited (and easier to paste into Excel):

  • Tick "Regular Expressions"

  • Find: "([0-9]) "   (don't type the quotes, and be sure there is a space at the end) [This finds a single digit followed by a space, and captures only the digit to use in the replacement string.]

  • Replace: "$1\t"           (with no quotes)  [This puts in the item that was captured in the Find (the single digit that occurs before a space) followed by a tab.]

  • The result should be two columns separated by a tab.

[There is also a way to do it with "Convert text to table" in Word that doesn't require the regular expression search/replace operation.]