Re: string manipulation function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 22:45:41 +0800

Recent versions of Access have a Split() function that allows you to specify
a delimiter.

In older versions, use Instr() to locate the delimiter, and Mid() to chop up
the string. 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"audreybmorin" <anonymous@discussions.microsoft.com> wrote in message
news:1C9898F0-D015-4DC3-93F9-7567C435472A@microsoft.com...
>
> Is there a function allowing me to cut a string of characters separated by
a predefined character (ex. 1,2,4,5 cut where the commas are)? I couldn't
find a predefined function in VB so I've been working with left, right and
middle, but that's not ideal.
> Thanks

Relevant Pages

  • Parsing a string
    ... The function also has two optional input parameters, ... default delimiter value in the function definition line ... then using the instr() functions. ... Dim ArrayBreakPosAs Integer, strPrefix As String ...
    (microsoft.public.access.queries)
  • Re: Is it possible to Change String Delimiter without using an interface Spec?
    ... If you want to use TransferText the only way to specify a non-standard ... delimiter is by using an import specification or a schema.ini file. ... > the data has a ' as the string delimiter. ...
    (microsoft.public.access.externaldata)
  • Re: ListView FindItem
    ... Instr() seems to have a limit to the size of the string it can test. ... Do not want to double memory usage by putting the value in the collection ... ' use InstrRev to find the last delimiter, then use Left$ to get only ...
    (microsoft.public.vb.general.discussion)
  • Parsing a string
    ... you would use the Instr() ... function to extract the string ... optional input for another delimiter. ... >>first instance of a character, but how do I find the ...
    (microsoft.public.access.queries)
  • Re: regex/preg_replace? How do I do this?
    ... input source, you may also need to specify the delimiter at the ... What I need to do is to find all instances in a string where there are ...
    (comp.lang.php)