I have a (hopefully) quick question with an easy answer! I made a lotus notes DB to read in a massive CSV file. As my code reads each line, some of the fields are blank. My output skips the blank cells and moves to the next cell for a value, which messes up the output format.

 

For example, three categories may be First name, Last name, age, and the csv file may be "john, carpenter, 45, mark, , 58, Anne, Rice, 62" 

and the table output would have mark's last name be 58, his age is Anne, etc.

 

Is there some code I can pop in to set a value to the blank cells or have them show as a blank, instead of using the next available value in the file?

 

and lets say I cannot simply go into the csv file and replace the blank lines with something like "."