Skip to main content
Solved

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.

  • February 14, 2022
  • 3 replies
  • 13 views

luukvis
Participant
Forum|alt.badge.img+2

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

 

Best answer by ebygomm

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

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

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • Best Answer
  • February 14, 2022

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


luukvis
Participant
Forum|alt.badge.img+2
  • Author
  • Participant
  • 1 reply
  • February 14, 2022

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 


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • February 14, 2022

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