transfer letter to number

16 views
Skip to first unread message

Noor EL-Nammar

unread,
May 3, 2018, 9:08:55 AM5/3/18
to OpenRefine
which GREL function can help me to transform

US $186 million to 186000000
US$10 billion to 10 000 000 000

by transferring the million and billion to zeros

thank you

Ettore Rizza

unread,
May 3, 2018, 9:13:39 AM5/3/18
to OpenRefine
A simple replacement can do the trick :

value.replace(' million', '000000').replace(' billion', '000000000')

Noor EL-Nammar

unread,
May 5, 2018, 5:38:01 AM5/5/18
to OpenRefine
Reply all
Reply to author
Forward
0 new messages