How do I remove currency symbol from string and convert into int in hive? EXAMPLE (124$ INTO 124)

chiranjeevivenk — Mon, 08 Jun 2026 06:39:18 GMT

How do I remove a currency symbol from a string and convert it into an int in Hive? For example, how do I change '124$' into 124?

Re: How do I remove currency symbol from string and convert into int in hive? EXAMPLE (124$ INTO 124)

Shu_ashu — Thu, 17 Jan 2019 06:49:47 GMT

Use regexp_replace function in hive to replace $ with '' then cast to int.

Example:

select int(regexp_replace(string("124$"),'\\$',''));
+------+--+
| _c0  |
+------+--+
| 124  |
+------+--+

(or)

Starting from Hive-1.3 version use replace function.

select int(replace(string("124$"),'$',''));
+------+--+
| _c0  |
+------+--+
| 124  |
+------+--+