Can we use TAB as a delimiter while exporting?

[mprabu_p]

Hi All,

Can we use the TAB as a delimiter while exporting the values to file from one table?

For example I am having the below piece of code..

output to <file>.
for each pt_mster where pt_part = "Item" no-lock:
export delimiter "," pt_mstr.
end.

Instead of delimiter "," i want to use delimiter as TAB ..
Can we use TAB as a delimiter while exporting the values.
if it is possible please tell me how?
what is syntax for that?

Thanks in advance...

Regards
M.Prabu.

 

[Joel W Winston]

Hello Prabhu,

use the following

output to <file>.
for each pt_mster where pt_part = "Item" no-lock:
export delimiter '~011' pt_mstr.
end.

The '~011' does the trick.

Let me know if this helped.

Courtesy - Progress KB # P22469

 

[mprabu_p]

Joel W,

Thanks a lot for your reply.

I got my expected result.

Thanks

Regards
M.Prabu

 

[Joel W Winston]

Welcome Prabu

 

[D.Cook]

I find the shortcut '~t' much easier to remember.
Also handy is '~n' for new line.

 

[mprabu_p]

Thanks cook