Hello everyone, is there any way how to generate next letter of alphabet? E.g I have feature with value "A" and I wanna generate next letter in alphabet, so letter "B". Is there any function for that?
Thanks a lot!
Lubo
Solved
How to generate next letter of alphabet?
+7- Contributor
Best answer by david_r
You can use the CharacterCodeExtractor to convert the letter to an integer value, increment the value with an ExpressionEvaluator, then convert it back to a letter using the CharacterCodeReplacer.
For reference, you're incrementing over the Unicode symbols, see https://symbl.cc/en/unicode/table/
The value below each symbol in hexadecimal, e.g. "A" = 41 hex = 65 decimal
- Best Answer
You can use the CharacterCodeExtractor to convert the letter to an integer value, increment the value with an ExpressionEvaluator, then convert it back to a letter using the CharacterCodeReplacer.
For reference, you're incrementing over the Unicode symbols, see https://symbl.cc/en/unicode/table/
The value below each symbol in hexadecimal, e.g. "A" = 41 hex = 65 decimal
1 person upvoted this
+54
david_r wrote:
You can use the CharacterCodeExtractor to convert the letter to an integer value, increment the value with an ExpressionEvaluator, then convert it back to a letter using the CharacterCodeReplacer.
For reference, you're incrementing over the Unicode symbols, see https://symbl.cc/en/unicode/table/
The value below each symbol in hexadecimal, e.g. "A" = 41 hex = 65 decimal
Nice! Learned something new today :)
+50- Evangelist
nielsgerrits wrote:
Nice! Learned something new today :)
Me too, I was looking into a much more complicated solution 😄
+7- Contributor
david_r wrote:
You can use the CharacterCodeExtractor to convert the letter to an integer value, increment the value with an ExpressionEvaluator, then convert it back to a letter using the CharacterCodeReplacer.
For reference, you're incrementing over the Unicode symbols, see https://symbl.cc/en/unicode/table/
The value below each symbol in hexadecimal, e.g. "A" = 41 hex = 65 decimal
Great solution! I have known just NumToAlpha Converter (https://hub.safe.com/publishers/pacific-spatial-solutions/transformers/numtoalphaconverter), but Your solution is perfect for my usecase. Thank You so much @david_r !
+55- Celebrity
david_r wrote:
You can use the CharacterCodeExtractor to convert the letter to an integer value, increment the value with an ExpressionEvaluator, then convert it back to a letter using the CharacterCodeReplacer.
For reference, you're incrementing over the Unicode symbols, see https://symbl.cc/en/unicode/table/
The value below each symbol in hexadecimal, e.g. "A" = 41 hex = 65 decimal
@david_r thats a really cool approach. I was about to ask how do you think you'd solve the wrap around when you get to 'Z' and you then want to have 'AA'. But thinking about it you could keep incrementing and use fmod() to figure out what the second char should be
hkingsbury wrote:
@david_r thats a really cool approach. I was about to ask how do you think you'd solve the wrap around when you get to 'Z' and you then want to have 'AA'. But thinking about it you could keep incrementing and use fmod() to figure out what the second char should be
To be honest I'd probably do that part in Python ;-) There are some possible starting points here: https://stackoverflow.com/questions/42176498/repeating-letters-like-excel-columns
But yes, you could probably also do it in FME combining modulo and integer division, but I suspect it would be somewhat involved unless you do it in a looping custom transformer.
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.