S
Seth
I am importing a CSV file that contains fields with
required character lengths when used with the parent
application. I would like to use Excel to edit this file,
however I am unable to enable a fixed Character Length for
the cells.
Example: The database file (Exported to .csv) has a
customer name 'Smith John' as one of the comma separated
values. This name is ten characters is length (includign
the space). However, the database file reserves twenty
spaces for each customer name. So 'Smith John'(10 spaces)
is actually 'Smith John '(20 spaces).
Excel removes/ignores these extra spaces when imported,
thus they are no longer allied when I export back to a CSV
file.
Is there a way to force/fix the character length of a cell?
Thank you in advance for your time.
required character lengths when used with the parent
application. I would like to use Excel to edit this file,
however I am unable to enable a fixed Character Length for
the cells.
Example: The database file (Exported to .csv) has a
customer name 'Smith John' as one of the comma separated
values. This name is ten characters is length (includign
the space). However, the database file reserves twenty
spaces for each customer name. So 'Smith John'(10 spaces)
is actually 'Smith John '(20 spaces).
Excel removes/ignores these extra spaces when imported,
thus they are no longer allied when I export back to a CSV
file.
Is there a way to force/fix the character length of a cell?
Thank you in advance for your time.