Conversion of a tab delimited flat file to work in different locales. i.e. UK product file convert to US,DE,FR,JP
Import tab delimited source file into an array
set column positions for destination file. i.e. source col 1 = destination col 5, source col 3 = destination col 10
ideally we need a map of whats going where. some columns may not be exported while some new columns may be statically added at the time of export
the header can be hardcoded as this changes from locale to locale.
maybe to keep this tidy each locale could have a text file which holds the header, map and general config
certain columns may need some kind of conversion
currency_conv_col10 = USD;
//use something like [url removed, login to view] to convert GBP to USD
lang_conv_col8 = German;
//use [url removed, login to view] to translate english to german
size_conv_col2 = Age_to_CM;
//use some variables to change some strings '7 Years ' to '135'
// I will provide a full list
an example would be that the file suffixed with uk would convert to the file suffixed with de
Hi I have big experience with PHP, Excel and data processing (see my portfolio), so you can hire me. I always do my job fast and neatly. My Skype - avkiev. Feel free to contact me. Best regards Alex