AnsweredAssumed Answered

Parsing out "," in numbers.

Question asked by bigtom on Dec 9, 2013
Latest reply on Dec 9, 2013 by philmodjunk

Title

Parsing out "," in numbers.

Post

     So with the database I am moving from Bento to FM12, I ran across the glorious use of thousands separators in Bento. It seems that fields set as numbers all got these. I have a great many number fields such as SNs and Model numbers and other numbers that should not have these commas in them. I can turn them off in basic display but on field entry they show up and on output they show as well.

     Is there a quick way to fix this or do I need to work through a parsing script to get this done. FM12 seems to handle this situation fine for new entries but the  imported ones are the trouble.

Outcomes