Need help in Syntax

[Me]

How do I extract portion of data from a field delimited by say '/'?

Example if I have - 'abcdef/ijk/efdfdfd' or 'xyz/dfdfd'

I would like to get 'abcdef' in 1st case and 'xyz' in the 2nd case.

Thank you in advance,
-Me

 

[KARL DEWEY]

Left([YourField], Instr([YourField],"/")-1)

 

[MGFoster]

How do I extract portion of data from a field delimited by say '/'?

Example if I have - 'abcdef/ijk/efdfdfd' or 'xyz/dfdfd'

I would like to get 'abcdef' in 1st case and 'xyz' in the 2nd case.

Thank you in advance,
-Me

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Left$() and Instr() functions:

Left$("abcdef/ijk/efdfdfd", Instr("abcdef/ijk/efdfdfd", "/")-1)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSezyo4echKqOuFEgEQJmhQCeOf+3WI+g/g5st3Mkuwwi9ditcg4AoJtr
VYA0/Ud9z1R5io0u9jFg3Ya2
=AUh2
-----END PGP SIGNATURE-----

 

[Me]

Karl,

This works, however I forgto to add that there are records without any "/"
in the data, how do I handle both together?

Like 'abcd/efg' and 'xyzabcedfe'

so I should be able to retrieve 'abcd' and 'xyzabcedfe'.

Appreciate your help!
-Me

Left([YourField], Instr([YourField],"/")-1)

How do I extract portion of data from a field delimited by say '/'?

Example if I have - 'abcdef/ijk/efdfdfd' or 'xyz/dfdfd'

I would like to get 'abcdef' in 1st case and 'xyz' in the 2nd case.

Thank you in advance,
-Me

 

[KARL DEWEY]

IIF(Instr([YourField],"/")<0, [YourField], Left([YourField],
Instr([YourField],"/")-1)

Karl,

This works, however I forgto to add that there are records without any "/"
in the data, how do I handle both together?

Like 'abcd/efg' and 'xyzabcedfe'

so I should be able to retrieve 'abcd' and 'xyzabcedfe'.

Appreciate your help!
-Me

Left([YourField], Instr([YourField],"/")-1)

How do I extract portion of data from a field delimited by say '/'?

Example if I have - 'abcdef/ijk/efdfdfd' or 'xyz/dfdfd'

I would like to get 'abcdef' in 1st case and 'xyz' in the 2nd case.

Thank you in advance,
-Me

 

[John Spencer]

Easy way to to append a slash to the end of the field in the Instr function:

Left([YourField], Instr([YourField] & "/","/")-1)


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Karl,

This works, however I forgto to add that there are records without any "/"
in the data, how do I handle both together?

Like 'abcd/efg' and 'xyzabcedfe'

so I should be able to retrieve 'abcd' and 'xyzabcedfe'.

Appreciate your help!
-Me

Left([YourField], Instr([YourField],"/")-1)

How do I extract portion of data from a field delimited by say '/'?

Example if I have - 'abcdef/ijk/efdfdfd' or 'xyz/dfdfd'

I would like to get 'abcdef' in 1st case and 'xyz' in the 2nd case.

Thank you in advance,
-Me