使用re切割 2004-9-10USD479.22中的日期，币种简称和小数

要使用正则表达式（re）来切割字符串`2004-9-10USD479.22`中的日期、币种简称和小数值，你可以这样操作[^1]：

from re import search

input_str = "2004-9-10USD479.22"
match = search(r'(\d{4}-\d{1,2}-\d{1,2})\s*(\w+)?\s*([\d\.]+)', input_str)

if match:
    date = match.group(1)
    currency = match.group(2) or "Unknown"  # 如果找不到币种，则默认为"Unknown"
    amount = match.group(3)
    print(f"Date: {date}, Currency: {currency}, Amount: {amount}")
else:
    print("Failed to parse the string.")

这将输出：

Date: 2004-9-10, Currency: USD, Amount: 479.22

相关问题

hive 如何把USD24，217.45转化为twenty-four thousand and two hundred....这种英文格式

Hive 中可以使用 UDF（User-Defined Functions）来实现将数字转化为英文格式的功能。以下是一个示例 UDF 的代码实现：

import org.apache.hadoop.hive.ql.exec.UDF;
import java.text.DecimalFormat;

public class NumberToEnglish extends UDF {
    private static final String[] tensNames = {"", " ten", " twenty", " thirty", " forty", " fifty", " sixty", " seventy", " eighty", " ninety"};
    private static final String[] numNames = {"", " one", " two", " three", " four", " five", " six", " seven", " eight", " nine", " ten", " eleven", " twelve", " thirteen", " fourteen", " fifteen", " sixteen", " seventeen", " eighteen", " nineteen"};
    private static final String[] bigNames = {"", " thousand", " million", " billion"};

    public String evaluate(Double num) {
        if (num == 0) {
            return "zero";
        }

        DecimalFormat decimalFormat = new DecimalFormat("#.00");
        String formatted = decimalFormat.format(num);

        String[] parts = formatted.split("\\.");
        long dollars = Long.parseLong(parts[0]);
        int cents = Integer.parseInt(parts[1]);

        String dollarsInEnglish = convert(dollars);
        String centsInEnglish = convert(cents);

        String result = dollarsInEnglish + " dollars";
        if (cents != 0) {
            result += " and " + centsInEnglish + " cents";
        }

        return result.trim();
    }

    private static String convert(long num) {
        if (num == 0) {
            return "zero";
        }

        String prefix = "";
        if (num < 0) {
            num = -num;
            prefix = "negative";
        }

        String current = "";
        int place = 0;

        do {
            long n = num % 1000;
            if (n != 0) {
                String s = convertLessThanOneThousand((int) n);
                current = s + bigNames[place] + current;
            }
            place++;
            num /= 1000;
        } while (num > 0);

        return (prefix + current).trim();
    }

    private static String convertLessThanOneThousand(int num) {
        String current;

        if (num % 100 < 20) {
            current = numNames[num % 100];
            num /= 100;
        } else {
            current = numNames[num % 10];
            num /= 10;

            current = tensNames[num % 10] + current;
            num /= 10;
        }
        if (num == 0) {
            return current;
        }
        return numNames[num] + " hundred" + current;
    }
}

这个 UDF 接受一个 Double 类型的参数，然后将其转化为英文格式的字符串。在这个 UDF 中，我们使用了一个叫做 `convert()` 的函数来将数值转化为英文形式。这个函数将数值按照千位进行分组，然后对每一组的数值进行转化，最后将所有组的结果拼接起来。

例如，要将 USD24,217.45 转化为英文格式，可以使用如下的 HiveQL 语句：

SELECT NumberToEnglish(24217.45);

上面的语句将返回字符串 "twenty-four thousand two hundred seventeen dollars and forty-five cents"。

优化这段代码userScoreService.findByUserIdAndModuleAndEventAndPayload(userId, moduleName, eventName, payload).ifPresent(us -> { UserScoreEntity userScoreByDel = userScoreService.findByUserIdAndModuleAndEventAndPayload(userId, moduleName, "取消" + eventName, payload).orElseGet(() -> { UserScoreEntity usd = new UserScoreEntity(); usd.setUserId(userId); usd.setModule(moduleName); usd.setEvent("取消" + eventName); Integer total = userScoreService.findTotalScoreByUserId(userId); if (total <= us.getScore()) { usd.setScore((short) -total); usd.setTotal(0); } else { usd.setScore((short) -us.getScore()); usd.setTotal(total - us.getScore()); } usd.setPayload(event.getPayload()); usd.setOperationTime(event.getSendTime()); return usd; }); if (Objects.isNull(userScoreByDel.getId())) { userScoreService.save(userScoreByDel); } });

优化后的代码如下：

String cancelEventName = "取消" + eventName;
Optional<UserScoreEntity> optionalUserScore = userScoreService.findByUserIdAndModuleAndEventAndPayload(userId, moduleName, eventName, payload);

if (optionalUserScore.isPresent()) {
    UserScoreEntity userScore = optionalUserScore.get();
    UserScoreEntity userScoreByDel = userScoreService.findByUserIdAndModuleAndEventAndPayload(userId, moduleName, cancelEventName, payload).orElseGet(() -> {
        UserScoreEntity usd = new UserScoreEntity();
        usd.setUserId(userId);
        usd.setModule(moduleName);
        usd.setEvent(cancelEventName);
        Integer total = userScoreService.findTotalScoreByUserId(userId);
        if (total <= userScore.getScore()) {
            usd.setScore((short) -total);
            usd.setTotal(0);
        } else {
            usd.setScore((short) -userScore.getScore());
            usd.setTotal(total - userScore.getScore());
        }
        usd.setPayload(event.getPayload());
        usd.setOperationTime(event.getSendTime());
        return usd;
    });
    if (userScoreByDel.getId() == null) {
        userScoreService.save(userScoreByDel);
    }
}

优化说明：
- 将重复使用的字符串 "取消" + eventName 提取为一个变量 cancelEventName，减少重复计算。
- 通过 optionalUserScore.isPresent() 判断是否存在对应的 UserScoreEntity 实例，避免重复查询。
- 使用 userScore 变量代替 us，提高代码可读性。
- 对于 userScoreByDel.getId() 的判断，使用 userScoreByDel.getId() == null 替代 Objects.isNull(userScoreByDel.getId())。
- 代码格式化，提高可读性。