I am trying to extract the first portion of a string up to the first SPACE or any non-numeric digit.I thought I could do it but the string may contain an alphabet in the front followed by varying digits of numerals, making it more complicated.Here are some examples of the string to be parsed and the expected results:
String[code].....
I would have to use a series of instr statements but the code would be much cleaner using RegEx.
I have a strings with different number of characters (30-50). But each string contain only two "x"-characters in different positions. I need code that will extract only a portion of string between the "x".
View 5 RepliesI was wondering what the easiest way is to get a portion of text from a string for example, you have:
"example1,example2,example3"
And i need to be able to get all three of the items separate:
"example1"
"example2"
"example3"
The length and number of items will change, I'm using a listview subitem
Lets say I have a variable: varEmail. It contains a variable equal to the user's email address, so it might contain a value likeNow, lets say I want to get just a portion of the email address, e.g. strip off the domain, like so:
View 5 RepliesI have a combobox which is filled with items from a table like this: [Code] What Im trying to do is to when I choose one name from the dropdown list the firstname shall go to one textbox1 and lastname go to textbox2. One way doing this may be to use the ID column wich is the the Primary Key. And do a new search in a button with that ID which fills the textboxes. But how can I get just a portion of the selected string in the combobox to a string so I can do a search on it.
View 5 RepliesI have a sql table with the following fields
ID = PrimaryKey (nvarchar(50))
Name Surname
sample value of ID = RHO-1 How do i automatically increment the numeric portion when adding a new record to the database eg: RHO-2, RHO-3 and so on.
I have a userform in 2008 vb express edition. A part number is created from user input via a concat string. I want to then check if a certain portion of the part number exists in the existing file names in a directory. Below is a more detailed explanation.[code]...
View 2 RepliesI have a problem when I select a portion of a string from a RichTextBox. For instance, if I have the following string: (23*6)+5 and I want to select (23*6) the "+" is also selected. I have search for a means to correct this problem, but I have not been able to find a solution.
View 4 RepliesI have thios code that will load a php file (text file) into a sting via streamreader then its supposed to find and replace a portion of the text and write the changes back out to the file via streamwriter. I put my code together and after running it look at the file and it's unchanged. After looking closer it appears the problem is the find & replace operation I am doing on the string. Here is my code:
[Code]...
I need to parse a text looking for the string - [[Extract|xxxxxxx]] and extract the xxxxxxx characters.How would I do this?
View 2 RepliesHow would I go about replacing a portion of text in a text file with a string?
View 1 RepliesBasically I have a webresponse stream:dim lol as string = readstream.tostring there is a lot of information within the string but only one link starting with http: located near the end of the string - however there is no constant character point where I can start... (i.e. 38)
I want to extract the link from the string i.e. dog cat plane car [URL]..that is approximately how it looks above - words and url substituted I want to just extract [URL]..I had an idea of parsing the string from http: to the end Then after that splitting the string up again to remove the }], however it does not return anything
What is the best way to get '123456789' from the string[code]...
View 3 Repliesi need a vb8 code to open a txt file,search for a string in it & extract string in a excel file.
View 2 RepliesI am struggling to find a solution in string manipulation - I am trying to extract a certain part of the string element after the '=' character - say for ex. dim s as string = "/mysite/secondary.aspx?id=1005"
I am trying to get the string after the "=" and just to grab the 1005. I tried indexof and split, but i am not sure where i am going wrong.
[Code]...
im working with a receipt layout and trying to divide up a products descriptiontext into 2 lines if its longer then 24 characters.my first solution was something like this:
If Row.Description.Length >= 24 Then
TextToPrint &= Row.Description.Substring(0, 24) & " $100"
TextToPrint &= Row.Description.Substring(24) & vbNewLine
[code].....
I have a string in the following and want to extract each number from the string.
dim s as string="10,20,30,40"
dim a as integer
dim b as integer
[code].....
This is a tricky situation. I want to extract a certain substring from the strings given below, using VB 6.0. I process each string (row) in a for loop one by one.
[Code]...
I have a variable with date and time, with the next format "yyyyMMdd_HHmmss" (e.g. var = 20100228_171535)
I'd like to write it in a file, but in a separately way. I mean, to write[code]...
I'm trying to make a program that takes input from the user and take what they put in an take every letter and give it a value. Like a code or something so if they have "Apple" then it changes to something like "122515" so[code]...
View 3 RepliesI have a string, specifically its "Ballpen $10 x 3pcs"i want to extract 10 and 3 then multiply it so i can get the total of 30$,i tried using regexp but im too noob with it
View 4 RepliesI included all the code this time. In calculate click event the value is zero and I don.t understand where I went wrong. My work is due tomorrow, if anyone can tell me why I can not extract the price from the string. What this program is doing is taking items from the stockListBox and adding them to the shoppingList Box then extracting the price from the shoppingListBox and adding the prices together.
0
Public Class SupplyCalculator
Dim lists As String = "staple" & "stapler" & "folder" & "notebook" & "pencil" & "eraser" & "pen" & _
[Code].....
I'd like to be able to store the word swimming, the 2 words either side are always the same but the text before and after that is different each time.
Basically I'd like to be able to grab a piece of text in between 2 strings.
I want to extract part of a string starting at a specific character, in this case the asterisc[code]...
View 4 Replies[Code]...
i just want to extract red number which is its stand for angle/azimuth ... so how can i do that in vb.net? the problem here is its not separated by any space or comma delimiter... so how could i extract this information?
i have a string called strXML which hold this text:
PHP
<?xml version="1.0"?>
<one:Notebooks xmlns:one="http://schemas.microsoft.com/office/onenote/2007/onenote"><one:Notebook name="Work Notebook" nickname="Work Notebook" ID="{5DB5E9BD-9929-4587-AC79-42750C130E77}
I am receiving data from other computer over tcp/ip and the received type is below...
"Info,Reply:Timestamp 75ff, SpecificID c07c343aInfo,Reply:Timestamp 76ff, SpecificID
c07c3089"
In the above string, i want to get only BOLD string value.
Sometime the data would be "Info,Reply:Timestamp 75ff, SpecificID c07c343a" and
sometimes it would be many repeated value like
"Info,Reply:Timestamp 75ff, SpecificID c07c343aInfo,Reply:Timestamp 76ff, SpecificID
c07c3089Info,Reply:Timestamp 75ff, SpecificID c07c345aInfo,Reply:Timestamp 76ff, SpecificID
c07c3088..."
Some people say I will be able to get them through regex.
But I don't know how to make regular expression for getting this value.
Lets say I have a string that could look like this[code]...
I want to break each of those in to two strings. The break point would be two decimal places to the left of the existing decimal point. So in the first example I would end up with 123 and 07.37 and the second example I would end up with 44 and 01.0. I assume I need to use a form of .indexof("."), but I cant figure it out.
I want to extract the jhon I want to extract the jhon
Code:
<font color="#008800">
1 jhon
</font>
got a string "Douglas". how do i extract a substring from the given string? how do i add a character or string in the middle of the word?
View 2 Replies