Solved

Info required on FSM business rule & Regex

Userlevel 3

+6

Is there any embedded business rule, that calculates the Line Item price & adjustment price in quote? If yes what is it?

What could be the possible regular expression for validating a currency field along with initial character as “€”.

Required help.

icon

Best answer by Shageesha Prabagaran 18 August 2020, 08:21

Userlevel 6

+13

Hi @Asterix ,

Question1

Were you referring to any Business rules associated to the QUOTE table?

Question 2

Can you please check the following Regular expressions for the character € :

/^\€?[0-9][0-9,]*[0-9]\.?[0-9]{0,2}/I

Test Runs: // Only for the character €

€123 - True

123€ - True

^([^\d\s]{1,}\s?[+-]?)(\d{1,3})(\,\d{3})*(\.\d{1,})?$

Test Runs: // For all the characters €, $, &

€123 - True

$123 - True

123 - False

&123 - True

I hope this might help you to adjust the RegEx as you wish.

Best Regards,

Shageesha

Sign up