I have two text files with various columns, each column is separated by a tab (" "). What I'm trying to do is the following:-If the values in text file 2 column 1 does not contain any value in text file 1 column 1 then add that field to text file 2 and add a 1 to the second column, like so
String 1 If the value in text file 2 column 1 already appears in text file 1 columns 1 then just add +1 to the value, so if the above value is already in Text File 1 Column 1 and Text File 2 Column 1 then it would appear as.
String 2 And if it was to happen again then
String 3 and so on.I have the following coding so far.
Dim lines1 As New List(Of String)(IO.File.ReadAllLines("File1"))
Dim lines2 As New List(Of String)(IO.File.ReadAllLines("File2"))
IO.File.WriteAllLines("File2", lines1.ToArray) & +1)
[code]....
I use the above coding, but it removes the second column?
I have been trying to figure out how to take text i have in a SQL text field and create the correct document from it. Here is the info i have in SQL: MIMEType is a string field that contains one of the following "application/pdf", "application/msword", "application/vnd.ms-excel" or a few others. DocumentBody is a text field that looks like "0M8R4KGxGuEPgADAP7/CQA" this continues for quite a bit. FileName is a string field that contains the original file name such as "test.doc" or "test.pdf"
I have tried using the System.IO.FileStream and System.IO.StreamWriter but in the document it actually writes the text that is desplayed in DocumentBody. I assume I am missing some way to decode this using the MIMEType but i just can not seem to find it.
I have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
I'm learning to write text file from a Listbox and DataGridView, and read from it.Everything works fine until I have a small problem with reading file into DataGridView. The problem I concern is about time. For example, in my text file, I have Arrival Date & Arrival Time, but when I display it in table it is something like below:[code]
I am working on a project for work where I am stuck. We have a daily checklist that i have converted into a Tabular text file. In the text file I have 3 pieces of information, DB field reference, Time it should be done by, and task to be completed. I have this part being pulled into the screen with the Code below. My problem is how do I Merge the Database to the TextBox. The Access DB has 50 Columns of for data Labeled 1 through 50 + one date Field
Imports System.IO Public Class FirstShiftCheckListForm Dim strlines() As String Dim strline() As String Dim strarray(,) As String [Code] ......
I have a VB Application that is loading an Array with Numbers from the Sequel Server that have numbers 315054 no cents and leaving the .00 off even numbers. I need to write out the number to a textfile that has 14 zero's to the left removing the decimal point from the number.
The Number should format and be written out like this: 00000031505400 in the text file.
My coding does this as long as the even number has a decimal point .00 but if the number comes in as 315054 into my array my coding gives an Argument error with the coding below. SCreditTextBox1 = Microsoft.VisualBasic.Right("00000000000000" & Microsoft.VisualBasic.Left(_sData(Irow, 7), _sData(Irow, 7, ".") - 1) & _ Microsoft.VisualBasic.Right(_sData(Irow, 7), 2), 14) Is there a way to check for no decimal point and then place the number with no .00 as 00000031505400?
The accounting people are entering the numbers into the server this way incorrectly. The .00 is suppose to be entered with it, but not all even numbers are entered this way without .00, just a few, but I need to check the number to see if there are decimals and without decimals do something. Could my coding be re-written to account for not having the .00 and to format the number correctly to avoid the argument error?
I need for any number to format with: $3,000.00 would appear in server as 3000 or 3000.00 and should write out like this below: I need to check for decimals and without decimals and writeout the format like this below: 00000000300000.
I am doing a data migration from Lotus notes to another type of software that does not support Rich Text Fields.I am trying to write a VB 2005 program that will take any rich text fields that are found and place them into an RTF file - which will be uploaded as an attachment in the new software.I cannot get the program to take the rich text formating or objects to the RTF file, only the plain text.I have tried everything under the sun using the COM library to get these objects out to no avail.
I am doing a data migration from Lotus notes to another type of software that does not support Rich Text Fields. I am trying to write a VB 2005 program that will take any rich text fields that are found and place them into an RTF file - which will be uploaded as an attachment in the new software
how to store CSV & Text file to an Image Field in SQl table. the table is using by some other application that's why i could not change the field data type.
Is there a way to handle quotes with a field in text tab delimited file example:"This program works "really" nicely and is helpful" my reading and understand thus far is that while the file is tab delimited fields can also begin and end with quotes. Therefore is a field contains a quote it gets interpreted as end of field.[code]
i want to fill up the userID and password fields of the yahoo mail login page with the click of a button on the form but just cant get it right.[code]it just skips the yahooID field and fills out the password field. what is wrong or is there a better way of doing it?
I'm trying to simply prove here that this simple function isn't good enough to prevent every sql injection in the world:[code]I know its not secure, because of googling and looking up other questions on url...[code]I then coppied a Chr(8) from the clipboard and replaced the Chr(8) in the textbox with the clipboard contents and still a no-go.It puts the whole string directly into the field w/o problems.I'm using MS SQL Server 2005, and VB .NET 2005.the Text1 field in the database is a Varchar(600) field (don't ask my why its not MAX, its pointless, i know)There are certain triggers on the table that would prevent a mass update such as this and throw some errors if the injection actually worked right.I know parametrized queries are the way to go here and I'm not looking for answers like "well i dunno why it doesn't work, but parametrized queries are the way to go".I'm looking for the ability to prove that our software is broken and that we need to rewrite it using better principles.how to better filter your text fields, the answer is DON'T! Use the parameters! they are much better, safer, and easier!
I have a txt field that is used for comments that is stored in a SQL Varchar(max) field. No matter what I put in there it always is limited to 50 Characters. I was told that it was unlimited pretty much. I need to be able to put in up to 200 characters.
I'm working on this project, and when the form loads it should automatically put the Focus on the username field if it is empty, however if there is a username - put the focus on where you write your message.Below is the code, and it simply doesn't seem to work for whatever reason. I have tried several methods of it, and even commented out every other line of code in the application to make sure there was no interference, and there was none. is there anything that could possibly overwrite the ability to do this? Some setting I need to change? etc etc?
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If String.IsNullOrEmpty(txtUser.Text) Then txtUser.Focus() Else
I have one combobox, two buttons (Add and View) and listbox. When I click button Add text from combobox is added to text file. This is code for Add button:
I have text field that a user enters a date in. Based on what they enter a drop down box will appear or not appear. To obtain the info for the code to control the drop down I am using an auto post back on the text box. This is however making the app a bit clumsy as the user is taken back to the top of the page.
In my page there is a fileupload control and a gridview. When I upload a file, the DocName and the path of the saved file will in the gridview. I put the filepath in a hyperlink field so that it will show "View file"(not the path). My problem is - the gridview is showing "view file" text when there is no file saved.It works fine when I upload a file.
What I need to do is query an iTextSharp AcroField to check if it is rotated, and if so capture the value of the rotation.So If I have the following field:
Dim af As iTextSharp.text.pdf.AcroFields = stamper.AcroFields Dim afi As iTextSharp.text.pdf.AcroFields.Item afi = af.GetFieldItem("fieldName")
What do I need to do to get the rotation (in degrees) of that specific field?
I'm trying to design a words game that's give you the first two letters from the word and you insert the rest to make a word (for now I'm just using "co" as example and I have just one table in the database for it). The word will be written in textbox to be compared to a database field. If the word exist in the field the word will be displayed in a label with blue color and the score will increased by one if not the word will be displayed in the label with red color. This should happen three times with three words and I have different label for each one.
the name of my database is database1 and it have one table "A" wich contain "Comp" and "word". I tried this game with array of word before and it was working. Now I'm trying to use database instead of arrays but its not working. [Code]
I am trying to remove all spaces from a text field when a form is submitted so that the contents of the post code field match those in a database...
If drSet5c.Tables(0).Rows(0).Item("post_code") = UCase(Replace(tbPostcode.Text, " ","")) Then response.write("Postcodes match")
[Code]....
So if the postcode in the database is AB12CD and the user types AB1 2CD the space is removed on submitting the form and the match statement shows. This is not working though.
