VB POPULATE DATA WITH PREVIOUS ROW

Boh Boh

• 2019年05月25日 02:58
• 編輯於

I have CSV database as below with empty fields, seperated by comma. 

ABC Corp,COMSAT MEDIA 37063,PC,USER1,11
,,,USER2,7
,,,USER3,3
,,,USER4,1
,,,USER5,1
DEF Ptd,DSTECH MYTI17-1832,FIREWALL,WALL01,1
,,,WALL02,2

Would it be possible if I select only (for print) the 7th record, the empty field of 7th row data will follow that of 6th row data?

If (LEN(Field("fnf.fnf.nil")) > 0 ) Then
Value = Field("fnf.fnf.nil")
End If

I have tried the above script and works only if all records are selected. Any ideas to proceed?

 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2019年05月28日 19:21

  I dont think so as if you are only selecting record 7 then the information for record 6 wont be loaded into memory

  However, I guess, if you can save the record number you have selected somehow you could use the vb ReadLine  method to readline line X-1 into memory and then do you checks to see if the field is empty and if it is add the value from the readline field instead 

  0

請登入寫評論。