I think so. I can even ask users upload 50 Citations in the text file a time, if the user received over 100 or 200.
Import complex text file into Access
- Thread starter Sergo
- Start date
That is only one field, sometimes it does in Citation, sometimes not.
May I add that it wouldn't matter if some fields are present or not on different records, that can be easily handled.
The four main things I would consider are:
1. Do we have all the field names that could ever be present?
2. The maximum number of citations.
3. If the first word of any text is the same as the field. I.e.
4. Is there always going to be a field name followed by its corresponding text? You don't want to import data for a field that it shouldn't belong to.
3 can be easily handled too.
I'm going back to the background.
The four main things I would consider are:
1. Do we have all the field names that could ever be present?
2. The maximum number of citations.
3. If the first word of any text is the same as the field. I.e.
Code:
Database <----Field
Database is part of .... <----Text3 can be easily handled too.
I'm going back to the background.
1. Do we have all the field names that could ever be present?
These are all fields:
Citation
Database
Author
Title
Source
Abstract
Language
Publication Type
2. The maximum number of citations.
I don't know, but probably no more 200. In my opinion I don't think it's matter. Loop will go through the end anyway, right
3. If the first word of any text is the same as the field. I.e.
No. it's starts with the text
The users asked for. But if it's easier w/o it, then let's do it w/o it.
From your point of view it doesn't matter, but from our view (well at least mine for now), it makes a big difference in the approach.
To answer #4
I think so! It will be always same structure except for the last field "Publication Type", sometimes it's missing
It does, if you transfer first into memo field, which is only except no more then 65,000 char.
No. But we can add a line # with the code that send me Uncle Gizmo.
What I'm talking about is the programming side of things, not about character limitations. Anyway, Uncle Gizmo is on it. I was only dropping hints.
I will follow with them. But if it's to complicate, the users will understand and except it.
What I'm talking about is the programming side of things, not about character limitations. Anyway, Uncle Gizmo is on it. I was only dropping hints.
I see, thank you!
Sergo there's still this anomaly. Author and Authors. What's happening there?
I like your strategy! I wouldn’t event guess to go this direction. I just ran it with the real data, you right, it did find same words in text on some locations. Thank you anyway for your hard work!
What if we make it easy. I just want give user at list one option, otherwise they can continue copy paste.
What if we’ll make 2 fields: Citation# and Citation_Data. It will look like this.
Citation# ----- Citation_Data
1-----------------(insert whole Citation1)
2-----------------(insert whole Citation2)
3-----------------(insert whole Citation3)
What do you thing?
What if we make it easy. I just want give user at list one option, otherwise they can continue copy paste.
What if we’ll make 2 fields: Citation# and Citation_Data. It will look like this.
Citation# ----- Citation_Data
1-----------------(insert whole Citation1)
2-----------------(insert whole Citation2)
3-----------------(insert whole Citation3)
What do you thing?
Thank you for pointing this out! I did look and found that some citation has “s” some not. That is another reason it will not work. I need talk to users, because before start this project I asked them all labels (fields) in citation are consistent and structure is same. They told me “Yes”
