Skip to main content
Question

convert Words to number

  • January 21, 2020
  • 5 replies
  • 67 views
rakeshreddy0996
Forum|alt.badge.img

i have numbers in String format but need to translate to numeric

like below

Original StringNeed to be convert One 1 Two 2 Three 3 Four 4 Five 5 Six 6 Seven 7 Eight 8 Nine 9 Ten 10One Hundred and Fifty Nine 159Five Hundred and Nineteen 519Nine Hundred and Fifty One 951 Two Thousand Four Hundred and Eighty Six 2486 Two Thousand Six Hundred and Eighty Four 2684 Six Thousand Eight Hundred and Forty Two 6842 Eight Thousand Six Hundred and Twenty Four 8624 Eight Thousand Four Hundred and Sixty Two 8462 Thirteen Thousand Five Hundred and Seventy Nine 13579 Thirty One Thousand Five Hundred and Ninety Seven 31597 Fifty Three Thousand One Hundred and Seventy Nine 53179 Seventy Five Thousand Three Hundred and Nineteen 75319 Ninety Seven Thousand Five Hundred and Thirty One 97531

Note: I'm getting value upto 7 digits.

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    5 replies

    sigtill
    Supporter
    Forum|alt.badge.img+25
    • sigtillSupporter
    • Supporter
    • 956 replies
    • January 21, 2020

    Do you have a demo-dataset of approx 100 records? This sounds like a fun challenge!

    The real SigTill
    rakeshreddy0996
    Forum|alt.badge.img

    Do you have a demo-dataset of approx 100 records? This sounds like a fun challenge!

    I have data but it not revealing out so i gave sample records.

    ebygomm
    Influencer
    Forum|alt.badge.img+44
    • ebygommInfluencer
    • Influencer
    • 3427 replies
    • January 22, 2020

    There are python examples around for this which you could put into a python caller, e.g.

    words_to_numbers.fmwt

    M
    Forum|alt.badge.img+2
    • markatsafe
    • 1891 replies
    • January 24, 2020

    @rakeshreddy0996 FME 2020 includes a number or Machine Learning connectors to various Amazon, Google and Azure based NLP packages. Some of these might convert text strings to numbers.

    warrendev
    Enthusiast
    Forum|alt.badge.img+26
    • warrendevEnthusiast
    • Enthusiast
    • 121 replies
    • January 24, 2020

    To add on to what @ebygomm suggested, I use the python module word2number. https://pypi.org/project/word2number/

     

     

    word_2_number.fmw

     

    Community Stats

    32,078
    Posts
    121,802
    Replies
    39,709
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.