Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ICsv (moved from 'QM 2.3.0 beta' topic)
#1
Hi Gindi,

Beta looks awsome! I like the iCSV interface. Is there any maximum on the size of the table by chance? I was using a StringMap to do a find and replace in one column of an iCSV. It works okay for ~60K rows but I could not get the job to complete for 500K rows.

-Jimbog
#2
Quote:Is there any maximum on the size of the table by chance?
no
Quote:I was using a StringMap to do a find and replace in one column of an iCSV.
please show the code
#3
int i c
str s t

ICsv v=CreateCsv
v.FromFile("$desktop$\data.csv")

IStringMap m=CreateStringMap(0)
s.getfile("$desktop$\map.txt")
m.AddList(s " ");;map uses tab as separator

if(!inp(c "Operate on which column?" "CSV Find & Replace")) ret

for i 0 v.RowCount
t=v.Cell(i c-1)
lpstr x=m.Get(t)
if(x) v.Cell(i c-1)=x
else v.Cell(i c-1)="Not Found"
v.ToFile("$desktop$\output.csv")
bee 2000 200
#4
Works slowly when replacing many values in a big file. Will optimize it in next QM 2.3.0 version. Thank you.


Forum Jump:


Users browsing this thread: 1 Guest(s)