| View previous topic :: View next topic |
| Author |
Message |
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
 Posted: Tue Jun 17, 2008 10:33 am Post subject: Create a Tab Delimited File |
 |
|
Members,
I want to create a Tab Delmited File and i have never worked on them.My requirement is that i have to create a Tab Delimited File and it will be downloaded to a xls spreadsheet and my requirement is to have a tab after each field.For example if my input file is like below:
| Code: |
111111ABCENGINEER
111111 - EMPNO
ABD - DEPARTMENT NAME
ENGINEER - DESIGNATION
|
I want to create a File which will have a tab between each field and when downloaded to a xls and seen it will have values in each cell.Please let me know how i can insert a tab between each fields and how i can cofirm that i have inserted Tab.Thanks. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
| Posted: Tue Jun 17, 2008 8:54 pm Post subject: |
|
|
Thanks Kolusu,
I am able to understand what Tab Delmited Files are and the example in the link helped me a lot. |
|
| Back to top |
|
|
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
| Posted: Wed Jun 18, 2008 8:24 am Post subject: |
|
|
Kolusu,
I have a question here , how could you say that Tab represents Hexadecimal value X'05', is there any link / document which has values for different symbols , can you please help me out.Thanks. |
|
| Back to top |
|
|
Nic Clouston
Advanced
Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
|
| Posted: Wed Jun 18, 2008 8:35 am Post subject: |
|
|
Any EBCDIC chart should show what each hex value from x'00' to x'ff' represents. The same for an ASCII chart. Sometimes these are in language reference manuals (but not always). They are always on a System Reference Summary pamphlet available from IBM - sorry, don't know the form number.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL. |
|
| Back to top |
|
|
Nic Clouston
Advanced
Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
|
| Posted: Wed Jun 18, 2008 9:10 am Post subject: |
|
|
I thought I would find the form number for the Reference Summary, which I did. I then went to the part where I thought it would say x'05' is TAB. It didn't - it said it is HT. Foot-in-mouth syndrome? No! Just below the table, in the notes, I found HT translates, in English, to Horizontal Tab. Saved!
The form number is: SA22-7871-02
Note: the last pair of digits is the version number so 03 may be available.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
