I'm working a program called Cardiff Teleform which captures hand/machine print data or choice fields from images & as well allows VBA scripts to perform additional functionality.
I have multiple fields listing different Product ID & a user will enter in quantity ordered. Not all fields will be entered in with the value of quantity ordered. So if I have a field named "A123" & a value of "5" in this field, I need VBA to format the csv export so that Teleform will export in the following manner:
Only if quantity is completed
then perform this while exporting to csv comma delimited:
insert DETL in first cell of first available row
delete first character of fieldname (delete A)
insert fieldname into next cell ex: 123
insert quantity ordered into next cell.
So eachtime a quantity is entered, the data will be exported to a new row.
DETL then fieldname then quantity.
Example:
DETL,123,6,,,,,
DETL,456,2,,,,,
I have multiple fields listing different Product ID & a user will enter in quantity ordered. Not all fields will be entered in with the value of quantity ordered. So if I have a field named "A123" & a value of "5" in this field, I need VBA to format the csv export so that Teleform will export in the following manner:
Only if quantity is completed
then perform this while exporting to csv comma delimited:
insert DETL in first cell of first available row
delete first character of fieldname (delete A)
insert fieldname into next cell ex: 123
insert quantity ordered into next cell.
So eachtime a quantity is entered, the data will be exported to a new row.
DETL then fieldname then quantity.
Example:
DETL,123,6,,,,,
DETL,456,2,,,,,
