How to read text by sentences into table
- Thread starter btamsgn
- Start date
- Local time
- Today, 07:38
- Joined
- Feb 19, 2002
- Messages
- 47,553
Will you be paying by check or by credit card?
Have you ever heard of the split() function?
- Local time
- Today, 06:38
- Joined
- Feb 28, 2001
- Messages
- 30,474
@btamsgn, you have made the mistake that many people make when they first get here. We do, in fact, offer small amounts of code from time to time. However, there is a little "gotcha" you should consider. We who answer questions are all unpaid volunteers here, acting out of the kindness of our hearts and hoping to offer a little "push" to others. The bigger YOUR request, the less time we have for other requests.
Asking to "receive code" implies a bit more than just a "push." It is possible that your request was poorly worded, but the scope of a sentence parser is perhaps a bit much to ask. For instance, define a sentence as it will occur in your context. Most sentences end with a period, Or can it end with a question mark? And some emphatic sentences end with an exclamation mark! Then, what do you do when the person entering data to the textbox can't type worth a darn? And there are other ways to end a sentence in literary circles...
I will point you to our code repository, where I happen to have created a text parser class module. The zip file contains a VBA class module and some Word documentation on how to use the parser. It might help you. It might not. But you are welcome to look at it. I have debugged it to the best of my ability and it works for the various ways I have tested it. But I offer no guarantees, expressed or implied.
Asking to "receive code" implies a bit more than just a "push." It is possible that your request was poorly worded, but the scope of a sentence parser is perhaps a bit much to ask. For instance, define a sentence as it will occur in your context. Most sentences end with a period, Or can it end with a question mark? And some emphatic sentences end with an exclamation mark! Then, what do you do when the person entering data to the textbox can't type worth a darn? And there are other ways to end a sentence in literary circles...
I will point you to our code repository, where I happen to have created a text parser class module. The zip file contains a VBA class module and some Word documentation on how to use the parser. It might help you. It might not. But you are welcome to look at it. I have debugged it to the best of my ability and it works for the various ways I have tested it. But I offer no guarantees, expressed or implied.
Text Parsing Support as Class Module
I've been working on something I used a lot at work to help me more easily decipher complex text inputs. For the Navy, I used this as a part of a program to analyze IIS logs, decode complex names, and I even once used a variant of this under OpenVMS to build a command-line calculator for the...
www.access-programmers.co.uk
Gasman
Enthusiastic Amateur
- Local time
- Today, 12:38
- Joined
- Sep 21, 2011
- Messages
- 17,068
Seems the O/P is used to demanding code? 
How many records as known total of them(3 CODi)?
Dear Everyone, I want to create a sub or function as follows: - List all materials fields "Manpl" from table "Tnpl" and insert/add into table1.T1,table1.T2,,table1.T3, with condition the same [table1].[tong] for example...
www.access-programmers.co.uk
Query with numbers from T1 to Tmax
Dear Friends, I want to create a query with numbers from T1 to Tmax in file quiluat.accdb like file book excel Please find the attachment for your refference. Looking forwarding to supporting and receiving from your responses.
www.access-programmers.co.uk
How to change access vba
Hi everyone, How to change part in bold into access vba ? Sub Balaco() Dim sArr(), res(), sRow&, i& Const e# = 10 ^ (-12) 'Sai so cho phep Const n& = 50 ' results rows found i = Range("B999999").End(xlUp).Row res = Range("B3:C" & i).Value 'data table "Tnpl" sArr =...
www.access-programmers.co.uk
