Post reply

How to get number of occurrences in varbinary datatype?

  • 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 year, 8 months ago by  Aravind.

  • August 13, 2022 at 10:10 am

    #4076003

    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

    #4076062

    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

    #4076354

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

  • August 15, 2022 at 8:35 am

    #4076417

    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.

  • August 16, 2022 at 3:22 am

    #4076768

    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 year, 8 months ago by  Aravind.

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

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