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
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.
+1Best 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
+39- Influencer
- Best Answer
One possible way
Stringsearcher to get a list of characters, followed by a stringconcatenator to concatenate the list back to a string with periods
+1ebygomm wrote:
One possible way
Stringsearcher to get a list of characters, followed by a stringconcatenator to concatenate the list back to a string with periods
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.
+39- Influencer
luukvis wrote:
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.
I'd missed that you wanted the period at the end as well. In which case you could do it all within a stringreplacer
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.