+8
Hi
I've looked at this several times but cant see a solution ... can anyone help?
I have value(s) being pulled into a text box which is coming from an external system
1;#IT;#5;#Test List;#6;#Another List;#4;#test List 2
I need to try and reformat this field so that only the numbers and semi-colons are retained as I want to pass these to a check-box list
So for example:
1;#IT;#5;#Test PS;#6;#Another List;#4;#test
needs to be converted into
1;5;6;4;
Any ideas?
thanks
Paul
+9
Paul
There is no straight forward method for acheiving this. The best that I can guess would be if you know what the general content of the values are going to be. If you do, you may be able to use replace to remove all of the excess data and replace it with blank space or something else. Besides that, you are likely going to have to use a custom SmartObject.
Ian
+8
Ian
Thanks for reply.. as I thought it not's that easy.
Do you know if there is easy way via a function to strip out all the text from a source field thus only leaving the numbers.
If I could do that I may be able to work with something.
regards
Paul
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
