Jump to content


Photo
- - - - -

Create Tab Delimited File


2 replies to this topic

#1 motely

motely

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 20 March 2009 - 05:34 PM

Hi,

I am outputting data to a text file from PROIV. The file is supposed to be tad delimited. How do I include a tab after each field in my PROIV Code?

Thanks,

#2 Chris Pepper

Chris Pepper

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 369 posts
  • Gender:Male
  • Location:United Kingdom

Posted 20 March 2009 - 05:59 PM

It's covered on here elsewhere. But to cut a long story short a tab is CHAR(9).
So create an Update (or Report to a file) containing a large text field. Then append the fields...

FIELD1 + CHAR(9) + FIELD2 + CHAR(9) etc

If you have numerics in there you may need to put + CHAR(9) + CONV(NUMERICFIELD) + CHAR(9) etc.

#3 motely

motely

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 20 March 2009 - 06:22 PM

Thank you very much. I tried searching, but got no results.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users