How to Keep Only the First Value in a Comma Delineated String
In a textbox containing a string of ID numbers each separated by a
comma, how can I keep only the first value, and then remove all of the
other numbers and commas behind it? The first value may contain 1 or
2 or more characters.
- Re: Try to use two functions in query
... HTH stands for "Hope This Helps" ... > I do want to parse a string and make a column as the sub test illustrates, ... >>of characters in the string, and subtracts the number of characters in the ... >>comma, and subtracts 0 if it is a comma, to account for a string where the ...
- RE: Select a part of a string
... Dave Hargis, Microsoft Access MVP ... Public Function ThirdPosition(InputString As String) As String ... "NP,VY,ECO315,A,OVEXCY,VBG,55" and I would like to isolate the characters ... between 3rd and 4th comma knowing that the length of characters may vary like ...
- Re: Length of unbounded_string.
... You are right but I am sure the Next_Line has other characters in the line. ... The string should not have BackSpaces but I think that if so comma should be found with a next position statement searching for it, ... Looking at the loop below, I guess the statement is meant to be ...
- Re: CDBL Function truncates decimals
... Public Function ConvertNumberforSQL (ByVal sValue As String, ... vlDefaultNumber As Double= 0) as Double ... Since the Spanish formatting has a comma, the SQL statement seems to have ...
- Re: Regex help
... |2) Character number 5 is a comma. ... |3) The other characters are either numbers 0-9 or letters a-f. ... and using a regex match on the string ... |If possible I would like to simplify this by using a more advanced regex ...