Re: Simple Parse Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Erik Lautier <lautier@xxxxxxxxx> wrote in news:1181420726.492709.180390
@w5g2000hsg.googlegroups.com:

Hi, what's a quick way to parse a string and remove everything after
the comma including the comma? I.e., if the string is "Hi, how are
you", I would want to just keep "Hi".


Probably something like

MyString.SubString(0, MyString.IndexOf(",") - 1)

If you need more complex parsing, take a look at Regular expressions.
.

Relevant Pages

  • Re: Problem in splitting a string
    ... Angelo Secchi wrote: ... > that particular comma. ... You may want to look at regular expressions, but in the example you gave, ... you just have to split the string at the quotation marks, ...
    (comp.lang.python)
  • 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 ...
    (microsoft.public.vb.general.discussion)
  • Re: .join() !== + a + b; // for some a and b
    ... convert that final value into a string to be used as the name of the ... 8), 9 -, so two comma operations. ... bracket notation property accessor, which converts it into a string ... interpreted as simply zero for the purpose of the echo. ...
    (comp.lang.javascript)
  • Re: Finding multiple occurrences of character in word document
    ... the text into a string, and do a Split with the comma as a delimiter. ... For Each rngSentence In ActiveDocument.Sentences ... highlight the two positions. ...
    (microsoft.public.word.vba.general)
  • Re: MVP Needed - Parse a string of text from a linked .txt file
    ... delimiting the string on the comma. ... Dim rs As DAO.Recordset ... Dim strAddrPartsAs String ...
    (microsoft.public.access.modulesdaovba)