Re: [PLUG] Question on a quick CLI program for validating a csv file

2023-05-20 Thread American Citizen
There are some minor problems with the recent answers: 1. using awk -F, fails when a cell contains a quoted cell with an embedded comma 2. using pandas fails when the csv file is already flawed, panda throws an long exception error I cobbled together the csvlint program, trying to follow

Re: [PLUG] Question on a quick CLI program for validating a csv file

2023-05-20 Thread Michael Ewan
Use Python and Pandas. import pandas as pd df = pd.read_csv('filename', sep=',') print(df.head()) print(df.shape) # then do a boat load more operations on your data On Sat, May 20, 2023 at 5:37 PM American Citizen wrote: > Hello all: > > I am using the xsv program for most csv file operations

Re: [PLUG] Question on a quick CLI program for validating a csv file

2023-05-20 Thread Tomas Kuchta
awk -F, '{ print NF }' On Sat, May 20, 2023, 20:37 American Citizen wrote: > Hello all: > > I am using the xsv program for most csv file operations since it is > quite fast. > > There is one command which I wish it had, called "length" which would > give the fields per record (delineated by a

[PLUG] Question on a quick CLI program for validating a csv file

2023-05-20 Thread American Citizen
Hello all: I am using the xsv program for most csv file operations since it is quite fast. There is one command which I wish it had, called "length" which would give the fields per record (delineated by a line-feed or new line) awk or gawk does have NF variable and I can use this to verify

[PLUG] Updated Ubuntu server and Zoneminder.

2023-05-20 Thread Chuck Hast
Anyone running the latest ZM and Ubuntu server? I just did the update of the whole thing. All seems to be working except that ZMNinja only shows of the 10 cameras I have on the system. If I open the [monitors] section it shows all of the cameras but the ones not showing up have a bar through them.