About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I extract Arabic language text from file?

  • 15 May 2024
  • 8 replies
  • 150 views
Mhamed Samy
Userlevel 1
Badge +3

How do I extract specific data from text?


I have a file that contains data in both Arabic and English
This document is in PDF format,


I used Webhook but it gives me the full text of the document
1 - I want to know how to extract specific data from the text in the document. I tried using Qurey, but it gave me the entire file. Is there a tool in Zapier that can do that?


2 - When I extract the text written in Arabic, a line message appears, and I cannot extract the data of the document written in Arabic.
I wanted to know whether the data extraction tools in Zapier do not support the Arabic language.


I a wait for your response and thank you very much for your help.

 

icon

Best answer by Mhamed Samy 18 May 2024, 20:03

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

fiona819
Userlevel 3
Badge +3

Hi @Mhamed Samy I think I mentioned in another post. A couple of things to solve for:

  • Need to make sure the OCR tool is good enough for Arabic + English (just using query and get webhook wont be good enough)
  • For extraction - it depends on what you need (need more details please!). Depending on your use case, I would choose either using openAI or other models to do it, or using javascript for the extraction. 
  • And for your last step, I assume you need to send the extracted data somewhere else? Would it be like a google doc or google sheet?
Mhamed Samy
Userlevel 1
Badge +3

Hi @fiona819,

Good day to you,

I will explain my problem to you,

  • I always REVIEW specific data to some files in the Drive link,
  • I want the review to be done automatically without interference from me.
  • I want to make scan to some files to extract specific data, just to check them.

 

  1. I already use the OCR tool but it doesn’t work with me, it gives me errors, and I’ll attach the screenshot to clarify that.
  2. I use ChatGPT turpo for analysis text but don’t give me anything, too.
  3. Certainly, I need this CODE to try it. I was actually thinking about that

 

This is a file Drive link similar to the file that I want to extract data from it  https://drive.google.com/file/d/1nmwz0Lbr6XKn6y9R1HLLMYbLKSUgXsdb/view?usp=sharing

 

3 Attachments
fiona819
Userlevel 3
Badge +3

Hi @Mhamed Samy I did some research on this today. The OCR tool you are using is not good for Arabic texts - I have a few alternatives I am testing and will share with you after I am done testing. 

For the text analysis, do you just need to analyze the sentiment (as shown in your screenshot) on the Arabic text? Or all text?

After the analysis, where do you want results to be sent to?

Mhamed Samy
Userlevel 1
Badge +3

Hi @fiona819,

Thank you very much for your help,

I did extract the data in Arabic and English by Webhook, but the files in my drive are PDF and I can’t extract text from PDF, so I want to convert files from PDF to Docx.

Can I do that in Zapier?

I have two zaps, one zap for finding drive link in Asana and transferring files from one drive link to another, but Zapier doesn’t support that, so I use AppScript in GSheet to do that by JS code,

and I have a good idea, we can convert the file format from PDF to docx by app script too, Isn’t it?

fiona819
Userlevel 3
Badge +3

If you just want to convert files from pdf to docx, there are different tools in Zapier that support that. 
This is one → https://zapier.com/apps/google-drive/integrations/google-drive/24664/convert-pdfs-to-microsoft-word-files-in-google-drive-with-convertapi

If you search OCR tools - there are a couple more. 

Also, another tool I use is called smallpdf but they dont have an API. 

I am more concerned how you are going to do the text extraction analysis after parsing the pdf, let me know if you run into more bottlenecks along the way. 

Mhamed Samy
Userlevel 1
Badge +3

Hi @fiona819,

I did try this tool but it can read En lang. and Ar lang shows as strange shapes, i’ll attach screan to clarify what i mean,

I’ll try to convert the file from PDF to doc in AppScript and I’ll tell you with result.

I have a sense that we can do it inshallah.

 

 

Mhamed Samy
Userlevel 1
Badge +3

I solved it Alhamed llah, Thank you @fiona819 for your support me, I appreciate that. 

 

Mhamed Samy
Userlevel 1
Badge +3

Hi @fiona819,

Good day to you,

I will explain my problem to you,

  • I always REVIEW specific data to some files in the Drive link,
  • I want the review to be done automatically without interference from me.
  • I want to make scan to some files to extract specific data, just to check them.

 

  1. I already use the OCR tool but it doesn’t work with me, it gives me errors, and I’ll attach the screenshot to clarify that.
  2. I use ChatGPT turpo for analysis text but don’t give me anything, too.
  3. Certainly, I need this CODE to try it. I was actually thinking about that

 

This is a file Drive link similar to the file that I want to extract data from it  https://drive.google.com/file/d/1nmwz0Lbr6XKn6y9R1HLLMYbLKSUgXsdb/view?usp=sharing

 

You can extract data from a file by uploading the file to your drive to convert the file formatting from PDF to Document then we can use a code by JavaScribt To be able to extract the entire text.

You can follow these steps:

  1. Upload the file to your GDrive
  2. Use the code in JS to extract the text
const response = await fetch(inputData["text"]);
const text = await response.text();
const words = text.split(" ");
output = { result: words.slice(0, 3000).join(" ") };

Then you will be able to successfully extract the text.

Terms & Conditions