Databases
StackOverflow2013
Postsdbo
POPDF Import into SQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPDF Import into SQL
    primarykey
    data
    text
    <p>I have a pdf file that I converted to seperate HTML files, My goal is to import them into MS SQL so I can search the table for specific identifiers and display the result on a webpage.</p> <p>I am able to read all the html files, and get it into the SQL table, but complete sentences are being cut of by the converter because they are splitted into multiple div containers.</p> <pre><code>&lt;div class="S2"&gt; DA0-17.0&lt;/div&gt; &lt;div class="S5"&gt; 1416&lt;/div&gt; &lt;div class="S2"&gt; Required when the subscriber is the same person as the patient. If&lt;/div&gt; &lt;div class="S5"&gt; 2698&lt;/div&gt; &lt;div class="S2"&gt; the subscriber is not the same person as the patient, do not use&lt;/div&gt; &lt;div class="S2"&gt; this element.&lt;/div&gt; &lt;div class="S4"&gt; CODE&lt;/div&gt; &lt;div class="S4"&gt; DEFINITION&lt;/div&gt; &lt;div class="S2"&gt; 18&lt;/div&gt; &lt;div class="S2"&gt; Self&lt;/div&gt; </code></pre> <p>I am trying to retrieve class S2.</p> <p>I don't need class S5 or S4 Attached is a sample of the SQL results, The insert string is dynamicly created depending on how many fields there are needed.</p> <p><img src="https://i.stack.imgur.com/ev3MV.png" alt="SQL Results"></p> <p>Below is the part the creates the insert values:</p> <pre><code>If iFieldNum = 1 Then sInsertstring = sInsertstring + "id2, " + "num" + CStr(iFieldNum) sInsertValues = sInsertValues + "'" + msbr + "', '" + ms2 + "'" Else sInsertstring = sInsertstring + ", num" + CStr(iFieldNum) sInsertValues = sInsertValues + ", '" + ms2 + "'" End If iFieldNum += 1 </code></pre> <p>Hopefully someone can assist me with this problem or point me in the right direction on how to fix this issue. Complete code is available upon request. Thanks for your time, Robert.</p> <p>Ps: This is application based, not web</p> <p>In reply to Edper:</p> <pre><code>Dim fFileName As String Dim dListing As New DirectoryInfo(My.Settings.ImportDir) Dim aFileArray As FileInfo() = dListing.GetFiles() Dim fFiles As FileInfo For Each fFiles In aFileArray fFileName = fFiles.Name Dim fStream = New FileStream(My.Settings.ImportDir + "\" + fFileName, FileMode.Open) Dim sReader = New StreamReader(fStream) </code></pre> <p>In reply to Edper.<br> What I want is the following:</p> <p>In the HTML files (around 700) are div containers with different class names.</p> <pre><code> &lt;div class="S2"&gt; Required when the subscriber is the same person as the patient. If&lt;/div&gt; &lt;div class="S5"&gt; 2698&lt;/div&gt; &lt;div class="S2"&gt; the subscriber is not the same person as the patient, do not use&lt;/div&gt; &lt;div class="S2"&gt; this element.&lt;/div&gt; </code></pre> <p>I am able to create insert statements for each occurrence, however I want the "Description" between the <code>&lt;div class="S5"&gt;</code> and <code>&lt;div class="S4"&gt;</code> to be one long line of text, at the moment it is split up in 3 parts which I don't want, I don't know how to combine them.<br> My knowledge of VB.NET is fairly limited, and I am trying to learn as I go along, I was pro-efficient in classic ASP but that won't work in this case.</p> <p>I'm sorry for the bad formulation of my question..<br> I simply don't know how else to explain it further.. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRobert de Jonge
    1. USRobert de Jonge
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CODo you want div of the same class as one sentence and then insert it to your table? Are you using Webbrowser control on this one?
      singulars
      1. POPDF Import into SQL
      1. USEdper
    2. CO@Edper, I updated my question with a part of the code. And yes, I would like it to be 1 sentence instead of multiple parts.
      singulars
      1. POPDF Import into SQL
      1. USRobert de Jonge
    3. COSo, let me clarify again. You have converted PDF files into HTML files. But your problem is you have classes that are into multiple divs? And you want to get those multiple divs (one class) into one sentence to be added then to your database table? I am not really sure what you are trying to accomplished here so kindly be more specific on your question and target the area you want others to focus on in order we can help you. Thanks.
      singulars
      1. POPDF Import into SQL
      1. USEdper
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload