Getting naked value out of matrix

SeKo

Hi all,



In the matrix on the order form, you have the price of the products: "$ 123.45". If I do a getvalue on that field, I get the value as shown (with the currency sign).

Is there a way to only get the numeric value, or should I use a regex to strip all the non numeric (and . and ,) from the field?



Thanks!



Sebastiaan

Paolo Manfrin

Hi Sebastian, regex is the only way except if you read the data directly from the database. As I don't know the business requirememts I am not sure if this is an option.



Hth paolo

SeKo

I can't read it from the database since I also need the function before it's added. But I'll use regex. Thanks!

Andreas Bimberg

Hi Sebastian,



you could use the replace function first and replace the $ by blank space and also switch the , and . afterwards you should be able to use the value. At least this worked for us on the order form.

I have used SQL



Example:

CAST((REPLACE((REPLACE([%A;38;U_NetPrice],' EUR','')),',','.')



above code also works on any other currency value.....