Search found 626 matches

by Victorio
Mon Mar 04, 2024 3:18 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

Yes, i think about use HASH, but now works fine also with Var2Bin without problems. First I sort DBF to other temporary DBF, then in cycle delete sign duplicates, then delete it, and final i append to new database. When I use PACK, program often crashed, because I use append, with this eliminate del...
by Victorio
Wed Feb 28, 2024 1:42 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

Hi Chris, At the beginning I have a DBF (Visual Foxpro structure) and later I generate XLSX from it I originally wanted to solve it through Excel, but I don't know because of the problem. I need to delete records that have the same 35 out of 36 fields. I wanted to avoid working with arrays because I...
by Victorio
Tue Feb 27, 2024 8:09 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

My plan to sort records in DBF via INDEX UNIQUE failed because my index key is longer than 240 characters, I also tried Sort, it takes it, but again I would have to deal with comparing a lot of values (35 fields). I haven't tried the activeX SORT method yet because I'm very curious as to why RemoveD...
by Victorio
Tue Feb 27, 2024 5:17 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

Ok, understand, thanks.
by Victorio
Tue Feb 27, 2024 4:22 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

looks this not work as I want. duplicates can be in different places of the table, not only the following records. then if this can work, must first sort records. also work your example with "." and not only with ":" ? I modify this as here : FOR I = 1 TO oRange:Rows:Count IF I = oRange:Rows:Count E...
by Victorio
Tue Feb 27, 2024 4:07 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

SlavkoDam :
thank you very much, I will try it.
Viktor
by Victorio
Tue Feb 27, 2024 3:03 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

Hi Jimmy, This syntax is not correct for Xbase++ ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes I tryed ActiveSheet.Range("A1:C100"):RemoveDuplicates(Columns:=Array(1,2), Header:=xlYes) but Xbase return Error Automation/6500 The parameter is incorrect. 0 Operation :...
by Victorio
Mon Feb 26, 2024 2:39 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

everything looks to RemoveDuplicates(param1,param2) not accept param1 as Array, but only number of one column.
I do not understand why, or how syntax need use to process
by Victorio
Mon Feb 26, 2024 1:46 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Re: Excel remove duplicates

Hi, thanks for info, I tryed several versions of syntax but when I call RemoveDuplicates, get Error Automation/6500. Description : Invalid index, 0Error in array index Operation ? RemoveDuplicates for example : oUsedRange := oSheet:usedrange oUsedRange:RemoveDuplicates( {1, 2}, xlGuess ) oUsedRange:...
by Victorio
Fri Feb 23, 2024 3:05 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 853

Excel remove duplicates

Hi what is the easiest way to remove duplicate rows - rows that have the same selected columns, i.e. not all for the created Excel file? I can also do it through the database using the UNIQUE index, but it's more complicated. I'm trying what I found on the internet for VBA, but I don't know the synt...