How to prepare TCS import file?
1. We delete all extra lines in file
so we get this result
2. Next we need create two columns after SWIPE DATE column, like this
3. After you select the entire SWIPE DATE column > go in Data -> Text to colum -> you choose delimited - > and in TCS case you uncheck tab and check other and tpe C -> next and finish, so you get this result
and we need delete these E column, because we do not need it anymore
4. Save document.
Note, you should create Diesel#2 and D.E.F. Pump products in Atlassys as well.