Replace missing value with cell above in either Perl or MySQL? -

Replace missing value with cell above in either Perl or MySQL? -

i'm importing csv file of contacts , 1 parent has many children leaves duplicated values blank. need create sure populated when reach database however.

is there way can implement next when i'm importing .csv file perl , exporting mysql?

if (value null)

value = value above.

thanks!

why don't place individual values read csv file array (e.g. @field_data). when encounter empty field while iterating on row (e.g. column 4) can write

unless (length($csv_field[4])) { $csv_field[4] = $field_data[4] }

mysql perl csv