Skip to main content
Question

delete data from cells

  • July 27, 2020
  • 3 replies
  • 17 views
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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • July 28, 2020

Hi @theunderwood07

I suggest you this KML Balloon Contents.

There is a example to use a image into KML.

 

Thanks in Advance,

Danilo

Partner Solutial Brazil - www.solutial.com.br
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
Celebrity
  • takashiCelebrity
  • 7843 replies
  • July 28, 2020

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
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,071
Posts
121,786
Replies
39,700
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.