Hi guys
I´m trying to compare two strings using a condition but the result is always wrong... can anyone help me?
For example:
the value of compose 3 is 322,30 € (locale de-de), the value of compose 4 is 1000,00€ (locale de-de)
The check in the condition is: if compose 3 is equal or greater than compose 4
Why would the result be true?
Regards,
Lisa
Since string comparison works different from Number comarison, you first have to convert these string to numbers.
float(
trim(
replace(
replace(
replace(
'1.000,00 €',
'.',
''
),
',',
'.'
),
'€',
''
)
)
)
stampcoin
30
Michael E. Gernaey
24
Super User 2025 Season 1
RP-25090907-0
23