Exporting a view to tabular text

HCL Domino Domino Forum
1

Hello, I’ve been trying to export a view with special documents to a tubular text but I haven’t been able to do it.My view has multiple lines with a single column row:

What I’ve done is this:

  1. In the View Properties box:

Changed the Lines per row to the number of new lines I wanted “7” to include in the row. Selected Shrink rows to content.

  1. In the Column Properties box:

Choose New Line as the Multi-value separator. I deselected Show multiple values as separate entries checkbox.

In the code of the column formula, I have

@Trim(var1:var2:Var3:Var4:Var5:Var6:Var7)

In the view I can see the information perfectly, even though is the same document you can see the information separated for new lines but when I want to export the view as tabular text, I do not see the document separated as the view.

For example, below there are three documents:

14327768689108071101000080000020791539 14327768689108071102000060000016120327

13169029371408113201000930003258807355

19712268307308111601003120130996861523 19712268307308111602000810024468180705

But I should see this.

14327768689108071101000080000020791539

14327768689108071102000060000016120327

13169029371408113201000930003258807355

19712268307308111601003120130996861523

19712268307308111602000810024468180705

Also when it finishes the information between the lines, there is a special character “hex 00” instead of “hex 0d 0a” which is a carriage return.

If someone can help me I will be so grateful.

Thanks in advance.

2

Subject: Exporting a view to tabular text

This might help:

It’s a very simple and easy to adopt solution that basically does the following:

  1. Drop an Excel “template”.

  2. Populate said Excel “template” to make your Excel spreadsheet.

Now, this is basically done with the setup of a document that acts as a Report Template. Simply define one of the Metrics in the example with your formula “@Trim(var1:var2:Var3:Var4:Var5:Var6:Var7)” and you should be good to go!

HTH,

-Chris

3

Subject: RE: Exporting a view to tabular text

Christ.Thank you for your response but I do not get what your are trying to explain me, could you be more specific, I do not want to export my data to excel, what I want is to export my data to simple txt file.

Thanks

4

Subject: RE: Exporting a view to tabular text

Ah - sorry, I hear “export data” and my mind assumes you’re going into Excel.

If you’re looking to export and get this:

14327768689108071101000080000020791539

14327768689108071102000060000016120327

13169029371408113201000930003258807355

19712268307308111601003120130996861523

19712268307308111602000810024468180705

You might as well go into Excel - it’s going to give you more options on a whole. Once you’re in there, you can play with the formatting of the data and then simply save it out to whatever format you prefer.

Curious though - what exactly are you going to do with the exported data? ie., what’s it going to be used for? Knowing that, we might be able to come up with a smoother process.

HTH,

-Chris

5

Subject: RE: Exporting a view to tabular text

Chris.Thank you so much, you are so kind.

I need to export the data to a tabular text in order to run a batch process in our mainframe.

My problem is that the data that I am exporting to, is not consistent, when I export it and there is a “New Line” in the same document, the file exported has got a estrange character, it does not interpret it as carriage return.