Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to create Tabdelimited file from edit script

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

7 Replies
Highlighted
MVP & Luminary
MVP & Luminary

How to create Tabdelimited file from edit script

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: How to create Tabdelimited file from edit script

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: How to create Tabdelimited file from edit script

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Partner
Partner

Re: How to create Tabdelimited file from edit script

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

Highlighted
Not applicable

Re: How to create Tabdelimited file from edit script

Erich

Yes it is working but it is showing syntax error .

Why it is showing like that?

Do you have any idea?

Thanks...

Highlighted
Creator III
Creator III

Re: How to create Tabdelimited file from edit script

Ravi,

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

- Sridhar

Highlighted
Partner
Partner

Re: How to create Tabdelimited file from edit script

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