|
Post by filecurrupt on Oct 30, 2009 16:20:21 GMT
hey guys, how to convert an excel file into a txt one (with same tabulation etc etc) ?
|
|
|
Post by |'L0.| on Oct 30, 2009 16:56:07 GMT
Depends what exactly you want to export out...txt file is a "flat" file so it obeys different rules. If you just want output then consider xml type but yeah should be possible. Check: www.cpearson.com/excel/ImpText.aspx
|
|
|
Post by filecurrupt on Oct 31, 2009 9:14:59 GMT
hi, well if i have an excel page full of strings like this: 0145556123420102009234520102009 58480 focus dailies -3.50 01000000035015000040020 pz 01 kind of document 455561234 number of invoice 20102009 date of invoice 2345 ddt number 20102009 date of ddt 58480 article code focus dailies -3.50 description 01000000035015000040020 (quantity price discount price discounted and iva) pz unit how can i convert it in a txt page with same tabulation and same fields without losing white spaces? Maybe a converter program?
|
|
|
Post by |'L0.| on Oct 31, 2009 15:34:24 GMT
The link i given you explains how to do exactly that. Don't be confused by the look of it, it's actually pretty much simple, it works as macros. If you don't know what macro is then try to [google] programming in excel [/google] to better understand it.
|
|
|
Post by filecurrupt on Nov 2, 2009 17:37:35 GMT
yes, at first look it seems a lil complicated but i will check it with the appropriate attention, thx!
|
|