Overcome Problems with decimal delimiters or other characters (OpenLAB Intelligent Reporting)

Version 2

    Hello Intelligent Reporting World,

    if you have to replace a char like in my case the  Comma to a Point because of national settings you can use following expression:

    =First(CStr(Sample_Amount).Replace("0","X"))

    =First(CStr(Sample_Amount).Replace(",","."))

    you can use this to change chars in custom fields or every other expression

    Regards

    Uwe Kirchhoff

     

    (originally posted in OpenLAB Forum: https://zohodiscussions.com/openlabcdsforum#Topic/68030000000068039

    2013 March 15 )