Sponsored Content
Homework and Emergencies Emergency UNIX and Linux Support Dealing with XLS file with multiple tabs Post 302898298 by himanshu sood on Monday 21st of April 2014 08:56:36 AM
Old 04-21-2014
mjf,

I have converted my files to csv using Applescript and now the problem is renaming themas required.
As i dont want to hard code anything so looking for some dynamic way to do so.

Any help ?

Regards,
Himansuh Sood
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to delete multiple space or tabs from a read only file

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)
Discussion started by: bisla.yogender
6 Replies

2. Shell Programming and Scripting

converting xls file to txt file and xls to csv

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

3. Shell Programming and Scripting

Converting huge xls(having multiple tabs) to csv

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)
Discussion started by: joshiamit
5 Replies

4. Shell Programming and Scripting

dealing with dates in a text file

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)
Discussion started by: dunryc
9 Replies

5. Shell Programming and Scripting

Dealing with multiple files

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)
Discussion started by: kraljic
2 Replies

6. UNIX and Linux Applications

Firefox Warning message for closing with multiple tabs not working

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)
Discussion started by: cokedude
0 Replies

7. UNIX for Advanced & Expert Users

Shell script for dealing with XLS file with multiple tabs/worksheets

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)
Discussion started by: himanshu sood
2 Replies

8. Shell Programming and Scripting

Script to launch a KDE Konsole window with multiple tabs

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)
Discussion started by: jiam912
1 Replies

9. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

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

How to check string contain multiple tabs or spaces?

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
profile(4)						     Kernel Interfaces Manual							profile(4)

NAME
profile - set up user's environment at login time DESCRIPTION
If the file exists, it is executed by the shell for every user who logs in. The file should be set up to do only those things that are desirable for every user on the system, or to set reasonable defaults. If a user's login (home) directory contains a file named that file is executed (via the shell's before the session begins. files are useful for setting various environment parameters, setting terminal modes, or overriding some or all of the results of executing EXAMPLES
The following example is typical (except for the comments): # Make some environment variables global export MAIL PATH TERM # Set file creation mask umask 22 # Tell me when new mail comes in MAIL=/var/mail/myname # Add my /bin directory to the shell search sequence PATH=$PATH:$HOME/bin # Set terminal type echo "terminal: c" read TERM case $TERM in 300) stty cr2 nl0 tabs; tabs;; 300s) stty cr2 nl0 tabs; tabs;; 450) stty cr2 nl0 tabs; tabs;; hp) stty cr0 nl0 tabs; tabs;; 745|735) stty cr1 nl] -tabs; TERM=745;; 43) stty cr1 nl0 -tabs;; *) echo "$TERM unknown";; esac A more complete model can be found in FILES
SEE ALSO
env(1), login(1), mail(1), sh(1), stty(1), su(1), environ(5), term(5). profile(4)
All times are GMT -4. The time now is 02:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy