06-22-2009
Hi Rakesh.
Perhaps if you'd give more details about the format of the file? i.e. is it a real XLS file (prabably not if you say it only has 10 lines), or a (CSV-style) text file.
If the data isn't sensitive, perhaps you could post it, if it's only 10 lines, otherwise give us the gist of how it looks (including funny control-looking stuff).
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file in which I have records as follows
--------------------------------------------------------------------------
2-sister-birmbb-s0005.ftip002590790.vpn-nte.bt.net BRI0 0 0 0
aber-con-dyce-s0006.ftip002732992.vpn-nte.bt.net ATM0 0 0 0... (3 Replies)
Discussion started by: rahulrathod
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
Does anyone know how to make BASH provide a list of possible completions on the first tab, and then start cycling through the possibilites on the next tab?
Right now this is what I have in my .bashrc:
bind "set show-all-if-ambiguous on"
bind \\C-o:menu-complete
This allows... (0 Replies)
Discussion started by: Mithu
0 Replies
3. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
4. UNIX for Advanced & Expert Users
Hi All,
I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box .
I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies
5. Shell Programming and Scripting
Hi,
How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement?
Here i know how to connect the database using unix shell script and
how to use the mailx command in UNIX script
But i don't know how to use the .xls format file (i... (1 Reply)
Discussion started by: psiva_arul
1 Replies
6. UNIX for Advanced & Expert Users
I need help to create a csv file with Unix command.
In csv file, i need to put two values in the same cell.
Rite now, whts happening is, if i put 2 values in the same cell, its comming as " asd, zxc" but i want it in different line but in same cell.
asd
zxc
Please reply me ASAP. (1 Reply)
Discussion started by: Prashant Jain
1 Replies
7. Shell Programming and Scripting
How do I extract the last cell in a column of a csv file using linux shell scripting?
Or alternatively, how do I get the number of cells of a csv file? (2 Replies)
Discussion started by: locoroco
2 Replies
8. Shell Programming and Scripting
<DIV><P>Pré-condição aceder ao ecrã Home do MRS.</P></DIV><DIV><P>OK.</P></DIV><DIV><P>Seleccionar Pesquisa de Recepção Directa.</P></DIV><DIV><P>Confirmar que abriu ecrã de Recepção Directa.</P></DIV><DIV> (6 Replies)
Discussion started by: oliveiraum
6 Replies
9. Shell Programming and Scripting
HI,
I have multiple files per dept in folder
for eg : In a folder
File1_Dept100.xls
File2_Dept100.xls
File3_Dept100.xls
File1_Dept200.xls
File2_Dept200.xls
File3_Dept200.xls
Output should be :
Dept100.xls which has File1, File2, File3 in different tabs
Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies
10. UNIX for Beginners Questions & Answers
Please help!!
This code works perfect but the only problem I am having is that is treats eg SQL Developer as separate cell/column which makes the formatting bad. I want to put SQL Developer in one cell. I attached a sample of how the output looks like.
report.txt
USERNAME OSUSER ... (5 Replies)
Discussion started by: lpoolfc
5 Replies
NET(5) File Formats Manual NET(5)
NAME
net - format of .net files read/written by Magic's netlist editor
DESCRIPTION
Netlist files are read and written by Magic's netlist editor in a very simple ASCII format. The first line contains the characters
`` Netlist File'' (the leading blank is important). After that comes a blank line and then the descriptions of one or more nets. Each
net contains one or more lines, where each line contains a single terminal name. The nets are separated by blank lines. Any line that is
blank or whose first character is blank is considered to be a separator line and the rest of its contents are ignored.
Each terminal name is a path, much like a file path name in Unix. It consists of one or more fields separated by slashes. The last field
in the path is the name of a label in a cell. The other fields (if any), are cell instance identifiers that form a path from the edit cell
down to the label. The first instance identifier must name a subcell of the edit cell, the second must be a subcell of the first, and so
on.
Instance identifiers are unique within their parent cells, so a terminal path selects a unique cell to contain the label. However, the
same label may appear multiple times within its cell. When this occurs, Magic assumes that the identical labels identify electrically
equivalent terminals; it will choose the closest of them when routing to that terminal. Further, after connecting to one of these termi-
nals Magic may take advantage of the internal wiring connecting them together and route through a cell to complete the net's wiring.
An example netlist file follows below. It contains three distinct nets.
----------------------------------------
Netlist File
alu/bit_1/cout
alu/bit_2/cin
regcell[21,2]/output
latch[2]/input
This line starts with a blank, so it's a separator.
opcode_pla/out6
shifter/drivers/shift2
----------------------------------------
SEE ALSO
magic(1)
4th Berkeley Distribution NET(5)