I am downloading some data and have the following code.
&mvt:field:label;&mvt:global:comma;
</mvt:foreach>
&mvt:global:new_line;
</mvt:if>
This code works ok when opened in notepad. data is horizontal line by line but not columned. It is a csv file ok but when I import it into Excel to get the columns it loads the data vertically instead of horizontally. Investigating Excel, Excels says it want a carriage return at the end of each line and apparently new_line is not a carriage return to Excel. Is there some other code other than new_line that I can use to get the data columned in Excel?
Thanks for any guidance
&mvt:field:label;&mvt:global:comma;
</mvt:foreach>
&mvt:global:new_line;
</mvt:if>
This code works ok when opened in notepad. data is horizontal line by line but not columned. It is a csv file ok but when I import it into Excel to get the columns it loads the data vertically instead of horizontally. Investigating Excel, Excels says it want a carriage return at the end of each line and apparently new_line is not a carriage return to Excel. Is there some other code other than new_line that I can use to get the data columned in Excel?
Thanks for any guidance
Comment