"write to file" is posting all data within 1 column
-
I'm trying to use the "write to file" block and all of the 'columns' are posted in the first row.
I know this was a problem a few years ago and the admin fixed it but the problem is back again, unless I'm doing something wrong?
-
@coinmaster These values are what is called comma separated, am not sure but if this is a CSV then I think this is all you can do. the ; is what is used to separate values (in this case), you can get excel to place each value into separate cells but it's not a simple task.
|If this helps this is how I get data from a comma separated sheet into another.
=IFERROR(('C:\Users\Bob\AppData\Roaming\MetaQuotes\Terminal\06980EAAF7FCC460D7BD131105CC3518\MQL4\Files\folder[csv document name]sheet name'!$A2)," ")
Hope this helps
-
But there have been multiple other threads about the 'write to file' block where people show that it writes the data into different columns.
-
excel has a feature that will allow you to separate similar data in single columns into a column of its own. I know it doesnt help with the initial problem but maybe?
-
By breaking the data into separate columns, you'll have more flexibility when working with it in your spreadsheet.
-
To get the data into separate columns in Excel, you could use the "Text to Columns" feature. In Excel, select the column with the data, go to the "Data" tab, and choose "Text to Columns." Then, just choose the delimiter (in your case, a comma or semicolon) to split the data into multiple columns.
Alternatively, if you're working with a more complex file structure, you might want to explore using some VBA scripting to automate the process. There are plenty of guides online that walk through the specifics of writing data to a file in a structured format, which might be exactly what you need. For example, you can check out www.myexcelonline.com for some tips on how to manage CSV files and automate data processing in Excel.
