OCRTEXT Filtered

[Cristhian_Macia]

Can I use the OCRTEXT formula to bring me the text of an image but for several columns and not just one? Example I want the name column to only bring me the first name and in the last name column only the last name, I understand that this yes it can be done with the OCR () formula (OCR(“ocrname”,[Image column],“column 1”))but this one does not recognize the text and the OCRTEXT formula(OCRTEXT([Image column])) does

[Marc_Dillon]

OCRTEXT() will return all of the text in the image. At this point you can use any other text manipulation methods you want to split up that returned Text.

help.appsheet.com

SUBSTITUTE()

Text with replacements

help.appsheet.com

SPLIT()

List from text

help.appsheet.com

LEFT()

Left-most characters of text

etc…

Also, I couldn’t find any documentation on any OCR() method, so not sure what that’s about.