StringSplit and several results in one

[yton]

Greetings,

the example here (http://www.autoitscript.com/autoit3/docs/functions/StringSplit.htm) says:

$days = StringSplit("Sun,Mon,Tue,Wed,Thu,Fri,Sat", ",")

;$days[1] contains "Sun" ... $days[7] contains "Sat"

I wonder, if it is possible to use a piece of array and return SEVERAL results

e.g. Wed,Thu,Fri,Sat as a one result

smth like $days[3-7]

?

thanks,

[Tvern]

$result = _ArrayToString($days,",",3,7)

[yton]

thanks, it worked

[yton]

I have another one Q:

what function should I use if I have more than 7 results?

thanks,

[jchd]

The same functions! What in the helpfile makes you believe that these functions are limited in such way?

[Melba23]

yton,

  Quote

if I have more than 7 results?

Go and read the Help file for _ArrayToString and pay particular attention to the $iEnd parameter.

M23

[yton]

  On 4/25/2010 at 6:04 PM, 'jchd said:

The same functions! What in the helpfile makes you believe that these functions are limited in such way?

the reality

that's the part of my script:

21 $array = StringSplit(ClipGet(), "ZZZ", 1)
22 MsgBox(0, "Clipboard contains:", $array[3])
23 For $i = 1 To 7 ;Loop
24  _ExcelWriteCell($oExcel, $array[$i], $i, 15)
25 Next

it works fine

but if i try to increase loops form 7 to 10 (fill in 10 cells in a column), it sends me an error message, saying

error: array variable has incorrect number of subscripts or subscript dimension range exceeded (about line 22)

and, of course, excel remains empty

loops 1 to 7 work fine

that's why i'm puzzled

Edited April 25, 2010 by yton

[Melba23]

yton,

You need to match the loop upper limit to the number of elements in the array.

When you use StringSplit, "the first element ($array[0]) contains the number of strings returned" (from the Help file). So you need to set your loop to that value:

; Get the array
$array = StringSplit(ClipGet(), "ZZZ", 1)
MsgBox(0, "Clipboard contains:", $array[3])
; Now set the loop to run through the elements that exist
For $i = 1 To $array[0]
    _ExcelWriteCell($oExcel, $array[$i], $i, 15)
Next

That should prevent the error. But if I were you , I would add a check to make sure that you actually have an array.

I hope that helps. Ask if anything is unclear.

m23

[yton]

thanks, m23

I am checking the beginning of the script and it seems to me that the problem is in the input data......

[yton]

problem found

i checked the input data, put it in the clipboard ad then manually put in excel

it splitted my array (supposed to be 1 row) in 3 rows because initial array was supposedly too big for it

however, when i split the array into strings, i request to show me the array(N) - small piece of data, not the whole array

and each cell is filled in with small $array[N], not the whole data input

now, i am puzzled again - why the script shows error?

Edited April 25, 2010 by yton

[yton]

please, help

[jchd]

No code, only guesswork! Remember that AutoIt arrays are zero-based, which means that an array of 5 elements like Local $Arr[5] = ['a', 'b', 'c', 'd', 'e'] has $Arr[0] = 'a' and $Arr[4] = 'e' (accessing $Arr[5] gives an error).

Is that related to your problem?

[yton]

  On 4/25/2010 at 7:55 PM, 'jchd said:

No code, only guesswork! Remember that AutoIt arrays are zero-based, which means that an array of 5 elements like Local $Arr[5] = ['a', 'b', 'c', 'd', 'e'] has $Arr[0] = 'a' and $Arr[4] = 'e' (accessing $Arr[5] gives an error).

Is that related to your problem?

actually, no

1) i call 50 arrays and ask to show me the 5th array' content and the error message pops out

2) i test the script with 50 arrays but i cut each array so that it has has far less data

and the script works fine...

i even use

$array = StringSplit(ClipGet(), "ZZZ", 1)
_ArrayToClip($array, 1)
MsgBox(0, "_ArrayToClip() Test", $array[5])

and it fails in the first case

Edited April 25, 2010 by yton

[jchd]

Without a solid clipboard content to test, we're talking thin air.

[yton]

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

- that's what excel faq says

perhaps, this is a problem?

it seems to me that I face somewhat internal limitation

but why in this case the _ArrayToClip does not work as well?

[yton]

  On 4/25/2010 at 8:07 PM, 'jchd said:

Without a solid clipboard content to test, we're talking thin air.

checked stats in word - my whole input data is about 70000 chars

will it solve the problem if I send you 15-paged word doc?

[jchd]

yton,

You have me lost. I can't understand clearly what you're talking about nor what your actual problem really is.

Form a table of day names, we went to clipboard copies of Excel large (too large?) cells, then to a 70Kb Word document and still I can't say which problem you encounter.

Please try to post sample simple code that demonstrates a problem or behavior you don't expect, along with the data which causes it, so we can reproduce/diagnose/explain.

[yton]

ok

perhaps, it's my fault (messy situation explanation)

1) I used the example script with day names to understand how StringSplit works

2) then I tried to combine it with _ExcelWriteCell - and it was ok

3) then I decided to apply this script to my needs - split big text in strings and paste each string in the corresponding excel cell - and it was ok as I used only 7 (number is randomly chosen) strings (results) to test my script.

However, when I used 10 results, the script started to show error

4) I checked manually the script part responsible for data input - it ended with send(^a^c) - so I pasted in in excel

and excel divided my text string into 3 (the clipboard was filled in 3 rows, not 1)

5) after that i read about length of excel cell contents (text) limitation (32,767 characters)

6) so i made a conclusion that excel cuts my strings and it causes errors of autoit.

after checking how the script work with less text amount, i was absolutely confident in it.

so, the question is: why autoit returns error if all operations are not handled in excel but in the clipboard?

why if i use

$array = StringSplit(ClipGet(), "ZZZ",

_ArrayToClip($array,

MsgBox(0, "_ArrayToClip() Test", $array[5])

it returns me an error again?

and what's the solution?

#include <IE.au3>
#include <Excel.au3>
#include <Word.au3>
#include <ClipBoard.au3>
#include <Array.au3>

; i get data from the clipboard here and set flags in the text for further StringSplit
$oWordapp = _WordCreate("Z:\_script\content2.doc")
$activate1 = WinGetTitle("content2.doc - Microsoft Word")
WinActivate($activate1)
Send("^v")
$oDoc = _WordDocGetCollection($oWordapp, 0)
$oFind = _WordDocFindReplace($oDoc, "<br><br>^p", "ZZZ")
$oFind = _WordDocFindReplace($oDoc, "^p", "")
Send("^a^c")
_WordQuit($oWordapp, 0)

$oExcel = _ExcelBookOpen("Z:\_script\content.csv")
_ExcelSheetActivate($oExcel, "content")

$array = StringSplit(ClipGet(), "ZZZ", 1)
MsgBox(0, "Clipboard contains:", $array[4])
For $i = 1 To $array[0] ;Loop
    _ExcelWriteCell($oExcel, $array[$i], $i, 15)
Next

[yton]

solution found

thank you for your replies and advices