parsing comma

  • Thread starter Thread starter CShow
  • Start date Start date
C

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
 
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
________________________
 
Thank you;, Gary...It worked
Gary Miller said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top