View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default Extract Double from a Textfield Cell

(-89,113) ?
Are there any other possible layouts?,
like say
(89,113)
(189,-113)
(-89,-113)
Just curious...
TIA

"Firen" wrote in
message ...

Hi guys!

Could anyone tell me how to extract the coordinates from a plain data
like this:

- Zorgia [NBK-R] (-89,113) Defending -

and save them into a double A(x,y) (e.g. A(-89,113)).


This is what i think should be the procedu
Find the brackets "(" and ")" and save everything in between into a
string (?). Then in the string find "," and everything to the left = x
and everything to the right = y.

Thanks in advance,
Firen


--
Firen
------------------------------------------------------------------------
Firen's Profile:
http://www.excelforum.com/member.php...o&userid=26624
View this thread: http://www.excelforum.com/showthread...hreadid=399006