Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Hey community, i am trying to do some exceldata conversion in FME that my coworkers used to do manually. Now i am at a point that they used a excel macro to add periods to initials ( AB => A.B.). ofc the length of initials differs.

in the original some initial alread had periods, but i already removed them with a stringreplacer.

 

Any leads on how to tackle this are welcome.

 

Luuk

 

One possible way

 

Stringsearcher to get a list of characters, followed by a stringconcatenator to concatenate the list back to a string with periods

 

image

One possible way

 

Stringsearcher to get a list of characters, followed by a stringconcatenator to concatenate the list back to a string with periods

 

image

Thanks this helped a lot.

 

I might have missed something on your answer because i seemed to lack a point at the end. But i fixed that with another stringreplacer adding a period.

 

 

afbeelding 

Thanks this helped a lot.

 

I might have missed something on your answer because i seemed to lack a point at the end. But i fixed that with another stringreplacer adding a period.

 

 

afbeelding 

I'd missed that you wanted the period at the end as well. In which case you could do it all within a stringreplacerimage 

 

Reply


Community Stats

30,171
Posts
114,537
Replies
37,834
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.