Splitting a string at a space or hyphen

G

Guest

I am using the following expression in query builder to create a new column
showing a substring of everything to the right of the last space in the
description.

Mid([Describe],(InStrRev([Describe]," "))+1)

This works fine, until I discovered some of the descriptions might contain
either a space OR a hypen. Is there anyway to use this expression with
either a hyphen or a space.
 
A

Allen Browne

Use Replace(), e.g.:

Mid([Describe],(InStrRev(Replace([Describe], "-", " ")," "))+1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need SUBSTRING like function 3
Finding the space in a text string and returning text on either si 8
Soft hyphen 3
TRIM function with fixed length field 5
Extracting (Copying) Text to the Right of a Hyphen 3
Filter Records with a space at the beginning 3
hyphen in regular expression (cSharp) 5
How do I keep two words together with a space or hyphen? 1

Top