ammiewinds
asked on
Parse a String Multiple Times
Hello,
I have a field that is designed as follows:
??/#######/????????/###### ##/???
I would like to parse the field based on the "/". The field is not alway consistant, so I would like to have the complete string show in the first parse, if the "/" is not available.
I have been tring the Left$ function:
Left$([Field Name],InStr(2,[Field Name],"/")-1)
This was able to bring in the first part. Yet it gives me an error of "Func!" if the "/" is not in the string and I have not been successful in tring to retrieve the second portion.
Any help would be greatly appreciated.
I have a field that is designed as follows:
??/#######/????????/######
I would like to parse the field based on the "/". The field is not alway consistant, so I would like to have the complete string show in the first parse, if the "/" is not available.
I have been tring the Left$ function:
Left$([Field Name],InStr(2,[Field Name],"/")-1)
This was able to bring in the first part. Yet it gives me an error of "Func!" if the "/" is not in the string and I have not been successful in tring to retrieve the second portion.
Any help would be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so very much! Now I'm happy I joined the club.
Jumping up and down!!!
Jumping up and down!!!
dim myarray
myarray= split(fieldname, "/")
'first value myarray(0), then myarray(1) etc