I frequently need to manipulate CSV files. For example:
First Name [Required],Last Name [Required],Email Address [Required],Status [READ ONLY],Last Sign In [READ ONLY],Licenses [READ ONLY]
Aadyn,smith,28asmith@student.swjcs.us,Active,2026/05/22 06:53:45,“1010310008,1010070001”
Aarilyn,Orvil,32aorvil@student.swjcs.us,Suspended,2021/09/02 09:05:31,1010070001
Aaron,Bolan,32abolan@student.swjcs.us,Suspended,2023/11/22 06:47:16,1010070001
I sometimes need to delete any lines with ‘Suspended’ or remove the time. In GVim, I can record a macro by performing several actions on one line. Then I can run the macro on any other line or all lines. When a file is several thousand lines long, this is a huge time saver.
In GVim I can use the keystrokes, (3 f,) to go to the 3rd comma in a line. Then delete or add as needed.
Currently I open the file in GVim and after recording and running the macro, I paste into Checkvist.
Kevin