I would like to search a string for the text (example HIGHWAY1 & HIGHWAY6 or HIGHWAY11 and replace it with 1 HWY & 6 HWY or 11 HWY)
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
+6- Safer
You could also use a ReplaceText mode StringReplacer,although @david_r regular expression works just as well.
Here is an example using the Replace Text mode if you wish:
trentatsafe wrote:
You could also use a ReplaceText mode StringReplacer,although @david_r regular expression works just as well.
Here is an example using the Replace Text mode if you wish:
david_r wrote:
Try this in a StringReplacer:
Than you david_r I used your suggestion and I was able to get the results I was looking for.
david_r wrote:
Ah, I understood it as if the attribute would contain either "HIGHWAY1" or "HIGHWAY6", not the complete string "HIGHWAY1 & HIGHWAY6 or HIGHWAY11". Different approach :-)
david_r wrote:
Try this in a StringReplacer:
2 questions!
1)
Can you please reference a page or link to better understand the expression/script being used here to <find the characters at the end of the HIGHWAY> (\\d+) and <insert those characters at the beginning of the replacement text> \\1 ?
2)
I'm curious also about the scenerio say:
I have a list of name and file path and I want to update the file path names in that list, so find characters within a list update a portion of that string... i.e:NamePathFile_1C:\\FMEData2019\\Output\\File1.txt
File_2C:\\FMEData2019\\Output\\File2.txt
etc..
and find the characters
"C:\\FMEData2019"
and change/replace to:
"C:\\FMEData2020"
The final output being:
The only portion of the path being changed is the first portion of the path
NamePathFile_1C:\\FMEData2020\\Output\\File1.txtFile_2C:\\FMEData2020\\Output\\File2.txt
(Not looking for all the readers and such, asking just about how the expression might work)
Thoughts? Thanks!
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.