Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
earasing arrays
hi
is there any way to erase array elements having no values stored in it? "if len(array(a,b))<=0 then erase" will this work? thanks -- hemu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
earasing arrays
The code you show does not demonstrate that the array has no values in it,
it is just testing a particular element of the array. Erase clears an array down, or as help puts it, Reinitializes the elements of fixed-size arrays and releases dynamic-array storage space. But if the array is empty, there is no need to clear it is there not? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi is there any way to erase array elements having no values stored in it? "if len(array(a,b))<=0 then erase" will this work? thanks -- hemu |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
earasing arrays
hi Bob
i'm using writline method to put array containts in text file But while collecting data some lines in other text files are blank which are stored in an array so again while writing to new txt file these lines get written angain therefor i want to delete or erase empty elements in an array please help -- hemu "Bob Phillips" wrote: The code you show does not demonstrate that the array has no values in it, it is just testing a particular element of the array. Erase clears an array down, or as help puts it, Reinitializes the elements of fixed-size arrays and releases dynamic-array storage space. But if the array is empty, there is no need to clear it is there not? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi is there any way to erase array elements having no values stored in it? "if len(array(a,b))<=0 then erase" will this work? thanks -- hemu |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
earasing arrays
can you show us the code?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi Bob i'm using writline method to put array containts in text file But while collecting data some lines in other text files are blank which are stored in an array so again while writing to new txt file these lines get written angain therefor i want to delete or erase empty elements in an array please help -- hemu "Bob Phillips" wrote: The code you show does not demonstrate that the array has no values in it, it is just testing a particular element of the array. Erase clears an array down, or as help puts it, Reinitializes the elements of fixed-size arrays and releases dynamic-array storage space. But if the array is empty, there is no need to clear it is there not? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi is there any way to erase array elements having no values stored in it? "if len(array(a,b))<=0 then erase" will this work? thanks -- hemu |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
earasing arrays
hi bob
if not len(atrray(n)<=0 then s.writeline array(n) end if this code worked fine thanks -- hemu "Bob Phillips" wrote: can you show us the code? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi Bob i'm using writline method to put array containts in text file But while collecting data some lines in other text files are blank which are stored in an array so again while writing to new txt file these lines get written angain therefor i want to delete or erase empty elements in an array please help -- hemu "Bob Phillips" wrote: The code you show does not demonstrate that the array has no values in it, it is just testing a particular element of the array. Erase clears an array down, or as help puts it, Reinitializes the elements of fixed-size arrays and releases dynamic-array storage space. But if the array is empty, there is no need to clear it is there not? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi is there any way to erase array elements having no values stored in it? "if len(array(a,b))<=0 then erase" will this work? thanks -- hemu |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
earasing arrays
So where do you need to clear it? Does erase not work fine?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi bob if not len(atrray(n)<=0 then s.writeline array(n) end if this code worked fine thanks -- hemu "Bob Phillips" wrote: can you show us the code? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi Bob i'm using writline method to put array containts in text file But while collecting data some lines in other text files are blank which are stored in an array so again while writing to new txt file these lines get written angain therefor i want to delete or erase empty elements in an array please help -- hemu "Bob Phillips" wrote: The code you show does not demonstrate that the array has no values in it, it is just testing a particular element of the array. Erase clears an array down, or as help puts it, Reinitializes the elements of fixed-size arrays and releases dynamic-array storage space. But if the array is empty, there is no need to clear it is there not? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Hemant_india" wrote in message ... hi is there any way to erase array elements having no values stored in it? "if len(array(a,b))<=0 then erase" will this work? thanks -- hemu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrays | Excel Discussion (Misc queries) | |||
Avg Arrays | Excel Worksheet Functions | |||
Use of arrays | Excel Worksheet Functions | |||
arrays | Excel Programming | |||
Arrays | Excel Discussion (Misc queries) |