[EmData] Re: Indata - data manipulations

[Coletta Perry - Em Support]

Didier,

Thank you for your inquiry.

Yes, this can be accomplished in InData.

It is fairly complex and involves saving data into variables, etc.

And the requirement with multiple authors could get even more difficult.

We have a sister company who has created InData prototypes of this sort in
the past.

Would you like me to forward your query directly on to them?



Regards,

Coletta Perry
Em Software Support / support at emsoftware.com / www.emsoftware.com
(+1) 740 284 1010, fax (+1) 740 284 1210







on 6/17/09 12:51 AM, Didier Mombrun at didier.mombrun at knowlink.net wrote:

> Hi
> 
> I would like to know if it is possible to make this with Xdata / Indata
> Without working in excel before ?
> 
> It is to make alphabetical Index !
> 
> I have an excel file with a list of book title "autors" in a colums
> and page Number in an other one
> There are duplicate lines with the same couple autor / page,
> There are lines with same autors with other page
> and multiple autors separated with "/" in the first colum
> 
> The résult : i would like to have only one autor and all the pages for
> each
> 
> Exemple
> Autors | Page
> Autor1 | 1
> Autor1 | 1
> Autor1 | 2
> Autor1 | 3
> Autor1 | 3
> Autor1 / Autor2 | 5
> Autor2 / Autor3 | 6
> Autor2 | 7
> 
> The résult i would like with xdata / Indata
> 
> Autor1 1, 2, 3, 5
> Autor2 5, 6, 7
> 
> Thanks to help me