[03:14] <th4ntis> Really random question but im not sure what phrasing to use to search for this. I have a text file im trying to replace anything greater than that value of 5, to 5. Eg. Replacing a value of 13x to 5x in this specific text file
[03:16] <gnoob> I feel like you should be able to do that in a spreadsheet program.
[03:17] <th4ntis> Probably, but the time I tried it seemed to mess up something else in there and im not sure why so im just trying other alternatives.
[03:20] <gnoob> is it formated a CVS?
[03:21] <th4ntis> yes
[03:22] <th4ntis> IF it helps, im using Libre Office
[03:22] <gnoob> are the numbers all in a single column?
[03:22] <th4ntis> Yes
[03:23] <gnoob> are they all truly numbers or are the cells with numbers text and numbers.
[03:23] <th4ntis> just numbers right now
[03:23] <gnoob> How many rows is the sheet?
[03:24] <th4ntis> 2974
[03:27] <gnoob> hmm, can you use th "Data-Autofilter"  Then you click the little triangle near the colum you want to sort on.
[03:27] <gnoob> then go to "Standard Filter" and click it?
[03:27] <gnoob> You should be able to filter out only the rows over 5
[03:27] <gnoob> then replace those.
[03:27] <gnoob> mabye
[03:27] <gnoob> maybe
[03:29]  * gnoob was silenced by the bot for flooding.  Oops.
[03:32] <Dragnslcr> If it's a plain text file, you can open it in Kate and do a regex find/replace
[03:33] <th4ntis> gnoob, It does filter them out, just not sure what it does with them.
[03:33] <th4ntis> Dragnslcr, Yeah, im just not sure what that regex expression would be. :X Im still working on getting use to them.
[03:34] <gnoob> th4ntis: once filters you should only be manipulating those rows so anything over 5 you just past 5 into.  THen you remove the filter and the other data should be fine.
[03:36] <th4ntis> Oh duh, im doing it backwards. I see what you mean.
[03:39] <gnoob> ah, OK.
[03:43] <th4ntis> I got it. Than kyou for the help. :)
[03:43] <gnoob> great, now we both need to learn regex it's probably much easier.  :)
[03:44] <gnoob> so when you figure it out please come back and teach me.
[03:44] <th4ntis> Something so minor I just wasn't sure how to accomplish this and figured a sed command would help. xD and agreed - i've been working to know it more bit by bit when needed, kinda like now, just wasnt sure how to phrase it.
 use a formula in a new column, something like =IF(C4>5,12,C4)
 then copy/paste value over the originals and resave as CSV.
[04:21] <gnoob> seems like a good way too.  But he would want 5 to be the highest number so I think it wold be  =IF(A1>5,5,A1)
 yes, correct.
[04:22] <th4ntis> ^([0-5]\d|\d{3,})$ <-- Is the regex I used when I found out how to phrase it, this worked perfectly.
 via kate or did you nawk it from the command line?
[04:27] <th4ntis> using Libre Office since I was already editing in there, but I assume would work in Kate as well\
[04:30] <th4ntis> Oh, it worked for anything double digit over 5, but anything 6-9
[04:38] <th4ntis> \b([6-9]|[12][0-9]|3[0-2])\b <-- This worked. xD
 but it fails to match a number such as 69
 https://regex101.com/
[04:40] <th4ntis> Right. I found one, and I know I didnt have any that high so 32 worked for me.
 very good.
 If the data is already in LOC, I still think =IF(A1>5,5,A1) is easier to read and use... :)
[04:43] <th4ntis> This is literally all to sort my Magic Card collection. xD I had too many cards and am keeping only 5 of each card. I sorted them IRL  and anythig I had more and 5 of, im selling.
 😃
[04:47] <gnoob> it might be late but how does changing the count on all those to 5 help sort for what you are selling?
[04:49] <th4ntis> Im not keeping track of how many im selling at the moment, like I havent grabbed count of that. I just adjusted what im keeping to anything that had more than 5 to 5 since im only keeping 5 of each card.
[04:49] <th4ntis> If that makes sense
[04:53] <gnoob> If you did that filter thing again when you get the results you could copy and past them into a new tab and then delete them from the original tab. THen you would have one tab with cards you are keeping and one with cards you plan to get rid of.
[04:54] <th4ntis> Also true. I'll go ahead and do that now since it makes sense. xD
[04:55] <gnoob> I kind of see what you were doing with teh 5 thing.  I was just not seeing how you were going to format it later.
[04:57] <judamark74> acabo de instalar kubuntu 20.04 y no logro conectarme a mi internet por wifi como lo hago?
[07:19] <Guest92139> Good morning
 @My1xT, tried recovery too
 im using kubuntu 20.04 Focal Fossa LTS … can i update my kernel to 5.8 … (is there anything new )or just use as it is  … ? … im using  … Using a Lenovo IdeaPad s14 AMD A9
[11:45] <paolo_> I dowloaded xarrchive but I can't opne a Rar% archive .. how can I fix
[12:05] <nikan> Could you please help me with expand.
[12:05] <nikan> When I send a request to get a product list and expand `data.prices` (nodejs ), I received a standard response with a list.
[12:05] <nikan> But have no prices in data objects.
[12:05] <nikan> How I can receive prices in product objects?
[12:06] <nikan> `stripe.products.list` with `expand: ['data.prices']`
[12:35] <BluesKaj> Hiyas all
 Hey BlueKaj how are you?
[13:07] <catchthelsmq> HELLO)
 How are you?
[17:25] <user|1106> Where is the Themes folder on kubuntu
[17:25] <user|1106> ?
[17:26] <diogenes_> user|1106, ~/.themes and /usr/share/themes
[17:27] <user|1106> Thanks
[17:29] <user|1106> Do you know any other way for exp. a hidden folder, i guess there is no other possibility.
[17:30] <diogenes_> exp.?
[17:30] <user|1106> for example
[17:31] <user|1106> And do you know how to open this folder?
[17:32] <diogenes_> open dolphin and view > show hidden files.
[17:35] <TheGallopingFox> how can i upgrade to latest thunderbird 78 on kubuntu 20.04
[18:14] <guillaume_> hi
[20:47] <user|40039> Hello
[20:48] <user|40039> What can i use to burn the iso on to a USB stick ?
 From what platform?  Kubuntu, Windows, etc?
[20:48] <user|40039> Mac
[20:49] <oerheks> !usb
[20:49] <user|40039> Thanks for the help
[20:50] <oerheks> https://ubuntu.com/tutorials/create-a-usb-stick-on-macos#1-overview
 is there a way to get the gui running if nomodeset doesnt help?
 recently my laptop stopped showing it on 18.04
[21:49] <valorie> are you completely up-to-date, @My1xT ?
 I updated multiple times via tty2 yeah
 I also tried to ax the mesa ppa I used for steam
 it happened like 2 weeks or so ago iirc I rebooted and boom, no GUI on the screen or HDMI output
 GPUs are Intel® HD Graphics 620 and radeon 520
 in case it helps
 also when doing recovery -> continue to boot I get to the login screen but after submitting my password the GUI freezes down
 system seems to work tho as it does get the powerbutton iirc
 frankly this is kinda sad. this installation ran like a tank for almost 2 years
[22:05] <tomreyn> My1xT: ensure you have only ubuntu repositories configured, no ppas which could provide packages also available in kubuntu, then run    sudo apt update && sudo apt install apt-forktracer && sudo apt-forktracer | nc termbin.com 9999
[22:05] <tomreyn> apt-forktracer is a utility to list packages and package versions which don't come from the repositories you have enabled.
[22:07] <tomreyn> the "| nc termbin.com 9999" part will post the apt-forktracer output to termbin.com, a pastebin-like site. but you'll need to be online for this to work (same goes for apt updating)-
 Okay i have a bunch of applications like browsers, skype etc. How do i quickly disable them best ideally temporarily only
[22:08] <tomreyn> oh i was thinking you have no gui at all now?
[22:09] <tomreyn> oh you mean you don't want to uninstall them
 I have no gui but this was running for almost 2 years, so of course there's stuff installed.
[22:10] <tomreyn> we can go over the list together once you have it, and you can tell which ones are fine, and which ones you didn't mean to have installed anymore
[22:10] <tomreyn> disabling the repositories doe snot mean uninstalling the software
[22:10] <tomreyn> i'm not suggesting you should uninstall software now
 Yeah but I am not aware how to quickly ax the repo without deleting each file in sources. List. D
[22:11] <tomreyn> oh ok
 And getting them back would probably be annoying
 It's not like it's just one file where i can just push a few # each line
[22:12] <tomreyn> you can either rename the .list files in /etc/apt/sources.list.d/ to *.save, or you can edit them and make sure every line is either empty or starts with a #
 I mean in the gui there were iirc checkboxes for each repo but yeah not currently
 There already is a .save for every one inside
[22:12] <tomreyn> you can overwrite the existing .save ones
 (Photo, 720x1280) https://irc-attachments.kde.org/5IaCuCXI/file_34358.jpg Looks a bit like this
[22:13] <tomreyn> if you prefer to keep the existing .save files, just rename the .list files to .disabled
[22:13] <tomreyn> you'll get warnings then about those files during apt update, but that's ok
 Is there a multirename?
 Probably not i guess
[22:14] <tomreyn> there is mrename
[22:15] <tomreyn> also mmv
 Mmv seems good. Gimme a sec
 https://termbin.com/isvc
 sort by original repo or whatever might be helpful
[22:20] <tomreyn> hmm pretty long list there
[22:20] <tomreyn> much of it is sury's php
 yup and a local amdgpu repo
 I have no idea why there is a locally stored repo for that lol
[22:21] <tomreyn> ? you are using amdgpu-pro?
 seems like it
[22:21] <tomreyn> okay, problem solved, that was easy
 the file dates according to ll is october 2018 tho
 so I thought I had this basically all the time
 since I installed around august 2018
[22:23] <tomreyn> https://termbin.com/mux8 sorted alphabetically
 Also some amdgpu and/or radeon packages seem to take a whole long list along when trying to remove so i tried to not to
 that seems a LOT easier to read
[22:23] <tomreyn> did you have a repository where those amdgpu packages came from?
 as I said local.
 no idea
[22:24] <tomreyn> normally i'd expect those to be called amdgpu-pro if it's the amd proprietary driver overlay
 Literally /var/opt/amdgpu-pro-local
[22:24] <tomreyn> i understood "a local apt repository"
[22:24] <tomreyn> right ok, thats amdgpu-pro then
 I don't even care about overlays
[22:25] <tomreyn> so, i don't recommend nor try to support this driver
 I see.
[22:25] <tomreyn> if you don't strictly need it, then look into how you can uninstall it
 Should i try to ppa-purge it?
[22:26] <tomreyn> amd *may* provide instructions fro removal
[22:26] <tomreyn> the version numbers suggest you have amdgpu-pro version 18.20 installed
[22:26] <tomreyn> check their website for uninstallation instructions
[22:26] <tomreyn> you'd need to re-enable the repository before doing this
 Sounds like it
 Well yeah I thought of enabling them all and then do ppa purge
 On the amd thing
[22:27] <stryker_> helloo
[22:27] <tomreyn> i already told you alol i know about amdgpu-pro and how to properly uninstall it.
[22:27] <tomreyn> alol -> all
[22:29] <tomreyn> My1xT: i suggest you re-activate all the PPAs now. and then run     sudo apt update && sudo apt-forktracer | nc termbin.com 9999    again
[22:29] <tomreyn> stryker-: could you please leave the channel until you sorted yout the nickname?
[22:29] <stryker-> hi
[22:29] <stryker13> OK, I'll keep this name
[22:30] <stryker13> hello, everyone
 Oh i went with the amdgpu-Uninstall i grabbed from the amd site right before I got your message
[22:30] <stryker13> tomeryn, you can use ,
 Lemme try a reboot
 Okay i have a login screen but after throwing in my password i don't seem to get into plasma
[22:32] <tomreyn> so same as before, more or less
 Mouse cursor moves tho and tty2 is accessible
 My1xT: i suggest you re-activate all the PPAs now. and then run     sudo apt update && sudo apt-forktracer | nc termbin.com 9999    again
 Yeah I have something on the screen but not much of use
[22:32] <tomreyn>  ^ this still applies
 On my way already
 Console says rw12 but browser says 404
[22:35] <tomreyn> you'll have mixed up a character, such as mistaking a "one" for an "eye"
[22:35] <tomreyn> or an "al"
 https://termbin.com/rwl2 now that works
 fonts are awesome -.-
 libwayland-egl1-mesa -> that one might look interesting
[22:36] <tomreyn> btw. you can add    | sort     before the     | nc ...     to have it sorted, i forgot to add this.
 ok
[22:37] <tomreyn> https://termbin.com/quf0
[22:39] <tomreyn> My1xT: so, now for how to interpret the output: packages with just version numbers in   (round parentheses)   are installed, but no currently enabled repository provides them. they are leftovers from an earlier ubuntu release, or packages you once installed using dpkg -i
[22:40] <tomreyn> those you probably want to remove, or, if you still need them, such as your printer drivers, ensure you have the latest version. (but do those upgrades later)
[22:41] <tomreyn> so go over those with just parentheses first of all, and uninstall any you don't need.
 this entry looks weird tho … network-manager (1.10.14-0ubuntu2) [Ubuntu: 1.10.6-2ubuntu1.4 1.10.6-2ubuntu1.1 1.10.6-2ubuntu1] … why is something that looks like from ubuntu directly in forktrace?
[22:42] <tomreyn> because you chose to install a version, 1.10.14-0ubuntu2, which is not available in your ubuntu release
[22:42] <tomreyn> i.e. the version you have installed is newer than what 18.04 provides
[22:43] <tomreyn> but it is also unknown where this upgraded version is from, or where it would get (security?) updates from
[22:43] <rivimey-M> Hi, new here and wondering if this is the right place to talk about building all of kde/plasma from source on ubuntu focal.
[22:44] <tomreyn> rivimey-M: it's not the wrong place. but major undertakings as this might be better suited for a forum or mailing list, i guess.
[22:44] <tomreyn> we could discuss why or whether you hsould be doing this, though
[22:45] <rivimey-M> I had two questions: firstly, using kdesrc-build I found many more -dev packages were needed than were mentioned in the official dev docs. I added packages as best I can until it worked, and can upload the resulting list if that would be helpful.
[22:45] <TheGallopingFox> are snaps checked for outdated libs like apts are?
[22:45] <TheGallopingFox> or security patches etc
[22:46] <TheGallopingFox> or can they be forgotton about leaving holes in your system?
[22:46] <rivimey-M> I have built the whole thing now minus two areas: krita (mostly haven't bothered to make it work) and telepathy/signon/accounts, which at least need libsignon-glib at version 2, which I have been unable to find and get working.
[22:47] <tomreyn> TheGallopingFox: that's the responsibility of the snap package maintainer - same as for apt packages (just that for apt packages in the 'main' section security support is provided / somewhat guaranteed)
[22:47] <TheGallopingFox> ok
[22:47] <tomreyn> My1xT: i assume you're busy cleaning up, will just talk to the other folks for a bit in the mean time, unless i hear otherwise.
[22:49] <tomreyn> rivimey-M: so this is more of a support than a development channel. i assume there is #kubuntu-devel, where your questions may meet a better audience.
[22:49] <tomreyn> rivimey-M: why are you building yourself in the first place though?
[22:50] <tomreyn> TheGallopingFox: and your responsibility as an 'end user' would be to install software from sources (and developers) you think you can trust
[22:51] <tomreyn> and my point of view on snaps is that i have no reliable way of telling apart those snaps i could trust from those i couldn't
[22:51] <tomreyn> which is part of why i'm not going to use them
[22:51] <rivimey-M> tomreyn:
[22:52] <tomreyn> rivimey-M: ideally highlight after you said something meaningful ;)
[22:52] <rivimey-M> oops. anyway, I started building myself because I have a 4K display and was getting a lot of pixel damage when I used screen scaling ("retina") with it.
[22:52] <tomreyn> or /when/
[22:53] <rivimey-M> I found out that Qt 5.15 had some important fixes but the ubuntu repos were using a much earlier version.
[22:53] <stryker13> #xubuntu
[22:53] <tomreyn> rivimey-M: i see, and you read somewhere that building the software yourself would prevent this? adding some patch, or not?
[22:54] <stryker13> #kali
[22:54] <stryker13> #awesome
[22:54] <tomreyn> stryker13: are you ok there?
[22:54] <rivimey-M> I found that if I built kde using qt 5.15 there were many fewer damage regions when using screen scaling.
[22:54] <tomreyn> stryker13: please stop posting off-topic stuff here.
[22:54] <stryker13> I want to see what channels there are lol
[22:54] <stryker13> o
 (Document) https://irc-attachments.kde.org/fsnCrB5Z/file_34359.txt
[22:54] <stryker13> k
 the interesting ones I cant overly well categorize are … libnm0 (1.10.14-0ubuntu2) … network-manager (1.10.14-0ubuntu2) … which both seem to be from ubuntu tho
[22:56] <rivimey-M> I haven't been patching...   though the last area (Konsole) has a bug which I did have a look at, but it's really unclear how best to move on that code. What is going on there is that lines of pixels are not written to at all, and as the window is cleared to transparent it shows. There is a bug report for that, so I won't digress.
[22:56] <tomreyn> rivimey-M: i see. i couldn't personally comment on this, sorry (maybe someone else here or in -devel can). i'm not enough into screen scaling and, moreover, not enough into kde + qt.
[22:57] <tomreyn> My1xT: i got a 403 on the url you posted
[22:57] <rivimey-M> perhaps I should move to the devel list?
[22:58] <tomreyn> rivimey-M: up to you, but it's what i suggested earlier
 lol what URL? did the file attach spawn weirdly
 sec
[22:59] <rivimey-M> Anyway, reason I came on here was that the last couple of builds I did (from master) was that things aren't building, and to ask if there are tags or similar which are advanced whenever a build works completely.
 https://nc.my1.tech/index.php/s/TpkKELfN9sSjBem this should work tomreyn
[23:00] <tomreyn> My1xT: libnm0 is network manager
[23:01] <tomreyn> My1xT: network-manager is what manages internet access profiles and connectivity on a desktop
[23:02] <tomreyn> My1xT: i would recommend you downgrade anything to the versions in (k)ubuntu proper unless you actually know you need this newer version (which may introduce package version conflicts, and may never get security patches) for a specific reason.
 ok
 is there a quick "downgrade to whatever latest is available or is remove then install the best option
[23:05] <tomreyn> apt install package=targetversion
 okay lemme search the versions real quick
[23:06] <tomreyn> target version would be the first version given in the last set of  [ brackets ]
[23:07] <tomreyn> e.g. with this line: network-manager (1.10.14-0ubuntu2) [Ubuntu: 1.10.6-2ubuntu1.4 1.10.6-2ubuntu1.1 1.10.6-2ubuntu1]
[23:07] <tomreyn> you'd use   sudo apt install network-manager=1.10.6-2ubuntu1.4
 okay
 thx
[23:08] <tomreyn> you can also specify multiple package=targetversion pairs you want apt to operate on at the same time
[23:09] <tomreyn> i.e. for network manager you may want to us    sudo apt install network-manager=1.10.6-2ubuntu1.4 libnm0=1.10.6-2ubuntu1.4
[23:10] <tomreyn> this can make it easier for apt to pick the solution you intend.
[23:11] <tomreyn> but it can also cause packages to get marked as manually installed (that weren't previously). if this happens (apt will say so), you can run  sudo apt-mark auto PACKAGE    against those packages apt reported it for.
 @tomreyn, Thx just did, rebooting
 @tomreyn, Ok
 Btw i got further. While my main profile doesn't login due to plasma not loading why ever, i totally forgot that i have a basically empty side profile, which CAN login
 That shifts a few things probably
 I kinda got this habit of having a nano profile when i crashed a few things while kidding windows
[23:27] <tomreyn> My1xT: sorry, got side tracked
 No problem, happens
 Tldr something is happening upon login of my main user that does weird stuff, doesn't happen upon my extra empty nano profile, this is half weird half annoying tbh
[23:28] <tomreyn> My1xT: so, yes, i'd say create a new profile, then shift dotfiles and dot folders around
 But hey it's something
[23:29] <tomreyn> what's left in    apt-forktracer    now?
[23:29] <tomreyn> sudo apt-forktracer | sort | nc termbin.com 9999
 Orphans or all?
 Orphans are only the printer/scanner stuff
 Although lemme reboot another tine
[23:32] <tomreyn> My1xT: i was wondering about all
[23:32] <tomreyn> ok
 Most is php/sury stuff and yubikey related things, gimme a sec
 https://termbin.com/cl82
[23:41] <tomreyn> My1xT: looking
[23:42] <tomreyn> is this grub-customizer specifically for 18.04?
[23:43] <tomreyn> i mean the apt repository line in sources.list(.d/*), does it say "bionic" or "18.04"?
 gimme a sec, not sure but I had it since forever and iirc it doesnt do anything while not running
 basically just a GUI for the grub commands
[23:48] <tomreyn> the thing i'm worried about is not so much what the software does or does not that you have installed from 3rd parties, but which dependencies on other packages they may introduce which can conflict with those in (k)ubuntu proper.
[23:48] <tomreyn> which could then prevent crucial packages from updating (and maybe fixing these issues you see)
[23:49] <tomreyn> that's a theory, though
 I see. it has bionic in the file
[23:50] <kevin1a> Hello fellow Linux enthusiasts.  I recently switched from Budgie to KDE and have been exploring the excellent selection of K* software.  Does anyone have experience with kbackup?  I've had no problems backing up, but I see no option in the GUI for restore?  Is the "official" restore method just to untar the archive in the correct location?
[23:54] <tomreyn> My1xT: okay then we can assume it is meant to be compatible to 18.04.
 ok
[23:56] <tomreyn> My1xT: the version of libifd-cyberjack6 is not one that's available
[23:58] <tomreyn> i guess the rest is fine.
[23:58] <tomreyn> i'd rather assume you have something wrong in a dotfile or dotdirectory in your home now
 possibly, and there's probably no way to find that one in a semi quick way
[23:59] <tomreyn> try a new user account, see whether it works fine
 my secondary account which is basically empty does work