Help with selecting column with awk for a txt file generated by excel
I am new to scripting/programming, so I apologize for any novice questions.
I have a tab delimited text file that was saved from excel xls file.
I am trying to select only the third column using awk command. My command line is as below:
However, above command line only generates the first row of the third column. How can I generate a tab delimited text file from excel spread sheet that has correct formatting, so that awk command will select the entire column and not just the first row of the column?
Thank you for all your help. I did try searching in this forum and google, but I could not find how to make the the txt file with correct format.
Thanks again.
Last edited by vbe; 09-22-2011 at 12:57 PM..
Reason: please use code tags for your code and data, thanks
Hi,
Can anyone plz share their experience with -
Building shell script to append the file with date in following format-
Filename_MMDDYYYY.txt
Thanks in advance (2 Replies)
Hi,
I have generated a report that contains many columns and since I need ir in excel format.. I just renamed te file to excel as follows:
cp vijay.txt vijay.xls
I have just attached this spreadsheet in the mail and I am getting it to my mail id. But, in the output excel, the columns that... (10 Replies)
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
I have some files created in Excel that have to be saved as .txt files in order to load them into our accounting system. I can save the files as .txt files through Excel, but I then have to open them in TextPad and do a save as to change the Format from PC to UNIX. Is there a way to skip this step... (2 Replies)
Hello,
Can any one please assist how to scirpt it:
Every day a new log file is create and I want to process only the one generated yesterday and get the data of column 3 and 6.
For example today's date is 24 then I want to get the data of log file created on 23rd.
Log Files in... (7 Replies)
I typically pull a bunch of data via SQL that lists a bunch of users and the server on which they want to access, as well as other attributes, in one row of an excel sheet and the number of rows is directly proportionate to the number of users.
I'm trying to write a loop to read each line of the... (2 Replies)
Hi All,
I have a text file with below content.
TradeDate Name SecurityMnc ReasonDesc
=======================================
20120501 Robin ABC FO System Defect
20120502 Robin ABC FO System Defect
I would want this in an excel file in 4 columns,... (3 Replies)
Hi everybody,
I am working on Windows 10 and using cygwin.
I have a vbscript as follows:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set wb1 = objExcel.Workbooks.open("\\files\share\path\file1.xlsx")
wb1.Worksheets("Sheet1").Range("A1:CR89").Clear
Set... (0 Replies)
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
LEARN ABOUT DEBIAN
mcxmap
mcxmap(1) USER COMMANDS mcxmap(1)
NAME
mcxmap - permute or remap the indices of graphs and matrices.
SYNOPSIS
mcxmap -imx fname (input) [-o fname (output)] [-make-map (output map file name)] [-make-mapc (output map file name)] [-make-mapr (output map
file name)] [-cmul a (coefficient)] [-cshift b (translate)] [-rmul c (coefficient)] [-rshift d (translate)] [-mul e (coefficient)] [-shift f
(translate)] [-map fname (row/col map file)] [-rmap fname (row map file)] [-cmap fname (column map file)] [-mapi fname (row/col map file
(use inverse))] [-rmapi fname (row map file (use inverse))] [-cmapi fname (column map file (use inverse))] [-tab fname (read (and map) tab
file)]
DESCRIPTION
This utility relabels graphs or matrices. Its main use is in applying a map file to a given matrix or graph. A map file contains a so called
map matrix in mcl format that has some special properties (given further below). The functionality of mcxmap can also be provided by mcx, as
a mapped matrix (i.e. the result of applying a map matrix to another matrix) is simply the usual matrix product of a matrix and a map
matrix. However, mcx will construct a new matrix and leave the original matrix to be mapped alone. When dealing with huge matrices, consid-
erable gains in efficiency memory-wise and time-wise can be achieved by doing the mapping in-place. This is what mcxmap does. In the
future, its functionality may be embedded in mcx with new mcx operators.
The special properties of a map matrix are
o The column domain and row domain are of the same cardinality.
o Each column has exactly one entry.
o Each row domain index occurs in exactly one column.
These properties imply that the matrix can be used as a map from the column domain onto the row domain. An example map matrix is found in
the EXAMPLES Section.
OPTIONS
-o fname (output file)
Output file.
-imx fname (input file)
Input file.
-map fname (row/col map file))
-rmap fname (row map file)
-cmap fname (column map file)
-mapi fname (row/col map file (use inverse))
-rmapi fname (row map fil (use inverse))
-cmapi fname (column map fil (use inverse))
Different ways to specify map files.
-make-map (output map file name)
-make-mapc (output map file name)
-make-mapr (output map file name)
Generate a map that maps the specified domain onto the appropriate canonical domain and write the map matrix to file.
-cmul a (coefficient)
-cshift b (translate)
These options have affect if neither a column map file nor column canonification is specified. If any of the first two options is used,
column indices i are mapped to a*i+b.
-rmul c (coefficient)
-rshift d (translate)
These options have affect if neither a row map file nor row canonification is specified. If any of the first two options is used,
indices i are mapped to c*i+d.
-mul e (coefficient)
-shift f (translate)
If a map file is specified for a given domain, neither a map file nor canonification is specified. If any of the first two options is
used, the indices i will be mapped to e*i+f.
-tab fname (read (and map) tab file)
This option requires the -map option. mcxmap will output the mapped tab definition.
EXAMPLES
The matrix below has two canonical domains which are identical. It denotes a map of the canonical domain onto itself, in which node 0 is
relabeled to 8, node 1 is relabeled to 5, et cetera.
(mclheader
mcltype matrix
dimensions 12x12
)
(mclmatrix
begin
0 8 $
1 5 $
2 3 $
3 2 $
4 4 $
5 6 $
6 7 $
7 9 $
8 1 $
9 10 $
10 11 $
11 0 $
)
AUTHOR
Stijn van Dongen.
SEE ALSO
mcxio(5), mcx(1), mcxsubs(1), and mclfamily(7) for an overview of all the documentation and the utilities in the mcl family.
mcxmap 12-068 8 Mar 2012 mcxmap(1)