?
Solved

in SQL or SSRS land is there a function, or code  which can parse a text file for a specific string?

Posted on 2015-02-05
1
Medium Priority
?
168 Views
Last Modified: 2015-03-31
in SQL or SSRS land is there a function, or code  which can parse a text file for a specific string? I have a function, XP_DIRTREE which gets me the file name but I need to parse inside the file  for text string.
0
Comment
Question by:rschmehl
1 Comment
 
LVL 81

Accepted Solution

by:
arnold earned 1500 total points
ID: 40592911
First thing to consider us whether the sql server will gave the requisite rights to access the file.

Depending on what you are trying to achieve there might be better/more efficient ways to get to the point you want to end up with.

Are you looking to catalog files and have a searchable index?

A vb/c#/powershell might be a better approach to look at the sql for the files that need to be cataloged.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Screencast - Getting to Know the Pipeline

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question