Skip to main content
Solved

Grid Column to Letter

  • March 14, 2022
  • 4 replies
  • 27 views

deanhowell
Influencer
Forum|alt.badge.img+24

I have a layer that was created with the tiler transformer and rather than column (0 - n) I want to covert them to an alpha equivalent i.e. 0 => A, 25 => Z, 26 => AA etc

 

Does anyone have a approach for this please?

Best answer by ebygomm

You could also use a character code replacer to convert

 

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.

4 replies

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • March 14, 2022

StringPairReplacer should do this for you.

You have to provide the replacement pairs separated by spaces.


deanhowell
Influencer
Forum|alt.badge.img+24
  • Author
  • Influencer
  • March 14, 2022

StringPairReplacer should do this for you.

You have to provide the replacement pairs separated by spaces.

Thanks @caracadrian​ i think that could work nicely cheers Dean ​


ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • Best Answer
  • March 14, 2022

You could also use a character code replacer to convert

 

image


deanhowell
Influencer
Forum|alt.badge.img+24
  • Author
  • Influencer
  • March 14, 2022

You could also use a character code replacer to convert

 

image

Thanks @ebygomm​ you are a champion ​