05-25-2017
Hi, nans.
Quote:
Originally Posted by nans
... I have written several one liners in awk for these filters with a lot of intermediate files and also converting excel sheets to csv. Would Python be a better way ?
My take on this:
As usual,
it depends.
Are you knowledgeable in languages/scripts other than
awk?
Do you have time to acquire such skill if not?
This is kind of an optimization question:
Guideline 0: does it absolutely need to be faster, more efficient, easier to use, etc?
Best wishes ... cheers, drl
10 More Discussions You Might Find Interesting
1. Programming
Hi,
I have a question about using C to write excel file.
There is a way to write into a sheet into a file excel, like this:
FILE * File;
pMyFile = fopen("test.xls", "w+");
fprintf(File, "\n\n"); /* go to the row 2 of the column A*/
fprintf(File, "%s", "Hi pippo!"); /* write... (7 Replies)
Discussion started by: manceryder
7 Replies
2. HP-UX
Dear Members,
How do I create an eqvivalant of Excel sheet in Hp-UX.
Is there any application like the Microsoft Excel on HP-UX.
How do I invoke it.
Regards,
PrasadKVS (5 Replies)
Discussion started by: KVSPRASAD
5 Replies
3. Shell Programming and Scripting
Kindly help,
Suppose i am having a file that has got the following contents. Is there any way (eg. sed command) to remove the (*) (*any number) pattern.
se.bas
tulf.h
(1)
tuna.c
(1)
tunsim.c
(1)
tus.cpp
(1)
vp.c
(1)
vp.h
(1)
vpi.
(1) (1 Reply)
Discussion started by: frozensmilz
1 Replies
4. Shell Programming and Scripting
I have this script written in csh which I would like to convert to something similar using python script so that I can do more calculations rather than using csh.
set narg = $#argv
while ($iarg < $narg)
MATH iarg = $iarg + 1
set arg = $argv
set opt = `echo $arg | awk... (2 Replies)
Discussion started by: kristinu
2 Replies
5. OS X (Apple)
Hello,
This is my first post so not sure what response I will get
I do have a very small knowledge of UNIX used last over 10 years ago
I have recently move over to an Apple IMAC
I need to copy all my jpg files into excel
Could someone please let me know if this is possible and... (2 Replies)
Discussion started by: Nacnud
2 Replies
6. Shell Programming and Scripting
Hi ,
I am writing a simple excel file and want to create the file under say 'D:\Documents and Settings'. The problem with my code is it is writing in the same directory instead of the specified. Here is a sample code
use Spreadsheet::WriteExcel;
my $workbook =... (1 Reply)
Discussion started by: daptal
1 Replies
7. Shell Programming and Scripting
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies
8. Shell Programming and Scripting
Hi,
Anyone can help I am just converting the excel file to csv using python, I can get the conversion output but the date not display exactly.
test.xlsx date format
167 1588 risks/SCS JP CAMPANA & CIE.pdf SCS JP CAMPANA & CIE 2 1 1 0 2015-03-16 16:56:25
167 1146 risks/AirBNB... (1 Reply)
Discussion started by: fspalero
1 Replies
9. Shell Programming and Scripting
Hello
I have a big excel file for Ticket Data Analysis. The idea is to make meaningful insight from Resolution Field. Now as people write whatever they feel like while resolving the ticket it makes quite a task.
1. They may or may not tag it with something like below within the resolution... (1 Reply)
Discussion started by: radioactive9
1 Replies
10. Shell Programming and Scripting
Hi All,
I am new to shell scripting.
I have made a script that can convert an excel file from cvs file.
This excel file contains hundreds of records and i would like the reader to be able to filter.
Is it possible to create an excel file with filters? or that functionality has not been... (3 Replies)
Discussion started by: Marvin159875321
3 Replies
LEARN ABOUT HPUX
xmtablist
XmTabList(library call) XmTabList(library call)
NAME
XmTabList -- Data type for a tab list
SYNOPSIS
#include <Xm/Xm.h>
XmTabList
DESCRIPTION
XmTabList is the data type for a tab list. A tab list consists of tab stop list entries (XmTabs). Whenever a tab component is encountered
while an XmString is being rendered, the origin of the next X draw depends on the next XmTab. If a tab stop would cause text to overlap,
the x position for the segment is reset to follow immediately after the end of the previous segment.
Tab lists are specified in resource files with the following syntax:
resource_spec: tab WHITESPACE [, WHITESPACE tab ]*
The resource value string consists of one or more tabs separated by commas. Each tab identifies the value of the tab, the unit type, and
whether the offset is relative or absolute. For example:
tab := float [ WHITESPACE units ]
float := [ sign ] [[ DIGIT]*. ]DIGIT+
sign := +
where the presence or absence of sign indicates, respectively, a relative offset or an absolute offset. Note that negative tab values are
not allowed. units indicates the unitType to use as described in the XmConvertUnits reference page.
For example, the following specifies a tab list consisting of a one inch absolute tab followed by a one inch relative tab:
*tabList: 1in, +1in
For resources of type, dimension, or position, you can specify units as described in the XmNunitType resource of the XmGadget, XmManager,
or XmPrimitive reference page.
RELATED
Refer to the Motif Programmer's Guide for more information about tabs and tab lists. XmTabListCopy(3), XmTabListFree(3), XmTabListGet-
Tab(3), XmTabListInsertTabs(3), XmTabListRemoveTabs(3), XmTabListReplacePositions(3), and XmTabListTabCount(3).
XmTabList(library call)