2 Replies Latest reply: Aug 8, 2014 4:45 AM by Wolfgang Mohr RSS

    Change of Script from .xlsx to .txt empty fields

    Wolfgang Mohr

      Hi Folks,
      for reasons of simplyfication I changed the Import file / script from *.xlsx to *.txt

       

      Now it noticed that *.txt has another Approach to empty fields in the file.

       

      Whereas <Rechnung={"*"}> gives me on Basis *.xlsx only those fields which are not empty,
      this formula gives me on Basis *.txt also those which are empty.

       

      The formula <Rechnung={"?*"}> will return only those fields which are not empty in *.txt.

       

      The *.txt fields are also giving me the 'empty value' as selection possibility, which is not the
      case in *.xlsx files.

       

      Here the bottom of the script:
      FROM
      RS Files\RS Startup Auftrag.TXT]
      (txt. Codepage is 1252, no Labels, delimiter is '\t', msq);

       

      I labelled it the way that:  @23 as Rechnung

       

       

      Please assist, thank you so much in advance!

      Wolfgang