Parse Latitude and Longitude from Crystal Report Field

[chadd39]

Need to parse Lat and Long from field named {cust.custprob}. See field contents below:

***** REGULAR *****

TIME..13:42 DATE..12/14/2017

REQUEST NO...20175004859

LATITUDE..43.6602240 LONGITUDE..-70.2579034

STATE.........MAINE
MUNICIPALITY..PORTLAND

STREET...MYRTLE ST / CUMBERLAND AVE

NEAREST CROSS STREET 1..


--------------------------------------------------------------------------
NATURE OF WORK..INSTALL WATER VALVE

EXTENT OF WORK
IN THE PAVED INTERSECTION

 

[lbass]

//{@Latitude}:
local stringvar x := {cust.custprob};
trim(extractstring(x,"LATITUDE..","LONGITUDE"));

//{@Longitude}:
local stringvar x := {cust.custprob};
trim(extractstring(x,"LONGITUDE..",CHR(13)));

This should work as long as the rows end with a return. If they end with a line feed, try chr(10);

-LB