Re: [gentoo-user] OT: how does excel find commas within fields of a csv file?

[Jack]

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.

[gentoo-user] OT: how does excel find commas within fields of a csv file?

[Adam Carter]

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?

Re: [gentoo-user] Why is KDE so bad at multiple monitors?

[Daniel Frey]

On 2/25/24 10:17, Mark Knecht wrote:



On Sun, Feb 25, 2024 at 10:35 AM Daniel Frey > wrote:


 > I probably should have added more details... I do have an nvidia card -
 > RTX 3070Ti. Monitors use 2x DP ports and 1x HDMI port.
 >
 > KDE behaves very strangely. Like, it crashes often when using multiple
 > monitors and I've never been able to figure that out.
 >
 > nvidia-settings (which I plain forgot about) can generate an Xorg.conf
 > file from what I remember, maybe I'll try that.
 >
 > I currently don't have an Xorg.conf (as everything I've read says it
 > should autodetect...) so maybe I'll try overriding it.
 >
 > Dan

I'm not Gentoo-based but have a similar setup. 3080ti, 2 Asus
monitors, 1 Samsung, all running 1920x1080, all in landscape.

I have absolutely no problems at all with KDE remembering where
everything goes, all 3 monitors, all taskbars, for multiple users
with different configurations. I use 1 HDMI cable and 2 HDMI->DVI
cables. Everything just works.

I have no xorg.conf file.

I tried Wayland for a while but there were too many weird artifacts
so I'm back to basics.

I'd suggest you look carefully at every flag you are using to
build your software. I've used 3 distros here recently, as well
as Win 10 & 11 and none of them have had problems like
you are describing.

Best of luck,
Mark


I've never had much luck with these displayport connections. My card is 
3x DP and 1x hdmi.


I am considering "starting fresh" on the weekend. The problem is there's 
so much config blended in with KDE now, it's not a simple "remove the 
.kde" folder to wipe the config any more. :/


I don't recall when I last did a fresh install, probably when I built 
this rig in 2018/19. But, I figure with a fresh slate it should be 
easier to get things like wayland to work - at least to give it a try. 
As I know KDE is going more systemd-like I may even try that... although 
systemd gave hits and fisses last time I tried it.



Dan

Re: [gentoo-user] Re: How to set up drive with many Linux distros?

[Peter Humphrey]

On Tuesday, 27 February 2024 00:12:07 GMT Mark Knecht wrote:

> I have no experience beyond three operating systems on a single machine
> but if you grabbed just 2 or 3 USB flash drives then I would think you
> could test it pretty easily. I believe the UEFI boot procedures are
> storing a unique ID for the disk or the partition you are requesting. If you
> have a unique ID that's different for each flash drive it would (hopefully)
> find the one you're looking for which should be relatively simple.
> 
> I would suggest you use the boot ordering feature and make the
> system hard drive last in the list. If no USB devices are plugged in
> it would default to your system drive. If a flash drive is plugged in
> it should find its ID and boot that first.
> 
> I do not know if, for instance, you had 20 different drives listed in
> your BIOS whether it would be a lot slower to boot but you could
> test that yourself.

My experience is that the BIOS will discard any boot devices that are not 
present at the time of booting. I don't know whether that's typical or just 
what I've found.

-- 
Regards,
Peter.