Tab delimited flat file

[shafjde]

Hello list.

A client has requested the creation of a tab delimited flat file. I am
attempting to do this by using the DBO functionality but I do not know how
to insert a tab character after each field.

Any ideas would be greatly appreciated.
Thanks in advance.

Shaf

_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

 

[Zoltan_Gyimesi]

Shaf,
I have an idea but I have never tried it. I suppose, it could work.

1.) Create a variable based on a character type data item to hold TAB character (e.g. evt_TabChar_EV01 based EV01 data item).
2.) Open Notepad or any simple texteditor.
3.) Enter a TAB into the editor.
4.) Select the entered TAB character in the editor and Copy to the clipboard.
5.) Create an assignment for your variable and Paste the TAB character into the value field.
6.) Concatenate this variable at the places where you want a TAB delimiter.

I'm very curious to that does it work or does not.
So, I kindly ask you, let us know the result if you have tried this trick.
Thank in advance,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[shafjde]

Zoltan, your are star.
This worked a treat.

Many thanks

Shaf


>From: Zoltan_Gyimesi <[email protected]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: Re: Tab delimited flat file ~~2473:2495
>Date: Tue, 12 Dec 2000 07:38:22 -0800 (PST)
>
>Shaf,
>I have an idea but I have never tried it. I suppose, it could work.
>
>1.) Create a variable based on a character type data item to hold TAB
>character (e.g. evt_TabChar_EV01 based EV01 data item).
>2.) Open Notepad or any simple texteditor.
>3.) Enter a TAB into the editor.
>4.) Select the entered TAB character in the editor and Copy to the
>clipboard.
>5.) Create an assignment for your variable and Paste the TAB character into
>the value field.
>6.) Concatenate this variable at the places where you want a TAB delimiter.
>
>I'm very curious to that does it work or does not.
>So, I kindly ask you, let us know the result if you have tried this trick.
>Thank in advance,
>Zoltán
>
>B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
>(working with B7321, B7331, XE too)
>--------------------------
>Visit the forum to view this thread at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=2495
>*************************************************************
>This is the JDEList One World / XE Developers Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com