Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to create Tabdelimited file from edit script when reloading happens.
Ex:
Sample:
Load * inline
[A,B
1,2
3,4
];
If i will write like this
Store Sample into Sample.txt(txt); [The generated text file is comma seperated] but i need Tab delimiter text file.
The differance between Comma seperated file and tab delimiter file is one tab space without having comma.
ex:
A B
1 2
3 4
let me know how to modify my store command
Thanks.....
Hi,
Not sure this will work or not, but try this.
Set object = ActiveDocument.GetSheetobject("CH01")
object.export "C:\ABC.txt",Chr(11),0
Regards,
Kaushik Solanki
Kaushik,
If we writ like this,It is possible to generate tabdelimiter files using macro.
obj.Export vQvWorkPath.GetContent.String&"MyNew.txt"," "
But i want to generate it from editscript just like Store command for qvd.
Thanks....
Hi,
I dont think so you will be able to do it from Script, but yes with macro you can do like this.
Regards,
Kaushik Solanki
Hi, Your store command should look like this:
Store Ex into TABLE.txt (txt, delimiter is '\t');
In QV 10 SR2, the syntax checker doesn't like, but it works!
Hope this helps,
Erich
Erich
Yes it is working but it is showing syntax error .
Why it is showing like that?
Do you have any idea?
Thanks...
Ravi,
What error it is showing? While you are running the script it is showing?
- Sridhar
I'd like it's like a bug.
Some versions doesn't recognize noconcatenate, for example.
Sometimes, it you write some indirect set analysis, syntax checker will not recognize it.
If it works,that's the important part
Regards,
Erich