Question

delete data from cells

T

I am using a KML file exported from a GPS device and using FME I have have translated the KML to excel. I want to use a transformer to remove the extra text in the cell that I don't need and retain the text that I do need to conduct a match to the image file. Example below shows the italic text is the text to be removed and the bold text is the text to be retained

Cell

<a href='images/insphere/14325921-964c-4024-b002-8cb1549f232d.jpg'><img src='images/insphere/14325921-964c-4024-b002-8cb1549f232d.jpg' width='250'/></a>

Image fiile

14325921-964c-4024-b002-8cb1549f232d.jpg

3 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @theunderwood07

I suggest you this KML Balloon Contents.

There is a example to use a image into KML.

 

Thanks in Advance,

Danilo

T

Hi, that was usefull, but what I am really chasing @Danilo is in the translation from KML to csv how do I remove the reference data path. I have the image files in the same location as the KML & csv. I was hoping to find a way to tidy up the csv output feild to match the photo image name.

 

takashi
Rank
Userlevel 2
Badge +17

Hi, @theunderwood07, a possible way I can think of is to use the StringReplacer with Replace Regular Expression mode.

  • Mode: Replace Regular Expression
  • Text to Replace (regular expression): .+(?<=src=)'.+/(.+?)'.+
  • Replacement Text: \\1

Reply


Community Stats

28,661
Posts
109,324
Replies
36,528
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.