Scraping partial text from cell

[Tommy62]

Hi,

I have a listing from a folder structure.

Formula to get the first 5 responses: =MID(LEFT(B2,FIND("/",B2)-1),FIND("ac",B2),LEN(B2))

Formula for the remaining 5 responses: =MID(LEFT(B7,FIND("/",B7)-1),FIND("^[A-Z]*[0-9]*",B7),LEN(B7))

So, the second formula is a modification of the first formula, attempting to use regex to recover the text.
What I am trying to achieve is to return the text from the start of the cell up to and not including the first “/”.

LO Function Wizard shows the structure.

The above listing is from a Linux folder search, for reference: sudo apt list --installed >> ./filename.log

I would like to understand the correct formula and why =mid() is returning #VALUE! for the second formula.

Is there a better solution?

Many thanks,
Tommy.

[anon73440385]

Screenshot are really hard to analyze errors and even harder to develop a working solution. Could you please upload a sample file?
If yes - please use edit and the paper clip symbol to upload a file. Do not use Add Answer, since answers are reserved for solutions to a problem.

[anon73440385]

Hello

From my point of view: =REGEX(A2;".+(?=/)") is what you are looking for.

Hope that helps.

[Tommy62]

@anon73440385: Genius, thank you . Works a treat.

Tommy.