How to create Tabdelimited file from edit script

[#1]

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.....

[kaushiknsolanki]

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

[#3]

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....

[kaushiknsolanki]

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

[erichshiino]

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

[#6]

Erich

Yes it is working but it is showing syntax error .

Why it is showing like that?

Do you have any idea?

Thanks...

[sridhar240784]

Ravi,

What error it is showing? While you are running the script it is showing?

- Sridhar

[erichshiino]

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