Login

u/SKARDAVNELNATE

r/computerhelp r/LibreOfficeCalc r/BasedCampPod
▲ 1 r/LibreOfficeCalc

Using Find & Replace to restore line breaks

I copied some information into a spreadsheet. Some of the cells take up multiple lines.

Such as
Item 1
Item 2
Item 3
in one cell

However these look more like "Item 1 " on each line. I used Trim() to remove extra spaces.

"Item 1"

Now I have one column that is wrong and one that is corrected. I want to replace the wrong column with the corrected column. So I cut the corrected column and paste it as Unformatted Text. This makes the function into text, but it also removes the line breaks.

Such asItem 1Item 2Item 3in one cell

I undo then use Find & Replace to change all line breaks into @ symbol. Cut and paste as Unformatted Text again to make the function text.

Such as@Item 1@Item 2@Item 3@in one cell

Now I need to change the @ symbol back into a line break but nothing I have looked up is working as it's described.

reddit.com
u/SKARDAVNELNATE — 1 day ago
▲ 2 r/computerhelp

Ram or CPU has gone bad?

I've been having trouble installing games that I bought on GOG. They would pass the integrity check, then say that a part is corrupted and I should run the integrity check in the installer. On the next attempt one would fail and need to be download again. I thought the HDD I had them saved to was having problems so I started using a different drive. It continued.

Looking at the results from MemTest I'm worried that 2 cores on the CPU are bad.

u/SKARDAVNELNATE — 2 months ago
▲ 8 r/BasedCampPod

I don't see a discussion thread for Friday's video so I'll post a few thoughts here.

I have Pragmata in my Steam wishlist. I'm waiting for either a large sale or a release on GOG. I want to explore a futuristic space station and fight robots. That's the appeal for me. I'm not drawn to the parenting sim but the question is more, do I mind that it is there, and does it detract from the exploring and fighting. If I wind up enjoying that aspect and it adds to the experience then even better.

The character design:

Diana is an android. I thought there was suppose to be something unnatural about her appearance. Detroit: Become Human has the glowing circle to tell human and android characters apart. Pragmata has slightly creepy children androids.

The Mary Morgan reaction:

I'm reminded of the 2015 TV series "Humans" which ran for 3 seasons. One of the android characters is being interrogated to see if she is self aware. A point made in that scene is: we're trying to determine if she thinks, not if she thinks like us.

The paternal instinct is different from the maternal instinct. Mary Morgan is basing whether men have a paternal instinct on it being similar to the maternal instinct. And since they aren't alike men must not have one.

The Hasan Piker reaction:

He doesn't seem to understand what gaming is about. I'm never going to travel to Mars and fight demons but I like Doom. I'm never going to train and command my own army but I can in just about any RTS game. I'm not an immortal with amnesia but I can play as one in a surprising number of RPGs. Sure, people can play games that reflect their own life but a large part of gaming is also about doing things you either can't or won't experience in real life.

u/SKARDAVNELNATE — 2 months ago