NAS and TXT Files

SaalekSaalek Member Posts: 181
Hi

As you know, to import a TXT file when you use NAS, it isn't posible to use a Dataport. My TXT file is separated by TAB character. How can I read this character ??. I will use STRPOS to know where is it

Thanks

Comments

  • kinekine Member Posts: 12,562
    TAB is ASCII char 9. Try this:
      CharVar := 9;
      i := STRPOS(Text,CharVar);
    

    Where CharVar is Variable of type Char, Text is your text line, i is integer...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • SaalekSaalek Member Posts: 181
    Hi Kine
    Thanks for your reply, but I have a problem

    I use the same code and variables, but when I compile the object, I receive an error: (is a translation)

    "The type conversion is not posible because one of them is an incorrect type (is a translation)
    text:=char

    "
    If I use Format, always return 0
    I tried to erase all spaces in the string, and aparently it works

    Thanks
  • kinekine Member Posts: 12,562
    Small correction:
      CharVar := 9;
      i := STRPOS(Text,FORMAT(CharVar));
    
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • krikikriki Member, Moderator Posts: 9,118
    or also:
    variable: txcTab Text:1
    txcTab := 'X';
    txcTab[1] := 9;
    i := STRPOS(Text,txcTab);
    

    Same for searching a CR/LF (to find 1 line):
    variable: txcCRLF Text:2
    txcCRLF := 'XX';
    txcCRLF[1] := 10;
    txcCRLF[2] := 13;
    i := STRPOS(Text,txcCRLF);
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.