Last post Jan 06, 2016 10:59 AM by raghu_grdr
Jan 05, 2016 05:05 AM|ashu1987078|LINK
I am trying to match the set of strings(say 400 in numbers) with the excel sheet for a particular column.
Excel sheet will have 1000 rows and 10 columns.If Excel sheet cell have those set of strings.Then output will be the complete row with matched set of strings in that cell.
eg I have set of strings "SQL Server","ASP.Net with C#","Delhi University" say 400 different strings(these are keywords that need to be search in that Excel sheet).Excel sheet have 10 columns.I want to search in the 6th column for these 400 strings in the
excel sheet. It will show the all Rows which have atleast one of these strings.
How to do this filteration.Please help how to do this.
Jan 05, 2016 06:26 AM|oned_gk|LINK
I guess you need write a query
Jan 05, 2016 09:45 AM|ashu1987078|LINK
Thanks oned_gk for your fast reply.
I have set of strings "SQL Server","ASP.Net with C#","Delhi University" say 400 different strings(these are keywords that need to be search in the Excel sheet cell for a particular column.).That cell have the paragraph of information(set of strings)
which may contain these keywords. It is the matching of strings case.
Superuser will be applicable to the equal content on both cell or equal int value.
Jan 06, 2016 10:59 AM|raghu_grdr|LINK
If the Excel Sheet path and file name is constant then you can use bulk insert to store the excel as Table in Sqlserver then compare.
FROM 'path of your file'
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
--Check the content of the table.
--Drop the table to clean up database.
--DROP TABLE tablename