markup - How can I convert an Excel table into Trac Wiki Table format? -


i've seen copy & paste converters mediawiki or html format. not find 1 converts trac wiki format (wikiformattting) uses pipes separate cells, such as:

||cell 1||cell 2||cell 3||  ||cell 4||cell 5||cell 6|| 

you save excel sheet csv file. command prompt (assuming running windows xp or newer) type command:

for /f "tokens=1,2,3 delims=," %a in (mycsvfile.csv) ((echo ^|^|%a^|^|%b^|^|%c^|^|) >> mywikifile.txt) 

the number of tokens depends on how many columns have. 26 columns way in single pass increasing number of tokens , adding corresponding number of variable names %d, %e, etc.


Comments

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

jquery - appear modal windows bottom -

c++ - Compiling static TagLib 1.6.3 libraries for Windows -