wplate Posted June 17, 2010 Posted June 17, 2010 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.
Raybaudi Posted June 17, 2010 Posted June 17, 2010 Hi are you really on 9 ? generally how many chars are in that text field ?
wplate Posted June 17, 2010 Author Posted June 17, 2010 I am really on 9. There has not been any reason to upgrade. The number of characters will vary, but 50 would be typical.
Raybaudi Posted June 17, 2010 Posted June 17, 2010 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
Kris M Posted June 17, 2010 Posted June 17, 2010 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
wplate Posted June 17, 2010 Author Posted June 17, 2010 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.
Kris M Posted June 17, 2010 Posted June 17, 2010 Once again the definitive solution from Comment... Um.. you spelled realization wrong..
Raybaudi Posted June 17, 2010 Posted June 17, 2010 Oh, yes ! Why not ? : ( ctrl+tab and returns ? ) ... ] ; Case( char = " " ; 9 ; char = ¶ ; 13 ; code + 31 ) & Case ( len > 1 ; ¶ & Codes ( Right ( text ; len - 1 ) ) ) )
comment Posted June 17, 2010 Posted June 17, 2010 Um.. you spelled realization wrong.. I don't think so: http://dictionary.reference.com/browse/realisation
Kris M Posted June 18, 2010 Posted June 18, 2010 Ok i everybody else on the planet spells realization wrong except me! :smirk:
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now