Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But during this , i read lots of forum and learnt that UNIX shell scripting do not have any utility or solution for this.Is this really true?bcaz i everywhere found ppl recommending PERL or other stuff .
----------------------
Real Problem.
----------------------
2. Once Files are converted to CSV , we have to rename all CSV files with names as in different tab from XLS i.e first CSV should be named as the first tab in that XLS and so on .
Is there anyway in scripting to capture those tab names from XLS?
and if not , what alternative i should try to make this happen ?
Hi,
Actually I am want to cut the three fields of "file-nr" file.
$ cat /proc/sys/fs/file-nr
638 219 52270
I want to assign these value to diffrent varibales as follow:-
a=638
b=219
c=52270
I tried to use cut command for this purpose and also tried to squeeze all sapces... (6 Replies)
hello
I have browsed for the similar requirement i found this
https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html
but my problem is i have multiple tabs in xls file having same metadata
I want to convert it into single csv file
any ways to do it pls... (5 Replies)
hi guys im trying to write a bash script that grabs expired domain names it leaves me with the following outpiut in a text file
Im hoping to try to normalise all the dates to the format displayed in the first 2 lines and remove the times so the file looks unfirom can any one give me a... (9 Replies)
Korn Shell
I have hundreds of small files like below created every day. A midnight cron job moves them to the location /u04/temp/logs
But sometimes I have to manually move these files based a certain dates or time.
I have two basic requirements
1.Using mv command I want to move all .dat... (2 Replies)
Can anyone explain why firefox warning message for closing with multiple tabs not working. The checkbox for warning when you have multiple tabs is checked so I don't understand why its not working. (0 Replies)
Hey Guys ,
Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Gents,
I found this script to to launch a KDE Konsole window with multiple tabs..
#!/bin/bash
#
# Create my standard konsole windows.
if ]; then
profile=Shell
fi
sessions=(
sh1 $profile 'clear; bash'
sh1 $profile 'clear; bash'
su1 $profile 'clear; su'... (1 Reply)
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)
str contains tabs and multiple spaces
str="hello world. How are you?"
I want to check string start with hello world,
and my code is:
if ]world"* ]]; then
echo "found"
else
echo "not found"
fi
Not work
Other solution may work is to replace all tabs and... (4 Replies)
Discussion started by: cmdcmd
4 Replies
LEARN ABOUT CENTOS
tabs
tabs(1) General Commands Manual tabs(1)NAME
tabs - set tabs on a terminal
SYNOPSIS
tabs [-v[n]] [-ahuUV] file...
DESCRIPTION
The tabs program clears and sets tab-stops on the terminal. This uses the terminfo clear_all_tabs and set_tab capabilities. If either is
absent, tabs is unable to clear/set tab-stops. The terminal should be configured to use hard tabs, e.g.,
stty tab0
OPTIONS
General Options
-Tname
Tell tabs which terminal type to use. If this option is not given, tabs will use the $TERM environment variable. If that is not set,
it will use the ansi+tabs entry.
-d The debugging option shows a ruler line, followed by two data lines. The first data line shows the expected tab-stops marked with
asterisks. The second data line shows the actual tab-stops, marked with asterisks.
-n This option tells tabs to check the options and run any debugging option, but not to modify the terminal settings.
The tabs program processes a single list of tab stops. The last option to be processed which defines a list is the one that determines the
list to be processed.
Implicit Lists
Use a single number as an option, e.g., "-5" to set tabs at the given interval (in this case 1, 6, 11, 16, 21, etc.). Tabs are repeated up
to the right margin of the screen.
Use "-0" to clear all tabs.
Use "-8" to set tabs to the standard interval.
Explicit Lists
An explicit list can be defined after the options (this does not use a "-"). The values in the list must be in increasing numeric order,
and greater than zero. They are separated by a comma or a blank, for example,
tabs 1,6,11,16,21
tabs 1 6 11 16 21
Use a '+' to treat a number as an increment relative to the previous value, e.g.,
tabs 1,+5,+5,+5,+5
which is equivalent to the 1,6,11,16,21 example.
Predefined Tab-Stops
X/Open defines several predefined lists of tab stops.
-a Assembler, IBM S/370, first format
-a2 Assembler, IBM S/370, second format
-c COBOL, normal format
-c2 COBOL compact format
-c3 COBOL compact format extended
-f FORTRAN
-p PL/I
-s SNOBOL
-u UNIVAC 1100 Assembler
PORTABILITY
X/Open describes a +m option, to set a terminal's left-margin. Very few of the entries in the terminal database provide this capability.
The -d (debug) and -n (no-op) options are extensions not provided by other implementations.
Documentation for other implementations states that there is a limit on the number of tab stops. While some terminals may not accept an
arbitrary number of tab stops, this implementation will attempt to set tab stops up to the right margin of the screen, if the given list
happens to be that long.
SEE ALSO tset(1), infocmp(1M), curses(3X), terminfo(5).
This describes ncurses version 5.9 (patch 20130511).
tabs(1)