Hi all,
I have a list of POI names that I'd like to abbreviate using an a Excel file that contains the keywords.
I only like to abbreviate the words found in the string that match with the keywords - not the whole string.
Basically what a StringReplacer does, but in bulk.
Thanks,
Eduard
Best answer by takashi
View original
+17
I found two ways.
1. Decompose, replace words if necessary, re-construct the name.
2. Use a Tcl command.
proc replace {} {
return [string map [FME_GetAttribute "_pair"] [FME_GetAttribute "POI_NAME"]]
}
I found two ways.
1. Decompose, replace words if necessary, re-construct the name.
2. Use a Tcl command.
proc replace {} {
return [string map [FME_GetAttribute "_pair"] [FME_GetAttribute "POI_NAME"]]
}
I found two ways.
1. Decompose, replace words if necessary, re-construct the name.
2. Use a Tcl command.
proc replace {} {
return [string map [FME_GetAttribute "_pair"] [FME_GetAttribute "POI_NAME"]]
}
Looking good!
Is there a way to make these transformers not case sensitive? E.g. "Museum" is abbreviated to "Mus." which is good, but "museum" is not affected.
+17
Looking good!
Is there a way to make these transformers not case sensitive? E.g. "Museum" is abbreviated to "Mus." which is good, but "museum" is not affected.
+17
I found two ways.
1. Decompose, replace words if necessary, re-construct the name.
2. Use a Tcl command.
proc replace {} {
return [string map [FME_GetAttribute "_pair"] [FME_GetAttribute "POI_NAME"]]
}
{
"washington" : "Wash.",
"square" : "Sq.",
"museum" : "Mus.",
"street" : "St.",
"church" : "Ch."
}
{|
fme:process-features("SUB")
|}
{
fn:lower-case(fme:get-attribute("FULL")) : fme:get-attribute("ABBR")
}
var dict = JSON.parse(fme_get_attribute('_dictionary'));
var src = fme_get_attribute("POI_NAME").split(' ');
var dest = []
for (var i = 0; i < src.length; i++) {
var abbr = dict[src[i].toLowerCase()];
dest.push(abbr ? abbr : src[i]);
}
fme_set_attribute('POI_SHORT_NAME', dest.join(' '));
{
"washington" : "Wash.",
"square" : "Sq.",
"museum" : "Mus.",
"street" : "St.",
"church" : "Ch."
}
{|
fme:process-features("SUB")
|}
{
fn:lower-case(fme:get-attribute("FULL")) : fme:get-attribute("ABBR")
}
var dict = JSON.parse(fme_get_attribute('_dictionary'));
var src = fme_get_attribute("POI_NAME").split(' ');
var dest = []
for (var i = 0; i < src.length; i++) {
var abbr = dict[src[i].toLowerCase()];
dest.push(abbr ? abbr : src[i]);
}
fme_set_attribute('POI_SHORT_NAME', dest.join(' '));
This seemed to be good solution for my problem, until I found out that JavaScriptCaller is deprecated. Is there replacement for this JavaScript code?
+21
@bazooka You can do something with python
import fme
import fmeobjects
def insert_abbreviations(feature):
dictionary = dict(zip(feature.getAttribute('_list{}.FULL'),feature.getAttribute('_list{}.ABBR')))
poi = feature.getAttribute('POI_NAME')
words = poi.split()
words = [dictionary.get(w.upper(),w) for w in words]
feature.setAttribute("abbreviated"," ".join(words))
*There are more efficient ways to build the dictionary than feature merging the list, but this is the simplest to demonstrate
@bazooka You can do something with python
import fme
import fmeobjects
def insert_abbreviations(feature):
dictionary = dict(zip(feature.getAttribute('_list{}.FULL'),feature.getAttribute('_list{}.ABBR')))
poi = feature.getAttribute('POI_NAME')
words = poi.split()
words = [dictionary.get(w.upper(),w) for w in words]
feature.setAttribute("abbreviated"," ".join(words))
*There are more efficient ways to build the dictionary than feature merging the list, but this is the simplest to demonstrate
Thank you @ebygomm !
I am now 1 step closer to solution. In my case there are multiple words which needs to be changed. For example "Omena (Banaani-Appelsiini)" -> "Apple (Banana-Orange)". Now only 1st one is changed, in this case 'Omena' -> 'Apple' and the whole thing "Omena (Banaani-Appelsiini)" -> "Apple (Banaani-Appelsiini)". I don't have Python coding skills, so I don't know how to change code to solve this.
I also don't need uppercase. I tried to change
words = [dictionary.get(w.upper(),w) for w in words]
not to use uppercase, but I was not successful.
if i have number of words like Network and Net i need to change Net as Pet but it changes Network also as Petwork like below
OriginalNeedWorking like thisNetworkNetworkPetworkNetPetPet
Note: need to replace number of Words at time like StringPairReplacer Transformer.
+11
This seemed to be good solution for my problem, until I found out that JavaScriptCaller is deprecated. Is there replacement for this JavaScript code?
Hi @bazooka, It looks like Takashi proposed two different solutions here. Does the first one with the TclCaller work for you? That one doesn't seem to use the JavascripCaller. If that doesn't work for you, would you be able to post a new question and link this one to it for context?
I almost overlooked your new comment thinking that this Q&A was already resolved, so posting a new one will up the visibility of your question to get more useful answers! Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
