Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Exanding an array into another file.
Top Forums Shell Programming and Scripting Exanding an array into another file. Post 303026879 by Corona688 on Tuesday 4th of December 2018 12:48:37 PM
Old 12-04-2018
Quote:
Originally Posted by Paul Walker
You suggested to use a flat file. I'm not sure I understand, would that be to already perform the substitution of the variables with something like sed?
What substitution of what variables?

A flat file is a file like this:

Code:
data1
data2
data3
data4
data5

Which can be used without transforming it into an array like
Code:
while read LINE
do
...
done < inputfile

Quote:
The osascript is used save the Excel file as a tab delimited file which I will use in another script. The array comes form a list of files that are submitted through a hot folder.
Directly below is the script I use to format the array and move the files from one folder to another to be worked on.
Is there a way to call the osascript from the script I use to format the array, and write out my osascript file with the proper file names (your suggestion worked fine I just wondered if there is a more direct way).

Or is there a way to run the osascript in such a way that the shell can parse the variables in the array and pass it to the osascript?
The proper way would be to write the code you want in applescript, but I don't know applescript.

You have taken the long way around by transforming a file into an array with six invocations of sed however! That is unnecessary.

Code:
cp /Osascript_ForExcel_Shapes/Kernel/Standing_filelist_array /Osascript_ForExcel_Shapes/Kernel/filelist_array
ls /Osascript_ForExcel_Shapes/ExcelThumbs >> /Osascript_ForExcel_Shapes/Kernel/filelist_array
while read i
do
        mv /Osascript_ForExcel_Shapes/ExcelThumbs/"$i".xlsx /Osascript_ForExcel_Shapes/Working/
done < /Osascript_ForExcel_Shapes/Kernel/filelist_array

I have left out your outer 'while true' loop since I'm not certain what that's for. I don't think you actually want an infinite loop over the same data, do you?

Quote:
Below is the full osascript to save as tab delimited "FILENAME" is name of the original Excel files.
Code:
osascript <<EOD
 tell application "Microsoft Excel"
    activate
    set theWorkbookFile to "Macintosh HD:Osascript_ForExcel_Shapes:Working:FILENAME.xlsx"
    open theWorkbookFile #open the xls file
    set theWorksheetname to name of worksheet 1 of active workbook
    set theWorksheet to worksheet 1 of active workbook
        
    tell application "Microsoft Excel" to set display alerts to false
    set targetFolder to ("Macintosh HD:Osascript_ForExcel_Shapes:Working:")
    save the active workbook as text Mac file format in ((targetFolder as text) & "FILENAME.txt") with overwrite
    close the active workbook without saving    
end tell
EOD

Using Hypercard to kludge Microsoft Excel into working automatically is rather the long way around too. Do you have Perl? Can you install Spreadsheet::WriteExcel?

Code:
#!/usr/bin/perl

use Spreadsheet::WriteExcel;

my ($in,$out)=(shift,shift); # commandline arguments

(defined($in) && defined($out)) or die "Usage:  flattoxls input out.xls";

open(FH,"<".$in) or die "Cannot open file: $!\n";
my $book = Spreadsheet::WriteExcel->new($out);
my $sheet = $book->add_worksheet();
my ($row,$col) = (0,0);
while (<FH>){
        chomp;                  # Remove newline character
        @list = split /\t/,$_;  # Split on tabs
        # Loop over row and add, cell by cell
        foreach my $c (@list){ $sheet->write($row, $col++, $c); }
        $row++; $col=0; # Next row, column 0
}

close(FH);      # Close input file
$book->close(); # Finish writing excel file
exit(0);        # Return success

Then you can do

Code:
perl flattoxls.pl inputfile output.xls

These 2 Users Gave Thanks to Corona688 For This Post:
Neo Paul Walker
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create array holding characters from sring then echo array.

Hi, I wish to store $string1 in $string1array a character in each array element. Then i wish to echo the entire array to the screen so that it reads as the normal string again. I have been trying with the code below but does not work. Please help... To put string into array: ... (5 Replies)
Discussion started by: rorey_breaker
5 Replies

2. Programming

Creating an array to hold posix thread ids: Only dynamic array works

I am facing a strange error while creating posix threads: Given below are two snippets of code, the first one works whereas the second one gives a garbage value in the output. Snippet 1 This works: -------------- int *threadids; threadids = (int *) malloc (num_threads * sizeof(int)); ... (4 Replies)
Discussion started by: kmehta
4 Replies

3. Shell Programming and Scripting

PHP: Search Multi-Dimensional(nested) array and export values of currenly worked on array.

Hi All, I'm writing a nagios check that will see if our ldap servers are in sync... I got the status data into a nested array, I would like to search key of each array and if "OK" is NOT present, echo other key=>values in the current array to a variable so...eg...let take the single array... (1 Reply)
Discussion started by: zeekblack
1 Replies

4. Shell Programming and Scripting

perl, put one array into many array when field is equal to sth

Hi Everyone, #!/usr/bin/perl use strict; use warnings; my @test=("a;b;qqq;c;d","a;b;ggg;c;d","a;b;qqq;c;d"); would like to split the @test array into two array: @test1=(("a;b;qqq;c;d","a;b;qqq;c;d"); and @test2=("a;b;ggg;c;d"); means search for 3rd filed. Thanks find the... (0 Replies)
Discussion started by: jimmy_y
0 Replies

5. Shell Programming and Scripting

Array in Perl - Detect several file to be in one array

Hi everyone I have one question about using array in perl. let say I have several log file in one folder.. example test1.log test2.log test3.log and the list goes on.. how to make an array for this file? It suppose to detect log file in the current directory and all the log file will... (3 Replies)
Discussion started by: sayachop
3 Replies

6. Shell Programming and Scripting

PERL : Read an array and write to another array with intial string pattern checks

I have an array and two variables as below, I need to check if $datevar is present in $filename. If so, i need to replace $filename with the values in the array. I need the output inside an ARRAY How can this be done. Any help will be appreciated. Thanks in advance. (2 Replies)
Discussion started by: irudayaraj
2 Replies

7. Shell Programming and Scripting

Compare file to array, replace with corresponding second array

ok, so here is the issue, I have 2 arrays. I need to be able to create a loop that will find ${ARRAY1 in the text doc, and replace it with ${ARRAY2 then write the results. I already have that working. The problem is, I need it to do that same result across however many items are in the 2... (2 Replies)
Discussion started by: gentlefury
2 Replies

8. Shell Programming and Scripting

Bash 3.2 - Array / Regex - IF 3rd member in array ends in 5 digits then do somthing...

Trying to do some control flow parsing based on the index postion of an array member. Here is the pseudo code I am trying to write in (preferably in pure bash) where possible. I am thinking regex with do the trick, but need a little help. pesudo code if == ENDSINFIVEINTS ]]; then do... (4 Replies)
Discussion started by: briandanielz
4 Replies

9. Shell Programming and Scripting

Search if file exists for a file pattern stored in array

Hi experts, I have two arrays one has the file paths to be searched in , and the other has the files to be serached.For eg searchfile.dat will have abc303 xyz123 i have to search for files that could be abc303*.dat or for that matter any extension . abc303*.dat.gz The following code... (2 Replies)
Discussion started by: 100bees
2 Replies

10. Shell Programming and Scripting

Bash arrays: rebin/interpolate smaller array to large array

hello, i need a bit of help on how to do this effectively in bash without a lot of extra looping or massive switch/case i have a long array of M elements and a short array of N elements, so M > N always. M is not a multiple of N. for case 1, I want to stretch N to fit M arrayHuge H = (... (2 Replies)
Discussion started by: f77hack
2 Replies
All times are GMT -4. The time now is 01:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy