I thought you could simply replace it with nothing, but it appears to not work (no longer work?) this way. The transformer won't accept a blank replacement value.
What you can do is create a dummy attribute that is null (contains nothing). Then use that as the replacement value. That works OK for me. Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "kcheng888_007" <[EMAIL PROTECTED]> wrote: > > Hi All, > > Anyone know how to replace a comma in a number using the substring > replacer? > > ie. > INPUT > DATASET_SCALE attribute such as > 1,000 > 5,000 > 10,000 > 20,000 > > OUTPUT should be > 1000 > 5000 > 10000 > 20000 > > I've tried using the substring replacer but didn't have much > success. > > Any suggestion? > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
