2 Replies Latest reply on Apr 6, 2011 4:57 AM by g6mbv

    Remove spaces and non standard characters from a calculated field




      I'm fairy new to Adobe forms scripting, but I've managed to get by so far. I'm currently working on a form that we send out to suppliers to set them up in our systems.


      One of the fields is called "Organisation Name", this has a custom format script which changes the entered text to uppercase on field exit:


      event.value = event.value.toUpperCase();


      I have a hidden field "Clean Organsation Name" which is a calculated organistion code that we use to identify the organisation within our systems (which can only use letter characters). I need "Clean Organisation Name" to be a calculation of "Organisation Name" with all spaces and non-standard characters removed ( ", ()[]@$'&.....etc).


      Could someone help me out with this?


      Many thanks in advance