Resolved Define max width of each field

Hello Davide,
There is no option in CSVI to define max width for a field but each field has its maximum length already set in database table like for example VARCHAR(50) or INT(1). You can check your PHPMyAdmin for the same by clicking on a table and going to Structure tab and look for Type column.

Hello Tharuna,

thank you very much for your quick answer.

Yes, I know that in the db is written, but I need to do it in the export because a shipping provider needs a maximun width for each field, some of 7 chars, other 35 and other widths...

Nothing is possibile with the rules? Regular expressions or something like that?


Thanks a lot,
Davide

Hello Davide,

Nothing is possibile with the rules? Regular expressions or something like that?

There is an option in CSVI multi replace rule with operation as Substring where you set the start(should be 0 to start at first character) and end of the character say 6 for the field you need only 7 characters to be read. Apply the rule on the template field and export. Check and let me know.