04-22-2010 07:20 AM
I have a text file (origin file) (separator = vbtab) with the following structure:
First line contains names of channel and others lines are data
Name1 Name2 Name3 . . . .
45,4 dfr 17/05/2009..........
34,1 fgh 13/04/2008.........
. . .
. . .
. . .
1)For load of data I use *.stp filter and I create my channels with data:
Group1/Name1;
Group1/Name2;
Group1/Name3;..........
2) I change some values into my channels.
3) I need to export my channels into a text file with the same structure of my origin text file.
I usually use: OpenTextFile writeline method.....
Is it possibile to save data from my channels to a text file with the structure of my origin file and use for it some filter (same of .stp) or others methods and don't write every line into a text file?
Thanks,
Yustas
Solved! Go to Solution.
04-22-2010 05:43 PM
Maybe those lines help
Option Explicit
dim csvFilename : csvFileName = "D:\temp\EXAMPLE.csv"
DataFileSave "<filename>" & replace(replace(csvFileName, "&", "&"), "<", "<") & "</filename>" &_
"<delimiter>tab</delimiter><decimalpoint>,</decimalpoint><timeformat>DD/MM/YYYY hh:mm:ss</timeformat>" &_
"<channelnames>yes</channelnames><startrow>1</startrow>", "CSV"
Greetings
Andreas
04-23-2010 03:41 AM
Thank you AndreasK!
It work great!