cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Extract data using Long Text for an column

aelbachiri-ext
Discoverer
0 Likes
756

Hello community,

I want to retrieve the BO dimension called Ingredient on my list report BO.

this is his difinition:

When i export it, i realize that on certain lines, the list is truncated even though the list is in full on our web application (ALICE).

when i use the Excel sheet and using nbcar function, i have the export stops at 255 characters in the cell "Ingredients".

Example:

* On our application ALICE :

Ingredients:

LAIT écrémé - CREME - Sucre 7.9% - Eau - Caramel 2.5% (Sucre, Eau) - Amidon transformé de riz et de maïs - Poudre de LAIT écrémé - Beurre - Jus de citron - Arôme naturel - Epaississants : Pectine, Gomme guar - Fleur de Sel - Sirop de sucre caramélisé - Ferments lactiques (LAIT). LAIT d’origine France

* Report Webi :

Ingredients:
LAIT écrémé - CREME - Sucre 7.9% - Eau - Caramel 2.5% (Sucre, Eau) - Amidon transformé de riz et de maïs - Poudre de LAIT écrémé - Beurre - Jus de citron - Arôme naturel - Épaississants : Pectine, Gomme guar - Fleur de Sel - Sirop de sucre caramélisé - Fe

Can you please, help me to resolve this issue.

thank you,

Ahmed,

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Likes