VBA: Parse preceding numbers from string

Posted by buttonsrtoys on Super User See other posts from Super User or by buttonsrtoys
Published on 2014-06-02T20:40:36Z Indexed on 2014/06/02 21:31 UTC
Read the original article Hit count: 177

Filed under:

vba

I need to parse into two substrings a string that always starts with numeric text followed by alphnumeric text. The strings can vary a bit, but not too much. Below are examples of incoming format and the strings I need:

"00 10 50 Information to Bidders"   ==> "00 10 50", "Information to Bidders"
"001050 Information to Bidders"     ==> "001050", "Information to Bidders"    
"00 10 50 - Information to Bidders" ==> "00 10 50", "Information to Bidders"
"001050 -- Information to Bidders"  ==> "001050", "Information to Bidders"

I was hoping it would only be a half dozen lines of VBA, but my code is turning into a loop where I'm testing every character in the string to see where the changeover from numeric-only to non-numeric, then parsing the string based on the changeover location. Not a big deal, but messier than I was hoping for. Are there VBA functions that would eliminate the need to iterate through each string character?

Related posts about vba

Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
VBA : Obliger une saisie numérique dans une TextBox - Approche d'une résolution de besoin en VBA niv

as seen on Developper.com - Search for 'Developper.com'
Bonjour, Ci-dessous, le lien vers un nouveau tutoriel : « Approche d'une résolution de besoin en VBA - niveau débutant - Obliger une saisie numérique dans une TextBox » Le but de ce tutoriel est : De présenter une bonne approche de la résolution d'un problème simple en VBA. D'expliciter en… >>> More
Run VBA macro when condition is met

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I'm creating a spreadsheet to train my numerical skills. Now, I use VBA macros to generate a new problem once the current one has been correctly solved. To do so, I still have to press a button in the worksheet, which costs time and is annoying. Is there a way that I can execute a… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Excel 2007 VBA macros don't work in Parallels

as seen on Super User - Search for 'Super User'
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow Leopard. The spreadsheet contains VBA macros which connect to external Oracle db's over the Internet… >>> More

Developer IT

VBA: Parse preceding numbers from string - Developer IT

VBA: Parse preceding numbers from string

vba

Related posts about vba

Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

VBA : Obliger une saisie numérique dans une TextBox - Approche d'une résolution de besoin en VBA niv

Run VBA macro when condition is met

Offset the tickmarks of a secondary axis

Excel 2007 VBA macros don't work in Parallels

Categories cloud