Re: [gentoo-user] OT: how does excel find commas within fields of a csv file?
On Wed, Feb 28, 2024 at 6:25 PM Adam Carter wrote: >> >> The other thing is, look up the definition (such as there is) of CSVs. >> Special characters (such as commas) can be quoted. Standard practice as >> far as I can tell, is that any cell containing a comma will be >> double-quoted, and the quotes are stripped on import. > > > Thanks - looks like quoting is the answer. It might not be something you want to deal with but pretty much every Python data analysis and machine learning package has functions for reading and writing CSV files. - Mark
Re: [gentoo-user] OT: how does excel find commas within fields of a csv file?
> The other thing is, look up the definition (such as there is) of CSVs. > Special characters (such as commas) can be quoted. Standard practice as > far as I can tell, is that any cell containing a comma will be > double-quoted, and the quotes are stripped on import. > Thanks - looks like quoting is the answer.
Re: [gentoo-user] Why is KDE so bad at multiple monitors?
On Wed, Feb 28, 2024 at 3:24 PM Dale wrote: > > Paul B. Henson wrote: > > On Sat, Feb 24, 2024 at 08:53:37PM -0800, Daniel Frey wrote: > >> After cursing KDE for a while with three monitors, does anyone have any > >> idea why KDE is so bad at managing multiple monitors? > > . I ended up adding this to /usr/share/sddm/scripts/Xsetup: > > > > xrandr --output DVI-D-0 --primary --output HDMI-A-0 --left-of DVI-D-0 > > --output DisplayPort-0 --right-of DVI-D-0 > > > > Always perfect since then :). > > I have two questions. Does a upgrade change it back to defaults? If > so, there may be a file in /etc somewhere that is more permanent. If > not, cool. :-) > > How did you get the info to match the hardware you have? My main > display is on a DB15HD port. My second display in on a HDMI port. I > figure you ran a command to gather that info or there is a source of all > the possibilities. > > I'd like to give that a shot. Might help with my occasional issue. > > Dale > > :-) :-) If you're just looking for what's connected to what port then xrandr will tell you that. To get to Paul's equation you would need to figure out the ordering yourself I think HTH, Mark
Re: [gentoo-user] Why is KDE so bad at multiple monitors?
Paul B. Henson wrote: > On Sat, Feb 24, 2024 at 08:53:37PM -0800, Daniel Frey wrote: >> After cursing KDE for a while with three monitors, does anyone have any >> idea why KDE is so bad at managing multiple monitors? > . I ended up adding this to /usr/share/sddm/scripts/Xsetup: > > xrandr --output DVI-D-0 --primary --output HDMI-A-0 --left-of DVI-D-0 > --output DisplayPort-0 --right-of DVI-D-0 > > Always perfect since then :). I have two questions. Does a upgrade change it back to defaults? If so, there may be a file in /etc somewhere that is more permanent. If not, cool. :-) How did you get the info to match the hardware you have? My main display is on a DB15HD port. My second display in on a HDMI port. I figure you ran a command to gather that info or there is a source of all the possibilities. I'd like to give that a shot. Might help with my occasional issue. Dale :-) :-)
Re: [gentoo-user] Why is KDE so bad at multiple monitors?
On Sat, Feb 24, 2024 at 08:53:37PM -0800, Daniel Frey wrote: > After cursing KDE for a while with three monitors, does anyone have any > idea why KDE is so bad at managing multiple monitors? . I ended up adding this to /usr/share/sddm/scripts/Xsetup: xrandr --output DVI-D-0 --primary --output HDMI-A-0 --left-of DVI-D-0 --output DisplayPort-0 --right-of DVI-D-0 Always perfect since then :).
[gentoo-user] Heads-up: grub-mkconfig generates bad configs for root-on-ZFS with fully-updated pool
This is a quick heads-up for folks who use grub, have their root filesystem on ZFS and boot from it with an initramfs (i.e. not directly from grub), and have fully upgraded their pool to 2.2.2. In that configuration, grub-mkconfig (grub-probe, actually) fails to recognize the pool, and it generates a bad kernel command-line. For example, if you normally have: root=ZFS=POOL/root/gentoo in your kernel command-line, after updating to 2.2.2 and upgrading your pool, grub-mkconfig will instead set the following, without warning: root=ZFS=/root/gentoo That is, the pool name is missing. This is due to grub-probe not recognizing the pool due to the com.klarasystems:vdev_zaps_v2 feature, among others. So, please double-check the output of grub-mkconfig and fix the root= entry. (I've been trying to paper over the issue with a quick patch to grub, but unsuccessfully so far; apparently the feature above isn't the only one causing issues.) -- Remy
Re: [gentoo-user] OT: how does excel find commas within fields of a csv file?
On 28/02/2024 02:17, Jack wrote: On 2/27/24 20:54, Adam Carter wrote: To clean up csv files I use excel's find/replace to swap the commas occurring within fields for something benign. How does this magic work? Different character sets within the same file? Is it possible to do this with shell scripting? Once Excel (or LibreOffice) reads in a csv file, the commas are no longer present, and it just searches within the cells. It might be possible for a shell script to do it, but you need to parse the file to distinguish any commas separating the fields from commas within the fields. I'm sure there are plenty of utilities to do this, but it's certainly not trivial. The other thing is, look up the definition (such as there is) of CSVs. Special characters (such as commas) can be quoted. Standard practice as far as I can tell, is that any cell containing a comma will be double-quoted, and the quotes are stripped on import. The other trick I learnt is that to prevent Excel mangling text, you precede it with a single quote - for example I want eg "+7" in a cell, so I have to enter '+7. Cheers, Wol