Question

points from coords in a text file

  • 11 January 2013
  • 3 replies
  • 3 views

Badge
Hi, I’m trying to generate points from a text file, using Lat & Long values.  StringSearcher seems to be the right transformer but I’m having trouble figuring out the proper expression to use.  Any help would be appreciated.

 

 

The contents of the text file:

 

 

From: bcticket@telus.net Sent: Wednesday, January 09, 2013 12:58 PM To: GIS Subject: Request 2013021114   01/09/13  12:57:20 BC ONE CALL NOTICE OF INTENT TO EXCAVATE            REASON CODE: ROUTINE LOCATE     Ticket No: 2013021114         Sending to:SQUISH01         Code:SQUISH01                   Sequence:0002   Original Call Date: 01/09/2013             Time: 12:53:02       Op: 442 Transmit      Date: 01/09/2013             Time: 12:57:20       Op: 442 Work To Begin Date: 01/14/2013             Time: 12:53:00      Company     :HOMEOWNER Contact Name:Test                   Contact Phone:(111)111-1111                                             Cell    Phone:                                                             Pager        :                  Alt. Contact:                              Alt.    Phone:                                                             Fax     Phone:                  Email:gmmorgan@shaw.ca   Place    :SQUAMISH Comments : Address At/From:2114        Address To: Street: RIDGEWAY CRES Nearest Intersecting Street : GARIBALDI WAY   Second Intersecting Street  :  Latitude: 49.74068850     Longitude: -123.12740700   Additional Dig Information: PUB/PVT RES PROP - PROP LI/FRT                       Remarks:   Type of Work: SEWER REPAIR DEPTH  :1.07 Mtrs    LENGTH :Unknown      WIDTH  :Unknown      Private Property: Yes     Dig Area Marked: No      Machine Dig: Yes Public Property:  Yes     Planning/Design: No      Hand Dig :   Yes Work being done for: HOMEOWNER   Also notified :           -FORTISBC - GAS      -BC HYDRO DIST       -TELUS                  Legend: -C = Cleared       -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be  clean.      

 


3 replies

Userlevel 4
Badge +13
Hi,

 

 

Using the expression provided by takashi (beautifully done takashi!), you can use the stringsearcher directly, this will result in two matched parts that can be directly used by the 2Dpointreplacer.
Userlevel 2
Badge +17
Bravo, Itay! Thank you for completion.
Badge
Thanks very much.  I'll give it a try!

Reply