How to get the values of a specific line in a table?

[#1]

Hello community,

I have a table that has multiple lines.

I loaded from an instruction LOAD.

My goal is to load the values of a specific line items in the text objects that I put on my sheet.

I do not know how to retrieve values from a specific line.

Thank you for your help.

[stephencredmond]

Hi,

Have you looked at the FieldValue function which will return the value in a field based on load order:

=FieldValue('Player', 2)

Regards,

Stephen

[#3]

The name of my field is : [Désignation de l''entreprise]

How i would use the FIELDVALUE statement?

[#4]

The name of my field is : [Désignation de l''entreprise]

I have done this :

FieldValue([Désignation de l'entreprise], 2) ;

FieldValue('[Désignation de l''entreprise]', 2);

but it's not worked. Please what am i correct??

[stephencredmond]

Hi,

Almost - because you have to use the text qualifier in the name, you don't need the square brackets. Your apostrophe complicates things a little:

=FieldValue('Désignation de l' & chr(39) & 'entreprise', 2)

Stephen

[#6]

Thank you Sir REDMOND