Hello,
I have my own solution to this, which you may try out if you like.
I hope you are reading some kind of a CSV/ txt file or some database column.
Ever since they started calling me as SVG ASSASIN, I am on a kind of killing spree on the FME features!!
I would use an ATTRIBUTESPLITTER and split the text string at "," which would create a list for me.
I would then use a LISTCONCATENATOR without any separation character and then pass the output of this into my destination feature attribute.
Something like this in a mapping file:
DEFAULT_MACRO WB_CURRENT_CONTEXT
# -------------------------------------------------------------------------
FACTORY_DEF * TeeFactory \
FACTORY_NAME ATTRIBUTESPLITTER \
INPUT FEATURE_TYPE 1 \
OUTPUT FEATURE_TYPE ATTRIBUTESPLITTER_OUTPUT \
@Split("@Value(col0)",<comma>,_list{})
# -------------------------------------------------------------------------
FACTORY_DEF * TeeFactory \
FACTORY_NAME LISTCONCATENATOR \
INPUT FEATURE_TYPE ATTRIBUTESPLITTER_OUTPUT \
OUTPUT FEATURE_TYPE LISTCONCATENATOR_OUTPUT \
_concatenated @Concatenate(_list{},)
HTH
Happy FME-ing :-)
SRG
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?
Get your email and more, right on the new Yahoo.com __._,_.___
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.
Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
