Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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?

  • May 15, 2024
  • 8 replies
  • 539 views
Mhamed Samy
Forum|alt.badge.img+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.

 

Best answer by Mhamed Samy

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.

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
Forum|alt.badge.img+3
  • fiona819
  • New
  • 118 replies
  • May 15, 2024

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
Forum|alt.badge.img+3
  • Mhamed SamyTinkerer
  • Author
  • Tinkerer
  • 28 replies
  • May 15, 2024

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

 

fiona819
Forum|alt.badge.img+3
  • fiona819
  • New
  • 118 replies
  • May 16, 2024

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
Forum|alt.badge.img+3
  • Mhamed SamyTinkerer
  • Author
  • Tinkerer
  • 28 replies
  • May 16, 2024

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
Forum|alt.badge.img+3
  • fiona819
  • New
  • 118 replies
  • May 16, 2024

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
Forum|alt.badge.img+3
  • Mhamed SamyTinkerer
  • Author
  • Tinkerer
  • 28 replies
  • May 16, 2024

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
Forum|alt.badge.img+3
  • Mhamed SamyTinkerer
  • Author
  • Tinkerer
  • 28 replies
  • May 16, 2024

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

 

Mhamed Samy
Forum|alt.badge.img+3
  • Mhamed SamyTinkerer
  • Author
  • Tinkerer
  • 28 replies
  • Answer
  • May 18, 2024

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 & ConditionsAccessibility statement