[HFbeacons] formatted with OpenOffice Calc

  • From: Dieter Pelz <dpelz@xxxxxxxxxxxxx>
  • To: "James R. Pilgram" <jim.pilgram@xxxxxxxxx>, "hfbeacons@xxxxxxxxxxxxx" <hfbeacons@xxxxxxxxxxxxx>
  • Date: Sat, 9 Apr 2016 07:09:28 +1000

Hi Jim

I also have this problem with lost formatting when pasting RBN data directly into an e-mail.

Here is one way of doing it, I found recently:

paste RBN copied data into wordpad or any text editor

find and replace all "[LoTW]" entries with blanks (they stuff up the formatting)

save (may not be needed)

select all

copy

paste into spreadsheet (I used openoffice calc) - select space as delimiter

check that all is neat and proper - delete redundant columns

select all

copy

paste into e-mail


Many steps, yes. When I paste RBN data into gmail using gmail.com when I am at work, it formats nicely with flags & all.

73
Dieter, VK3FFB



NH6HI   N5MIG   28217.2         CW      BCN     3       dB      13      wpm     
        2314z   7       Apr
NH6HI   KD4AOZ/B        28264.3         CW      BCN     5       dB      18      
wpm     
        2313z   7       Apr
NH6HI   KE5JXC/B        28251.7         CW      BCN     9       dB      11      
wpm     
        2313z   7       Apr
NH6HI   K7EK/B  28249.3         CW      BCN     2       dB      15      wpm     
        2311z   7       Apr
NH6HI   KE4TWI  28204.8         CW      BCN     6       dB      14      wpm     
        2310z   7       Apr
NH6HI   N5MIG   28217.2         CW      BCN     2       dB      13      wpm     
        2310z   7       Apr
NH6HI   N3NIA   28204.9         CW      BCN     9       dB      16      wpm     
        2310z   7       Apr
NH6HI   W4CLM/B         28233.1         CW      BCN     3       dB      15      
wpm     
        2307z   7       Apr
NH6HI   KB2SEO/B        28238   CW      BCN     8       dB      15      wpm     
        2307z   7       Apr
NH6HI   XE1RCS  28183.2         CW      BCN     17      dB      14      wpm     
        2307z   7       Apr
NH6HI   W4TIY/B         28271.9         CW      BCN     5       dB      18      
wpm     
        2307z   7       Apr
NH6HI   K4JEE/B         28254.6         CW      BCN     11      dB      15      
wpm     
        2307z   7       Apr
NH6HI   K3CSF/B         28233   CW      BCN     10      dB      12      wpm     
        2306z   7       Apr
NH6HI   K5TLW/B         28291.7         CW      BCN     10      dB      13      
wpm     
        2306z   7       Apr
NH6HI   VK7RAE  28266.9         CW      BCN     2       dB      22      wpm     
        2306z   7       Apr
NH6HI   VK3RRU  28263.1         CW      BCN     5       dB      14      wpm     
        2306z   7       Apr
NH6HI   XE2O/B  28166.2         CW      BCN     10      dB      13      wpm     
        2305z   7       Apr
NH6HI   W3AW    28237.2         CW      BCN     3       dB      15      wpm     
        2305z   7       Apr
NH6HI   N1KON/B         28272.4         CW      BCN     4       dB      16      
wpm     
        2304z   7       Apr
NH6HI   AB8Z/B  28264.1         CW      BCN     14      dB      19      wpm     
        2304z   7       Apr
NH6HI   K5TLL/B         28298.1         CW      BCN     10      dB      9       
wpm     
        2303z   7       Apr
NH6HI   W8YT    28236.1         CW      BCN     12      dB      13      wpm     
        2303z   7       Apr
NH6HI   KE4TWI/B        28204.8         CW      BCN     4       dB      14      
wpm     
        2302z   7       Apr
NH6HI   ND4Z    28293.7         CW      BCN     4       dB      14      wpm     
        2302z   7       Apr
NH6HI   WJ5O/B  28289.6         CW      BCN     4       dB      13      wpm     
        2302z   7       Apr
NH6HI   K5GJR/B         28224.3         CW      BCN     7       dB      10      
wpm     
        2302z   7       Apr
NH6HI   WA3RNC/B        28224.4         CW      BCN     8       dB      15      
wpm     
        2301z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     9       dB      14      
wpm     
        2300z   7       Apr
NH6HI   N4PAL   28214.1         CW      BCN     6       dB      12      wpm     
        2300z   7       Apr
NH6HI   KG2GL/B         28245.9         CW      BCN     2       dB      16      
wpm     
        2252z   7       Apr
NH6HI   W8EH    28281.2         CW      BCN     3       dB      12      wpm     
        2251z   7       Apr
NH6HI   N1KON/B         28272.4         CW      BCN     3       dB      16      
wpm     
        2251z   7       Apr
NH6HI   AA1TT/B         28269.2         CW      BCN     6       dB      10      
wpm     
        2251z   7       Apr
NH6HI   W4CLM/B         28233.1         CW      BCN     10      dB      15      
wpm     
        2251z   7       Apr
NH6HI   XE2O/B  28166.2         CW      BCN     3       dB      13      wpm     
        2250z   7       Apr
NH6HI   W4TIY/B         28271.9         CW      BCN     5       dB      18      
wpm     
        2250z   7       Apr
NH6HI   K5AB    28280.1         CW      BCN     5       dB      15      wpm     
        2250z   7       Apr
NH6HI   W8YT    28236.1         CW      BCN     4       dB      13      wpm     
        2249z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     7       dB      15      wpm     
        2245z   7       Apr
NH6HI   N4PAL   28214.1         CW      BCN     4       dB      12      wpm     
        2245z   7       Apr
NH6HI   WJ5O/B  28289.6         CW      BCN     4       dB      13      wpm     
        2245z   7       Apr
NH6HI   WJ5O/B  28289.6         CW      BCN     3       dB      13      wpm     
        2245z   7       Apr
NH6HI   VK4RTL  28270   CW      BCN     3       dB      12      wpm     
        2243z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     9       dB      14      
wpm     
        2238z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     9       dB      15      wpm     
        2229z   7       Apr
NH6HI   KP3FT/B         28222.3         CW      BCN     3       dB      11      
wpm     
        2225z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     4       dB      14      
wpm     
        2223z   7       Apr
NH6HI   XE2O/B  28166.2         CW      BCN     11      dB      13      wpm     
        2219z   7       Apr
NH6HI   K6FRC/B4        28225   CW      BCN     9       dB      14      wpm     
        2215z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     10      dB      15      wpm     
        2214z   7       Apr
NH6HI   XE2O/B  28166.2         CW      BCN     4       dB      13      wpm     
        2209z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     2       dB      14      
wpm     
        2206z   7       Apr
NH6HI   K6FRC/B2        28250.1         CW      BCN     3       dB      14      
wpm     
        2205z   7       Apr
NH6HI   KK6RE/B         28235.4         CW      BCN     2       dB      12      
wpm     
        2203z   7       Apr
NH6HI   K6FRC/B4        28225   CW      BCN     8       dB      14      wpm     
        2200z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     10      dB      15      wpm     
        2159z   7       Apr
NH6HI   PT9BCN/B        28284.4         CW      BCN     7       dB      13      
wpm     
        2143z   7       Apr
NH6HI   K6FRC/B         28300.1         CW      BCN     12      dB      11      
wpm     
        2138z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     8       dB      15      wpm     
        2138z   7       Apr
NH6HI   K6FRC/B         28250.1         CW      BCN     8       dB      14      
wpm     
        2137z   7       Apr
NH6HI   KK6RE/B         28235.4         CW      BCN     9       dB      12      
wpm     
        2134z   7       Apr
NH6HI   K7EK/B  28249.4         CW      BCN     6       dB      14      wpm     
        2133z   7       Apr
NH6HI   K6FRC/B         28300.1         CW      BCN     11      dB      11      
wpm     
        2131z   7       Apr
NH6HI   K6FRC/B4        28225   CW      BCN     6       dB      14      wpm     
        2131z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     10      dB      15      wpm     
        2122z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     11      dB      15      wpm     
        2107z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     8       dB      14      
wpm     
        2101z   7       Apr
NH6HI   WH6S    28121   CW      CQ      16      dB      20      wpm     
        2052z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     11      dB      15      wpm     
        2052z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     6       dB      12      
wpm     
        2046z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     8       dB      15      wpm     
        2037z   7       Apr
NH6HI   XE1RCS  28183.2         CW      BCN     9       dB      14      wpm     
        2032z   7       Apr
NH6HI   K8NDB   28248.8         CW      BCN     2       dB      13      wpm     
        2009z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     5       dB      15      wpm     
        2000z   7       Apr
NH6HI   V73TEN  28298.1         CW      BCN     6       dB      15      wpm     
        1943z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     8       dB      14      
wpm     
        1929z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     3       dB      14      
wpm     
        1914z   7       Apr
NH6HI   XE1RCS/B        28183.2         CW      BCN     6       dB      14      
wpm     
        1851z   7       Apr


Other related posts:

  • » [HFbeacons] formatted with OpenOffice Calc - Dieter Pelz