Trying to get a value from a comment and assign it to a custom field

[Rosana Casilli]

Hi All!

I need to write an automation rule where after adding a comment, if this comment has the value "Valor bruto:" or "Valor inicial:" or "Valor:", the value after the ":" is added to the customfield "Valor inicial".

can you please help me with this?

Thanks in advance,

Ro

[Deivid Araujo]

Hi Rosana!

For that exact scenario, you will have to use regex to capture the string, but be aware that this approach may lead to various problems. including:

• Unexpected matches (false positives): regex may capture unintended text.

• Inconsistent formatting: extra spaces, line breaks, different ways of writing “Valor” or the number.

• Multiple occurrences: regex may only grab the first or wrong match if more than one appears.

• Localization issues: decimal/thousand separators (1.200,50 vs 1200.50).

• Automation regex limitations: not all regex features (like lookbehinds) are supported.

• Field type mismatch: target number fields may reject values like R$ 1.200,50.

• Complexity/maintenance: regex rules can become too hard to read or adjust later.

That said, here's an article showing how to extract text using regex:

https://support.atlassian.com/jira/kb/extract-content-out-of-description-and-summary-with-regex-and-automation/

A regex tester:

https://regexr.com/39jba

As for the regex itself. it will depend on yout text patter (if any), so your best bet is to use any LLM to generate the regex string