Re: finding a value in a string

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

From: icestationzbra (icestationzbra.19cjfa_at_excelforum-nospam.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 14:05:36 -0500

sorry if i was not clear in my earlier posting.

if you see the filenames that i have mentioned, there is a number
within the last 5-6 characters. thats the only number that keeps
changing (1, 2, 3, 4, 5, 6, 7) within all the filenames that i have
given. thats a sort of version number and thats what i am looking to
extract.

for example, in "ABC DEF123 IJK V7.xls", '7' is what i am looking to
extract. in "ABC_DEF123_IJK_V5.0.xls", '5' is what i am looking to
extract.

if the UDF extracts everything from the string, i might still have to
do some drudgery. some filenames are as long as 100 characters with
several numbers in them.

however, there is one condition that almost 95% of the strings would
adhere to. to the left of ".xls", if the first numeric character that
is greater than zero could be picked, that would be the number i am
looking for.

please help. 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: finding a value in a string
    ... have you tried the UDF?. ... > within the last 5-6 characters. ... thats a sort of version number and thats what i am looking to ... > extract. ...
    (microsoft.public.excel.misc)
  • Re: HTML - Extract Specific Text
    ... etc.) that can be used in any calculation. ... imported text is standardised you can easily extract whatever you want. ... a VBA script. ... and then takes the 11 characters starting with the fourth ...
    (comp.databases.filemaker)
  • Re: sort files by exif date
    ... >> and the filenames in a list, sort, then extract the filenames again. ... >> Probably a few lines of shell script. ... That string will be a line of text. ...
    (comp.unix.questions)
  • Re: Importing Text file Issue
    ... The problem I have is that I need to extract the first 5 characters of the ... tried opening the file to import it into Excel and save it temporarily. ... I saw an interesting post by John Nurick ...
    (microsoft.public.access.externaldata)
  • Re: Access Image Database and Extended File Properties.
    ... used by a firm who are loading lots of images a day. ... nothing that lets you extract and append those items elsewhere. ... Thank you Daron, thats an excellent link, although i am going to have ...
    (comp.databases.ms-access)