How to get number of occurrences in varbinary datatype?

Question

Post reply

How to get number of occurrences in varbinary datatype?

Aravind

SSC Veteran

Points: 219
More actions
August 12, 2022 at 9:58 am

#4075526
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.
- This topic was modified 1 month, 3 weeks ago by Aravind.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80326 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Eirikur Eiriksson SSC Guru Points: 182676 More actions · Answer 2

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.

😎

Aravind SSC Veteran Points: 219 More actions · Answer 3

In my question i gave example already, pls read fully.

Phil Parkin SSC Guru Points: 246023 More actions · Answer 4

Aravind wrote:

In my question i gave example already, pls read fully.

You have not provided source data. Please read Eirikur's post fully.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Aravind SSC Veteran Points: 219 More actions · Answer 5

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

This reply was modified 1 month, 3 weeks ago by Aravind.