Splitting Numbers before /

[senn2912]

Hi All,



Can someone please help?

I am trying to split out some number fields before a / but the difficulty i am having is that the number fields can vary from one a double number symbol to maybe one number symbol.

For example:

if it says 15/05 then i wanto to only show just 15

or

if its just 5/05 then to show just 5

Hope this makes sense.

Thanks in advance,

Gary

[RuralGuy]

Show us the total string that is in this field, please. i.e.: 'This is the total string 5/05'

[senn2912]

05/5
6/12
4/05
12/03

Above is the string that i want to split.

In one field of the query i want to return everything before / and then another field i want to return everything after the /.

Hope that makes sense.

[RuralGuy]

Try this function or some variation of it.

Function Extract(strIn As String, TheLeft As Boolean) As String
'-- Return the characters either prior to or after the "/" in strIn depending on TheLeft
   strIn = Trim(strIn)
   If TheLeft Then
      Extract = Left(strIn, InStr(strIn, "/") - 1)
   Else
      Extract = Mid(strIn, (InStr(strIn, "/") + 1))
   End If
End Function