<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META charset=UTF-8>
<META name=GENERATOR content="MSHTML 11.00.9600.19236">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>I personally haven't found it to be very intuitive
for editing.</FONT></DIV>
<DIV style="FONT: 10pt arial">Glenn</DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=nigel@ngunn.net href="mailto:nigel@ngunn.net">Nigel A. Gunn
G8IFF/W8IFF</A> </DIV>
<DIV><B>To:</B> <A title=chirp_users@intrepid.danplanet.com
href="mailto:chirp_users@intrepid.danplanet.com">Discussion of CHIRP</A> ; <A
title=gcraig@WebcoIndustries.com href="mailto:gcraig@WebcoIndustries.com">Gary
Craig</A> </DIV>
<DIV><B>Sent:</B> Monday, January 21, 2019 9:15 AM</DIV>
<DIV><B>Subject:</B> Re: [chirp_users] Tyt 9800 Update working with CSV
files</DIV></DIV>
<DIV><BR></DIV>
<P>Isn't it easier to just use Chirp's inbuilt editor?</P>
<P>I've never neededd to play with CSV format.</P>
<BLOCKQUOTE type="cite">On 21 January 2019 at 10:05 Gary Craig <<A
href="mailto:gcraig@WebcoIndustries.com">gcraig@WebcoIndustries.com</A>>
wrote: <BR><BR>
<DIV class=ox-6bb14e4d5b-WordSection1>
<P class=ox-6bb14e4d5b-MsoNormal>Glenn,</P>
<P class=ox-6bb14e4d5b-MsoNormal>Thanks for the heads up about open
office. I have had issues with excel and open office working with csv
files. Did a little research trying to find a good csv editor and ran
across this article:</P>
<P class=ox-6bb14e4d5b-MsoNormal><STRONG><SPAN style="FONT-SIZE: 24pt">How to
open CSV files safely with Microsoft Excel </SPAN></STRONG></P>
<P class=ox-6bb14e4d5b-MsoNormal style="TEXT-ALIGN: justify">SupportAbility
exports a number of CSV (Comma Separated Value) data files that can be used by
other applications for invoicing, NDIS payment requests and other
purposes.</P>
<P class=ox-6bb14e4d5b-MsoNormal style="TEXT-ALIGN: justify"><STRONG>THE
PROBLEM</STRONG></P>
<P class=ox-6bb14e4d5b-MsoNormal style="TEXT-ALIGN: justify">It is quite
common for SupportAbility users to open these exported CSV files using
programs like Microsoft Excel to check their contents before importing the
file into a third party application such as MYOB. However,
when Microsoft Excel opens a CSV file, it attempts to interpret the data
in that file and starts making changes to it. </P>
<P class=ox-6bb14e4d5b-MsoNormal style="TEXT-ALIGN: justify">For example, if
Excel sees something in the CSV file that it identifies as a date (often
incorrectly), Excel will change the date format in the CSV file to suit the
way that it prefers to dates to be formatted. Unfortunately, this
generally has the unintended consequence of breaking the CSV file for the
third party application that the CSV was specifically designed for.</P>
<P class=ox-6bb14e4d5b-MsoNormal style="TEXT-ALIGN: justify"><STRONG>THE
SOLUTION</STRONG></P>
<P class=ox-6bb14e4d5b-MsoNormal style="TEXT-ALIGN: justify">If you need to
open a CSV file in Excel without breaking it, here's how to do it:</P>
<OL type=1>
<LI class=ox-6bb14e4d5b-MsoNormal>Open a new Excel sheet, select the Data
tab, then click 'From Text' in the Get External Data group.
<LI class=ox-6bb14e4d5b-MsoNormal>Browse to the CSV file and select
'Import'.
<LI class=ox-6bb14e4d5b-MsoNormal>In step 1 of the Import Wizard choose
'Delimited' as the original data type. Click 'Next'.
<LI class=ox-6bb14e4d5b-MsoNormal>In step 2 of the Import Wizard choose
Comma as the delimiter (deselect the Tab check box) and click 'Next'.
<LI class=ox-6bb14e4d5b-MsoNormal>In step 3 of the Import Wizard, you
tell Excel not to change your formats. With the first column in the Data
Preview selected, scroll across to the last column and select it while
holding the SHIFT key (all columns should now be selected). Then
select 'Text' as the Column Data Format and click
'Finish'.
<LI class=ox-6bb14e4d5b-MsoNormal>Click OK to insert the data into cell
A1</LI></OL>
<P class=ox-6bb14e4d5b-MsoNormal style="TEXT-ALIGN: justify">You should now
have a spreadsheet with the imported data but without Excel breaking the
formatting required for the intended third party application. Remember
to export the file from Excel to CSV again before uploading to the third party
application if you have made changes.</P>
<P class=ox-6bb14e4d5b-MsoNormal><A
href="https://help.supportability.com.au/article/250-how-to-open-csv-files-safely-with-microsoft-excel">https://help.supportability.com.au/article/250-how-to-open-csv-files-safely-with-microsoft-excel</A></P>
<P class=ox-6bb14e4d5b-MsoNormal> </P>
<P class=ox-6bb14e4d5b-MsoNormal>I will try this out when i get a chance and
see if it will solve my issues so i can get all my radios programmed
correctly.</P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">
</SPAN></P>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">Be
blessed! </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">May
2019 be our year of change & growth! </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">
</SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">Gary
Craig </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">Maintenance
</SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">Webco
Industries </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">Texas
Distribution </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">750
Martin Luther King Jr Dr </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">Orange,
TX 77630-3094 </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">409-886-0807
ext. 107 </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">Fax
918-246-7045 </SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d">
</SPAN></P>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Segoe UI Emoji',sans-serif; COLOR: #1f497d"><A
href="mailto:gcraig@webcotube.com"><SPAN
style="COLOR: #0563c1">gcraig@webcotube.com</SPAN></A> </SPAN></P></DIV>
<P class=ox-6bb14e4d5b-MsoNormal> </P>
<DIV>
<DIV
style="BORDER-TOP: #e1e1e1 1pt solid; BORDER-BOTTOM-STYLE: none; PADDING-BOTTOM: 0in; PADDING-TOP: 3pt; BORDER-RIGHT-STYLE: none; PADDING-LEFT: 0in; BORDER-LEFT-STYLE: none; PADDING-RIGHT: 0in">
<P class=ox-6bb14e4d5b-MsoNormal><STRONG>From:</STRONG>
chirp_users-bounces@intrepid.danplanet.com
<chirp_users-bounces@intrepid.danplanet.com> <STRONG>On Behalf Of
</STRONG>Glenn At Home<BR><STRONG>Sent:</STRONG> Saturday, January 19, 2019
6:27 PM<BR><STRONG>To:</STRONG> Discussion of CHIRP
<chirp_users@intrepid.danplanet.com><BR><STRONG>Subject:</STRONG>
[chirp_users] Tyt 9800 Update</P></DIV></DIV>
<P class=ox-6bb14e4d5b-MsoNormal> </P>
<TABLE class="ox-6bb14e4d5b-MsoNormalTable mce-item-table" cellSpacing=3
cellPadding=0 border=0>
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt">
<P class=ox-6bb14e4d5b-MsoNormal><STRONG><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">This email
originated from an external sender. Use caution when following links or
opening attachments as they could be malicious
</SPAN></STRONG></P></TD></TR></TBODY></TABLE>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">Thanks All, I think I
got it working.</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">I tweaked the CSV
file, at one point, Open Office took out all the values in the offset column,
so I opened another file in Excel that was about the same, and I selected the
column and copied it and switched over to the file in Open Office and pasted
it in.</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">Setting it to the
defaults helped, because this time when I imported the file, I think, the VHF
is on the left and the UHF is on the right.</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">Not much UHF going on
around here to be sure.</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">I need to learn the
buttons on the mic other than the number pad and I know the top switch locks
some of the keys, including the two top ones.</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">It's good to turn
those off, as I find myself pressing keys on that thing just by holding it
while punching a button.</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">Anyway, thanks
all for helping me get this far.</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif">Glenn</SPAN></P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal> </P></DIV>
<DIV>
<P class=ox-6bb14e4d5b-MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial',sans-serif"><BR>Sent >From My
Tabletop</SPAN></P></DIV></DIV></BLOCKQUOTE>
<P class=default-style><BR> </P>
<BLOCKQUOTE type="cite">_______________________________________________
<BR>chirp_users mailing list <BR>chirp_users@intrepid.danplanet.com
<BR>http://intrepid.danplanet.com/mailman/listinfo/chirp_users <BR>This
message was sent to Nigel Gunn, W8IFF at nigel@ngunn.net <BR>To unsubscribe,
send an email to chirp_users-unsubscribe@intrepid.danplanet.com</BLOCKQUOTE>
<P class=default-style><BR> </P>
<P><BR></P>
<DIV class=io-ox-signature>
<P>Nigel A. Gunn, 1865 El Camino Drive, Xenia, OH 45385-1115, USA. tel +1 937
825 5032<BR>Amateur Radio G8IFF W8IFF and GMRS WRBV701, e-mail nigel@ngunn.net
www http://www.ngunn.net <BR><BR></P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>chirp_users mailing
list<BR>chirp_users@intrepid.danplanet.com<BR>http://intrepid.danplanet.com/mailman/listinfo/chirp_users<BR>This
message was sent to Glenn at glennervin@cableone.net<BR>To unsubscribe, send an
email to chirp_users-unsubscribe@intrepid.danplanet.com</BODY></HTML>