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 303026813 by Paul Walker on Monday 3rd of December 2018 04:21:19 PM
Old 12-03-2018
Exanding an array into another file.
Hi I have a text file that I need use as a osascript to format some Excel files. My commands are working between the osascript and Excel but what I would like to do is format the text file with an array.

Is there a way to expand the array variables into another text file while still retaining the original formatting?
I cant run the below code in the shell until the array has been expanded

Code:
source //Osascript_ForExcel_Shapes/Kernel/filelist_array
for $i in "${filelist_array[@]}"
        
osascript <<EOD
tell application "Microsoft Excel"
    activate
    set theWorkbookFile to "Macintosh HD:Osascript_ForExcel_Shapes:Working:"$i".xlsx"s
end tell
EOD

Below is the source filelist_array
Code:
declare -a filelist_array  
filelist_array=(
"R18-310805_Market_Summer_Customer_Campaign_QR_0328"
"R18_223497_Summer_Insiders_Q_0314"
)

I hope that I have explained myself clearly. What I am essentially triyng to do is format a proper command to run as an osascript.
Thank you very much for your help.
 

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

LEARN ABOUT DEBIAN

excel::template::plus::tt

Excel::Template::Plus::TT(3pm)				User Contributed Perl Documentation			    Excel::Template::Plus::TT(3pm)

NAME

       Excel::Template::Plus::TT - Extension of Excel::Template to use TT

SYNOPSIS

	 use Excel::Template::Plus::TT;

	 # this is most commonly used through
	 # the Excel::Template::Plus factory

	 my $template = Excel::Template::Plus::TT->new(
	     template => 'greeting.tmpl',
	     config   => { INCLUDE  => [ '/templates' ] },
	     params   => { greeting => 'Hello' }
	 );

	 $template->param(location => 'World');

	 $template->write_file('greeting.xls');

DESCRIPTION

       This is an engine for Excel::Template::Plus which replaces the standard Excel::Template template features with TT. See the
       Excel::Template::Plus docs for more information.

METHODS

   Accessors
       config
       template
       template_class
       params

   Excel::Template compat methods
       params ($name | $name = $value)>
	   This provides access to getting and setting the parameters, it behaves exactly like the standard CGI.pm-style param method.

       output
	   Returns the generated excel file.

       write_file ($filename)
	   Writes the generated excel file to $filename.

   Housekeeping
       DEMOLISH
	   This will cleanup any temp files generated in the process.

       meta
	   Returns the metaclass.

BUGS

       All complex software has bugs lurking in it, and this module is no exception. If you find a bug please either email me, or add the bug to
       cpan-RT.

ACKNOWLEDGEMENTS

       This module was inspired by Excel::Template::TT.

AUTHOR

       Stevan Little <stevan@iinteractive.com>

COPYRIGHT AND LICENSE

       Copyright 2007-2010 by Infinity Interactive, Inc.

       <http://www.iinteractive.com>

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-05-06					    Excel::Template::Plus::TT(3pm)
All times are GMT -4. The time now is 01:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy