Hai. I would like to seek for help about mathematical expression in vb.net. how to make a system like this url Basic mathematical expression evaluator[^] but for each operand, user need to define separately. for example if the mathematical expression given like this:
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
It'd be faster to do this using Notepad++, since the column-title is only present on the first line of the CSV-file. That's also the easiest way to build your project; read the content of the file, replace the word, write it. Take a look at the classes in System.IO.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
If your purpose is to replace all data placed in a certain column (for example, the "phone number" field), you can do it programmatically.
The following function can be useful for that purpose:
' This function returns a token based on its place.
Public Function GetToken(new_txt As String, delimiter As String) As String
Static txt As String
Dim pos As Integer
' Save new text.
If new_txt <> "" Then txt = new_txt
pos = InStr(txt, delimiter)
If pos < 1 Then pos = Len(txt) + 1
GetToken = Left$(txt, pos - 1)
pos = Len(txt) - pos + 1 - Len(delimiter)
If pos < 1 Then
txt = ""
txt = Right$(txt, pos)