Skip to Content
0
Former Member
Mar 18, 2009 at 06:50 PM

Pull Left of 1st Space

21 Views

I'd like to pull whatever is to the left of the first space, but it may not always be numeric or text.

I tried using:

LEFT({cm04.CM04_ADD2},INSTR({cm04.CM04_ADD2}," "))

but it doesn't work.

It's really for addresses. Sometimes I will have something like "123 Main St" while other times I may have entries like "36W497 W 83rd St"

All I know is I want everything to the left of that 1st space.