LPW LPW 21.5: Last Paster Wins

[Nicholas]

I have a string in the following format:
12346789/2/2021

I would like to extract the number before the first slash.

/Fetches a pair of scissors. Cuts the string.

 

[Tribs]

I have a string in the following format:
12346789/2/2021

I would like to extract the number before the first slash.

Why not just use the Left function? =Left(the cell containing the text, find("/", the cell containing the text, 1)-1)

 

[Lara]

SELECT LEFT('123456789/2/21', INSTR(1,'123456789/2/21','/') -1)

When I specify the the start position for InStr it returns an error.

Swift412 helped me on another forum.

 

[Lara]

Matters of the mind are not necessarily easily changed.

Like habits?

 

[Lara]

/Fetches a pair of scissors. Cuts the string.

My screen wont like it one bit.

 

[Lara]

Why not just use the Left function? =Left(the cell containing the text, find("/", the cell containing the text, 1)-1)

The number differs in length. Cant use Right either because the month differs in length too.

ps. Access doesn't have a Find function.

 

[Nicholas]

Like habits?

Yes. Not everyone breaks them easily, especially not when one's default mode is automaton.

 

[Nicholas]

My screen wont like it one bit.

Sacrifices may have to be made.

 

[Nicholas]

The number differs in length. Cant use Right either because the month differs in length too.

ps. Access doesn't have a Find function.

In Access, is anything ever truly lost?

 

[Nicholas]

The number differs in length. Cant use Right either because the month differs in length too.

ps. Access doesn't have a Find function.

Send these non-conforming bits of string back, and insist on having all of your string cut to a standard length.

 

[Lara]

Yes. Not everyone breaks them easily, especially not when one's default mode is automaton.

Instinct usually provides the correct choice.

 

[Lara]

Sacrifices may have to be made.

Crisis was averted. I do not subscribe to medieval rituals.

 

[Nicholas]

Instinct usually provides the correct choice.

Sometimes.

 

[Lara]

In Access, is anything ever truly lost?

Delete have a funny way of hiding it very well.

 

[Lara]

Sometimes.

No , no. Most of the time. Nature knows best.

Google shouldn't read this post or I'm in trouble.

 

[Nicholas]

Crisis was averted. I do not subscribe to medieval rituals.

/Slowly and reverently returns The Sacred Shears to their jewel-encrusted reliquary.

 

[Nicholas]

No , no. Most of the time. Nature knows best.

Google shouldn't read this post or I'm in trouble.

Parasites, damaged genes, maladaptive behaviour, heterotrophy, poisons....
Yup. Red in tooth and claw.

 

[Lara]

Parasites, damaged genes, maladaptive behaviour, heterotrophy, poisons....
Yup. Red in tooth and claw.

Sometimes nature goes to extremes to thin a herd.

 

[Lara]

Before I go completely overboard I'll stop pasting for now. Ciao everybody and sleep well.

 

[Quetzalovercoatl]

Be positive, get COVID.