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

Document created by agilent Employee on Mar 22, 2016Last modified by agilent Employee on Mar 28, 2016
Version 2Show Document
  • View in full screen mode

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

ukirchhoff

 

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

2013 March 15 )

Attachments

    Outcomes