MVSFORUMS.com

psmadhusudhan · Beginner Joined: 28 Nov 2006 Posts: 143 Topics: 48

Hi,

I have to prepare one file where fields are seperated by Tab Key(file is verified after transmitted to user end in text format). ASCII value of tab key is 09.

Suppose below is my record structure, please let me know how to insert ascii value of tab key in between fields either through COBOL program or through SORT or by another usefull means.

Name PIC X(10)
ID PIC 9(10)
Branch PIC X(20)
_________________
Thanks
Madhu Sudhan

kolusu · Posted: Mon Sep 19, 2011 10:26 am Post subject:

psmadhusudhan,

Is this a trick question? Define a TAB-VALUE PIC X and move the hex value.

dbzTHEdinosauer · Posted: Mon Sep 19, 2011 10:47 am Post subject:

do the contents of NAME and ID contain ASCII or ebcdic data?
_________________
Dick Brenholtz
American living in Varel, Germany

psmadhusudhan · Beginner Joined: 28 Nov 2006 Posts: 143 Topics: 48

kolusu,

No this is not trick question, I dont know whether this movement will really give tab key in the final file or not, thats why I have posted the question.

One small query if we move hexadecimal '09' is it same as ASCII value. Dont mind if it is stupid question.

I will try your solution and let you know.

dbzTHEdinosauer,

NAME and ID eBCDIC data
_________________
Thanks
Madhu Sudhan

kolusu · Posted: Tue Sep 20, 2011 10:24 am Post subject:

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

I agree with your latest post, Kolusu.

If you separate columns in a file with tab characters (hex 05) and ftp it to a Windows platform and save it as a .prn file, when the file is opened it will open as Excel.

This works better than a .csv file (comma-separated values) at times, in case a comma may be part of your data. Then your fields are not aligned correctly.