I am working on a project where I need the ASCII value for every character in the text field. For example I need to convert

some text

to

115

111

109

101

32

116

101

120

I found this handy custom function for getting the ASCII character value , but I'm having a hard time getting my mind around how to loop through each character in the text field in order to perform the replace.

Thanks.

Hi

are you really on 9 ?

generally how many chars are in that text field ?

I am really on 9. There has not been any reason to upgrade.

The number of characters will vary, but 50 would be typical.

There has not been any reason to upgrade

These are good reasons to upgrade: triggers ( instead of the button that you'll see in my example ) and the Code ( ) function ( that you have to substitute with the Theo Ros's CF ).

BTW: give a try to my example.

Text2Ascii.zip

Just an untested idea in the attachment but this might work. Their is only a script in this file. Hope it either provides some direction or a laugh. I'm sure someone could come up with a recursive way to do it...

test.zip

And why not a custom function?

ASCIIcodesCF.zip

Thank you for the example project, it certainly looks like it does the trick! I'll play with it and see if it will work.

Once again the definitive solution from Comment...

Um.. you spelled realization wrong..

Oh, yes ! Why not ? :

( ctrl+tab and returns ? )

...

] ;

Case( char = "	" ; 9 ; char = ¶ ; 13 ; code + 31 )

&

Case ( len > 1 ; ¶ & Codes ( Right ( text ; len - 1 ) ) )

)

Wow, comment, thank you! That's even better!

Um.. you spelled realization wrong..

I don't think so:

http://dictionary.reference.com/browse/realisation

Ok i everybody else on the planet spells realization wrong except me! :smirk:

Both are correct.