Reading tab-delimited text file

bhalpin
bhalpin Member Posts: 309
edited 2010-05-14 in NAV/Navision Classic Client
Hi.

I have to import a tab-delimited file, and have the perfect code for this import 'on-the-shelf' already. All the infrastructure is there (using a File var) and this should have been easy.

But (there's always a 'but') the existing code parses text-lines on semi-colons, not tabs. Simple change. NOT.

I dig into what's happening and see that when NAV reads a line it expands the tabs into a bunch of spaces. (Thank's a bunch. :!: )

Is there any way to side-step this? Or do have to give up and use a dataport?

Thanks!

Comments

  • thmartin
    thmartin Member Posts: 90
    Hi,

    I had the same problem a while ago.

    File.READ transforms TABs into a number of spaces. You get around the problem by using Streams.

    File.CREATEINSTREAM(StreamIn);
    StreamIn.READTEXT(Var);
    Thomas Martin
    NAV Developer
  • rdebath
    rdebath Member Posts: 383
    You don't need to use streams, but you can only see TABs if you don't read the file in text mode.
    Generally this means using Char variables and reading one character at a time though.
    Robert de Bath
    TVision Technology Ltd
  • bhalpin
    bhalpin Member Posts: 309
    Thanks!

Categories