<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi all,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
It seems to me that the problem here is not so much how to export to Excel, but how to export only the first of 10 equal records. Maybe the easiest sollution is:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<ol>
<li><span>export everything to Excel</span></li><li><span>then use the Excel feature to find and remove duplicates<br>
</span></li></ol>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div>Piet de Keyser</div>
<div>Belgium<br>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Van:</b> isis-users <isis-users-bounces+piet.dekeyser=ucll.be@iccisis.org> namens Daniel Motola <danymot2007@gmail.com><br>
<b>Verzonden:</b> woensdag 22 september 2021 11:54<br>
<b>Aan:</b> Soraya Ferraz Lima <soyferrazlima@gmail.com><br>
<b>CC:</b> Lista Isis <isis-users@iccisis.org><br>
<b>Onderwerp:</b> Re: [Isis-users] Ayuda con el formato de vista previa</font>
<div> </div>
</div>
<div>
<p>Hi Soraya,</p>
<p>When you said you want to extract the data what do you want to do? Print the information? Export to Excel?</p>
<p>They are different options to do it.<br>
</p>
<p>Regards,</p>
<p>Daniel<br>
</p>
<div class="x_moz-cite-prefix">On 9/22/21 12:47 AM, Soraya Ferraz Lima wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi Daniel!
<div><br>
</div>
<div>It's in ABCD v 2.2.</div>
<div>It's not an error, all the mfns are working properly. I just want to extract the data using a pft.</div>
<div><br>
</div>
<div>Thanks </div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">Em qua., 22 de set. de 2021 às 01:05, Daniel <<a href="mailto:danymot2007@gmail.com">danymot2007@gmail.com</a>> escreveu:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px
0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="auto">Hi Soraya,
<div dir="auto"><br>
</div>
<div dir="auto">It's in ABCD? Or winisis? In any case do a full invertion of the index of the database. If this does not fix the problem, recreate a new record and delete the previous one.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Regards</div>
<div dir="auto"><br>
</div>
<div dir="auto">Daniel</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Tue, Sep 21, 2021, 11:35 PM Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" target="_blank">soyferrazlima@gmail.com</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px
0.8ex; border-left:1px solid
rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hi all!
<div><br>
</div>
<div>Does someone know how to solve this?</div>
<div><br>
</div>
<div>
<div>In my book database, I have 10 copies of the same book, each one in one record (mfn 1, mfn 2, ...) but in the report I would like to display/export in Excel, only the data of the first record (since they are all the same).</div>
<div><br>
</div>
<div>Is there a way to do this?</div>
<div><br>
</div>
<div>Thank you for your attention! </div>
</div>
<div><br>
</div>
</div>
</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">Em ter., 14 de set. de 2021 às 21:07, Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" rel="noreferrer" target="_blank">soyferrazlima@gmail.com</a>> escreveu:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px
0px 0.8ex; border-left:1px solid
rgb(204,204,204); padding-left:1ex">
<div dir="ltr">Não funciona pois são registros diferentes... Tenho 10 registros com 10 títulos iguais.
<div><br>
</div>
<div>Att,</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">Em ter., 14 de set. de 2021 às 20:33, Ernesto Spinak <<a href="mailto:spinaker@adinet.com.uy" rel="noreferrer" target="_blank">spinaker@adinet.com.uy</a>> escreveu:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px
0px 0px 0.8ex; border-left:1px solid
rgb(204,204,204); padding-left:1ex">
<div dir="auto">Usa v245[1]
<div dir="auto"><br>
<div dir="auto">Ernesto spinak </div>
</div>
</div>
<div class="x_gmail_extra"><br>
<div class="x_gmail_quote">El 14 sep. 2021 20:22, Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" rel="noreferrer" target="_blank">soyferrazlima@gmail.com</a>> escribió:<br type="attribution">
<blockquote style="margin:0px 0px 0px
0.8ex; border-left:1px solid
rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div dir="ltr">-----</div>
<div dir="ltr">Em português
<div><br>
</div>
<div>
<div>Espero que todos os colegas estejam bem!</div>
<div><br>
</div>
<div>Em minha base de livros, tenho 10 exemplares do mesmo livro, porém no relatório gostaria de exibir/exportar no Excel, somente o primeiro.</div>
<div><br>
</div>
<div>Saberiam me dizer como deve ser esse formato?</div>
<div>Tentei utilizar if nocc(v245)=1 then ..., mas ai não me exibe nada já que o índice de ocorrências é maior que 1.</div>
<div><br>
</div>
<div>Agradeço a atenção!</div>
</div>
<div><br>
</div>
</div>
</div>
<br>
<div>
<div dir="ltr">Em ter., 14 de set. de 2021 às 20:05, Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" rel="noreferrer" target="_blank">soyferrazlima@gmail.com</a>> escreveu:<br>
</div>
<blockquote style="margin:0px 0px 0px
0.8ex; border-left:1px solid
rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div>¡Espero que a todos los compañeros les vaya bien!</div>
<div><br>
</div>
<div>En mi base de libros, tengo 10 copias del mismo libro, pero en el informe me gustaría mostrar / exportar en Excel, solo el primero.</div>
<div><br>
</div>
<div>¿Podrías decirme cómo debería ser este formato?</div>
<div>Intenté usar if nocc (v245) = 1 entonces ..., pero luego no me muestra nada ya que la tasa de ocurrencia es mayor que 1.</div>
<div><br>
</div>
<div>¡Agradezco la atención!</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
</blockquote>
</div>
_______________________________________________<br>
isis-users mailing list<br>
<a href="mailto:isis-users@iccisis.org" rel="noreferrer" target="_blank">isis-users@iccisis.org</a><br>
To manage your own subscription options go to: <a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.iccisis.org%2Flistinfo%2Fisis-users&data=04%7C01%7C%7Ca0d47cafc8e64ffc048d08d97db21de1%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637679026813426792%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=H5c6MPumLYDDQwJht5gKuaqAbJ%2FCjs43%2Bi9YIvjLF60%3D&reserved=0" originalsrc="http://lists.iccisis.org/listinfo/isis-users" shash="mnrUeSsTlgEDu1IXWqbTbAsjah6Pn5npUTf5Zz4DTQJ4yghzm3U6D/fit0+g1Ba/3p0CskjJ2USNR0rFeH0OMmexeNtIIjFpPOphb0hoQTbLxbTvCNG9hPqqnOwStlIP4/m7efjI4ob3V1dXUm8xxxcnEGXGQj8SnwEjy/tZbhM=" rel="noreferrer noreferrer" target="_blank">
http://lists.iccisis.org/listinfo/isis-users</a><br>
Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl" rel="noreferrer" target="_blank">
hlrutten@xs4all.nl</a><br>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</body>
</html>