Extracting coordinates from AI Text Recognizer in a collection

(0) Share

Report

Posted on by Community Power Pla...

so im working on an app to extract coordinates of text from the text recognizer and here's my code:

Set(X, TextRecognizer.Results);

ClearCollect(Cords,{});
Collect(Cords, {Values: X});

but this gives me a nested collection with all of it in an array and then box coordinates in another one. I want a tabular format where i get the text and left , height , top and width in seperate columns. Is there any way to do that as i wanna import it to excel using

Toexcel.Run(JSON(Cords,JSONFormat.IncludeBinaryData))

which works but its all in one cell.

for example i want the result to be:

Text	Left	Top	Width	Height
a	1	2	3	4
b	1	2	3	4

Categories:

AI Builder

All responses (1)

Answers (1)

Verified answer

Antrod on at

Like (1)

Report

Re: Extracting coordinates from AI Text Recognizer in a collection

Hi @Anonymous ,

It seems to work with this code:
Set(X, TextRecognizer1.Results);
Clear(CordsFinal);
ForAll(X, Collect(CordsFinal, {Text: First(X.Text).Text, Left: First(X.BoundingBox).BoundingBox.Left, Top: First(X.BoundingBox).BoundingBox.Top, Width: First(X.BoundingBox).BoundingBox.Width, Height: First(X.BoundingBox).BoundingBox.Height}));

Let us know if that helps!