[chirp_users] How to Edit columnb information in chirp csv file?
Hi: I am a New user of chirp, I downloaded a repeater file for my area from Repeaterbook. My Radio is a ICOM t70a, I wish to upload this file to my tranceiver. I have the t70a to display repeaters by Name! I can sort the Location names alphabetically in the comments column from A to Z which is what I want, but this randomly sorts the memory locations in the Loc column, eg: 25, 42, 52, 7........ I would like to have the repeaters to be in alpabetical order by location, AND have the memory Locations to be in order from 1to 58 as there is 58 repeaters. I would also like to change entries in the Name column to locations in alphabetical order instead of reapeater callsign as they are now. How would I do this?
Any help Greatly appreciated! Rodney Kozey VE5RMK
Export to csv format and rearrange in your favourite spreadsheet program then import back into Chirp.
On 13 January 2018 at 01:38 ve5rmk@sasktel.net wrote:
Hi: I am a New user of chirp, I downloaded a repeater file for my area from Repeaterbook. My Radio is a ICOM t70a, I wish to upload this file to my tranceiver. I have the t70a to display repeaters by Name! I can sort the Location names alphabetically in the comments column from A to Z which is what I want, but this randomly sorts the memory locations in the Loc column, eg: 25, 42, 52, 7........ I would like to have the repeaters to be in alpabetical order by location, AND have the memory Locations to be in order from 1to 58 as there is 58 repeaters. I would also like to change entries in the Name column to locations in alphabetical order instead of reapeater callsign as they are now. How would I do this?
Any help Greatly appreciated! Rodney Kozey VE5RMK _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Nigel Gunn, W8IFF at nigel@ngunn.net To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
Nigel A. Gunn, 1865 El Camino Drive, Xenia, OH 45385-1115, USA. tel +1 937 825 5032 Amateur Radio G8IFF W8IFF (was KC8NHF 9H3GN), e-mail nigel@ngunn.net www http://www.ngunn.net Member of ARRL, QRPARCI #11644, SOC #548, Flying Pigs QRP Club International #385, Dayton ARA #2128, AMSAT-NA LM-1691, GCARES, EAA382.
Hi Rodney,
This is not a chirp issue per se; it is a combination of two spreadsheet problems. You should use a spreadsheet program that you know well, or are willing to learn.
First, the locations: If it were me, I would open the csv file using Excel or equivalent, delete all the channel numbers (except for the header), sort the data by location, and then use the "Insert Series" function to renumber the channels from 1 to 58.
Regarding using location as the name: you can copy and paste the location (comments) column data (except for the header) into the name column (except for the header). One potential problem (I have not tried this), is what will chirp do with names that are too long? Will it truncate them? or barf all over them? You have two choices: try it as is and see what happens, or manually edit all the locations (in the name column) to be short enough for your T70A's display.
Once all your edits are complete, save it all as a csv file, and import it all into chirp.
Good luck. Let us know how it goes.
Chris KC9AD
-----Original Message----- From: chirp_users-bounces@intrepid.danplanet.com [mailto:chirp_users-bounces@intrepid.danplanet.com] On Behalf Of ve5rmk@sasktel.net Sent: Friday, January 12, 2018 10:39 PM To: chirp_users@intrepid.danplanet.com Subject: [chirp_users] How to Edit columnb information in chirp csv file?
Hi: I am a New user of chirp, I downloaded a repeater file for my area from Repeaterbook. My Radio is a ICOM t70a, I wish to upload this file to my tranceiver. I have the t70a to display repeaters by Name! I can sort the Location names alphabetically in the comments column from A to Z which is what I want, but this randomly sorts the memory locations in the Loc column, eg: 25, 42, 52, 7........ I would like to have the repeaters to be in alpabetical order by location, AND have the memory Locations to be in order from 1to 58 as there is 58 repeaters. I would also like to change entries in the Name column to locations in alphabetical order instead of reapeater callsign as they are now. How would I do this?
Any help Greatly appreciated! Rodney Kozey VE5RMK _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Chris KC9AD at nbv87@hotmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
participants (3)
-
Nigel A. Gunn G8IFF/W8IFF -
Not D'Arcy Cain -
ve5rmk＠sasktel.net