Ask Your Question
0

deleting numbers and text with expressions (need little help)

asked 2018-10-10 08:32:49 +0200

Knightwolf gravatar image

updated 2018-10-10 09:01:55 +0200

i have text like this +55056 active Aug. 20, 2018 492 commentsonbannna +52206 active Aug. 20, 2018 796 commentsonapples +36475 active Aug. 20, 2018 1008 commentsonpears now i was trying and failing to create a expression to delete from + all the way to comments leaving the rest out, i can use normal replace to delete (active Aug. 20, 2018) & (1008 comments)which leaves me on just +36475 onpears which i can also do and delete just the (+#####). mainly i'm just trying to get rid of the +00000 but i'm doing large spreadsheet so it would take me a few weeks by hand.

any help will be appreciated and thanks.

edit retag flag offensive close merge delete

Comments

1

You put base into tags; but mention "spreadsheet"? what is the real component?

Mike Kaganski gravatar imageMike Kaganski ( 2018-10-10 08:56:06 +0200 )edit

i don't even know what base means for some reason it's require of one of the 4 choices. i wasn't actually going to add those because my question ha nothing to do with those.. base i guess common would fit?

Knightwolf gravatar imageKnightwolf ( 2018-10-10 08:58:39 +0200 )edit
1

what application in the suite (Calc, Writer, Impress, Draw, Base, Math) are you using?

Mike Kaganski gravatar imageMike Kaganski ( 2018-10-10 09:03:38 +0200 )edit

@Knightwolf, It sure would be helpful to YOURSELF to take the time to write a much better question. First learn to use line breaks and formatting, instead of writing one long run-on sentence. Next get rid of "(need a little help)" it's redundant. Clearly say what you are using, start with what OS you're running on, say what version of LO you're using, figure out how to answer Mike's question about Calc, Writer, etc. Show us that you're trying, and you're more likely to get better help here

EasyTrieve gravatar imageEasyTrieve ( 2018-10-10 22:30:29 +0200 )edit

Is that text in one cell? Or is it individual cells with +##### ... commentson... each? What exactly do you want to delete? All text +##### ... but leaving the commentson... intact?

erAck gravatar imageerAck ( 2018-10-11 17:39:49 +0200 )edit

I'm using multi coloms i'm not a beginner in spreadsheets but i'm also not advance user. to the point i know i can do graphs and such but expressions and such i'm pretty basic https://imgur.com/a/QvfjGEn I mainly want the green gone but i can get the rest of the red out bymyself

As for EasyTrieve he should know already that i'm bad at writing questions but ill be nice saying windows 10 latest open office update. although i should just ignore him.

Knightwolf gravatar imageKnightwolf ( 2018-10-12 00:31:56 +0200 )edit

ok thanks i was trying \D["+"]\d+ & +\d

Knightwolf gravatar imageKnightwolf ( 2018-10-12 20:17:39 +0200 )edit

@Knightwolf, "windows[sic] 10 latest[sic] open office[sic] update". Ok, that's a good start in the right direction. Note that Open office is different than Libre Office, and this forum is for Libre Office, although both are mostly the same. As to ignoring my comment, I will say this: I have the greatest respect for people here, especially those who are answering questions and providing feedback to questions. I think the same perspective would be good for you to have too, but it's your choice.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-12 20:32:27 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-12 07:26:24 +0200

Mike Kaganski gravatar image
  1. Select the columns (just to avoid accidental removal of matching pattern in other cells, however unlikely).
  2. Use regular expressions, and replace ^\+\d{5} active .+ \d+ comments(?=\w) in current selection (check relevant checkboxes in Find & Replace dialog).

As for EasyTrieve he should know already that i'm bad at writing questions ...

Unfortunately, it's not well-known that being good in asking good questions is just as important as learning how to read.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-10 08:32:49 +0200

Seen: 33 times

Last updated: Oct 12