the main problem is I received different data every time, Let me tell you the problem,
I received expenses accounting transactions on every month, I analysis these transactions through their narrations, In narrations different style of sentences mentioned . I have to manually marked specific tag to each transactions like Maintenance , Provision etc. so do the work manually and spend 1 to 2 hours I am try to automate this sort of marking, and finally I am not professional programmer of Excel, I am accounting guy, so your help and comments really help me a lot.
thanks and regards
tayyab
________________________________
From: "1z@compuserve.com" <1z@compuserve.com>
To: ExcelVBA@yahoogroups.com
Sent: Wednesday, August 22, 2012 6:07 PM
Subject: Re: [ExcelVBA] Re: specfic character pick
Yeah....
I've had my own problems with InStr. You really have to be sure what your data is going to look like... and it has no exceptions either like ignoring stuff you don't want to look at like items in quotes or brackets or whatever.
I've written various versions of my own and used stuff from Chip Pearsons site as well.
For this problem.. given a sentence... I'd suggest removing punctuation, Split to get the words and loop through the array to test for specific things using StrComp with an option to ignore case if needed. It won't be quick though.. I think Split is relatively slow.
Lisa
Sent: Wed, Aug 22, 2012 2:42 pm
Subject: [ExcelVBA] Re: specfic character pick
I agree that InStr is working. I'm thinking that for each find of the root word,
a look at the chars immediately proceeding and following the find, while
checking for end of file and "before the file" (don't know what the common
terminology for that is), will be required.
Dave G
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar