0

About the problem of extracting numbers with regular expressions

Hello everyone, I have a question that I need help with. I am using a regular expression to extract the number "1" after the asterisk symbol in "箱2.5L*1坛". The code below is effective in some cases, but it may be wrong in some cases. Could you help me modify it so that it can always correctly extract the number after the asterisk symbol in my image example? Thank you.

extractx(text("箱2.5L*1坛"), "[0-9A-Za-z\*]+[\u4e00-\u9fa5]$")

2 replies

null
    • red_kite
    • 5 mths ago
    • Reported - view

    try this

    extractx(Text, "(?<=\*)\d+")
      • gold_cat
      • 5 mths ago
      • Reported - view

       Thank you for your reply. I have solved the problem. I added the substr function.

Login to reply

Content aside

  • 5 mths agoLast active
  • 2Replies
  • 59Views
  • 2 Following