topic Re: How to create Tabdelimited file from edit script in QlikView

How to create Tabdelimited file from edit script

Thu, 11 Aug 2011 08:50:44 GMT

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

How to create Tabdelimited file from edit script

kaushiknsolanki — Thu, 11 Aug 2011 08:57:58 GMT

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

Re: How to create Tabdelimited file from edit script

Thu, 11 Aug 2011 09:07:08 GMT

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

Re: How to create Tabdelimited file from edit script

kaushiknsolanki — Thu, 11 Aug 2011 09:11:08 GMT

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

Re: How to create Tabdelimited file from edit script

erichshiino — Thu, 11 Aug 2011 10:34:18 GMT

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

Re: How to create Tabdelimited file from edit script

Fri, 12 Aug 2011 09:23:30 GMT

Erich

Yes it is working but it is showing syntax error .

Why it is showing like that?

Do you have any idea?

Thanks...

Re: How to create Tabdelimited file from edit script

sridhar240784 — Fri, 12 Aug 2011 09:52:38 GMT

Ravi,

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

- Sridhar

Re: How to create Tabdelimited file from edit script

erichshiino — Fri, 12 Aug 2011 11:01:01 GMT

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