8 Replies Latest reply: Dec 13, 2017 7:31 AM by Victor GREFFET RSS

    Empty everywhere

    Victor GREFFET

      Hi community,


      I have a question, i'd like to know if there is an awesome statement or a piece of script wich could do :

      - Put 'empty'  for all blanks in my database, (calculate field or a loaded field or whatever...)


      I don't want to use

          if(len(trim([IField]))=0,'empty',[Field]) AS [Field] for each field, I'd like to have a general statement wich appear once in my script...


      Do you have an idea ?




        • Re: Empty everywhere
          Chanty 4u

          am not sure try this

          NullAsValue *;

          SET ThousandSep=',';

          SET DecimalSep='.';

          SET MoneyThousandSep=',';

          SET MoneyDecimalSep='.';

          SET MoneyFormat='$#,##0.00;($#,##0.00)';

          SET TimeFormat='h:mm:ss TT';

          SET DateFormat='M/D/YYYY';

          SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

          SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

          SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

          SET NullValue='<NULL>';

          SET NullDisplay='Null';


          ODBC CONNECT TO ...