Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ICsv (moved from 'QM 2.3.0 beta' topic)
#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


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)