Hi, just curious - under what conditions would one get numerical data that has special characters like that? Is that a function of exports from certain databases?
David David Durling University of Georgia > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Tuesday, November 06, 2012 8:32 AM > To: [email protected] > Subject: Re: Real Number Format Issue > > Allan, > As Misi described, I have also had this requirement, and had to use a Char > field to do the manipulation in question. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Allan See > Sent: Monday, November 05, 2012 11:38 PM > To: [email protected] > Subject: Real Number Format Issue > > Hi, > > I am trying to remove special character($,%,&, etc.) on a real number field. > So what happens is that when i input a value all characters after the special > character are turned to 0 > > here is an example: > 123.2&5 --> 123.200 > > what i wanted was the the '&' sign be removed but not replace the 5 with a 0. > 123.2&5 --> 123.205 > > is there a way we can filter this out for the real number field? or do you > have > any alternative to filter this? > > Thanks, > Allan > > __________________________________________________________ > _____________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > __________________________________________________________ > _____________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
