parsing comma

[CShow]

I have the following text field on my report

"Two Tower Center, property 1133 --1134"

How can I parse out the comma so this text can read:

"Two Tower Center"

Thanks

 

[Gary Miller]

Do you really mean how can you return everything to the left
of the comma as your example shows?

Left([YourFieldName],InStr([YourFieldName],",")-1)

This says return everthing on the left side up to the
position of the comma - 1 position.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[CShow]

Thank you;, Gary...It worked

Do you really mean how can you return everything to the left
of the comma as your example shows?

Left([YourFieldName],InStr([YourFieldName],",")-1)

This says return everthing on the left side up to the
position of the comma - 1 position.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

I have the following text field on my report

"Two Tower Center, property 1133 --1134"

How can I parse out the comma so this text can read:

"Two Tower Center"

Thanks