August 12, 2022 at 9:58 am
I have a table with varbinary datatype (file stream enabled) column which store pdf files as binary , form that i can get result as which of file have 'invoice' word using following query.
SELECT * FROM FileStore WHERE CONTAINS(Document,'invoice')
Here "Document" is varbinary column which store pdf and word files as binary.
From this i want to get words which appear how many times, i mean number of occurrences.
E.G: In one of the pdf got 'invoice' word 5 times , so want to count how many times 'invoice' word appear in that table using query,
Note: i am asking in varbinay datatype, not for nvarchar datatype.
August 13, 2022 at 10:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
August 13, 2022 at 2:34 pm
As varbinary is quite an ambiguous form and PDFs can be in several various formats, you might want to help us helping you by posting an example, that is some source data and the expected results.
August 15, 2022 at 3:17 am
In my question i gave example already, pls read fully.
August 16, 2022 at 3:22 am
What is meant by source data ? are you asking sample pdf file ? its confident i cant provide in public , as i told i gave contains query for full text index table, you can use any ocr'd pdf for testing. This is the query for filter in full text indexed table.
SELECT * FROM FileStore WHERE CONTAINS(Document,'invoice')
Excepted result as count result.
E,g : if one of file got 'invoice' word appear 10 times in that pdf, so result i want 10.
You know count function in sql what it return ? if u use this query u get row count as result
Select count(*) from tablename
Same like i need to count no of occurrences 'invoice' word form the table which in varbinary(max) datatype
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy