I am doing some genealogy research and I have discovered that there is
a lot of data available on the web in text format. The problem is
that the columns in the files are lined up by spaces. I'd like to be
able to import these files into Access or Excel so that they can be
sorted.
What I plan on doing is adding in commas at the end of each field to
create a csv file. What I need to know is how can I easily remove the
spaces between the comma and the first letter of the next field?
My thought is that I could add commas in front of the field (instead
of at the end) and then have either Access or Excel drop the trailing
spaces. Is there a way to get either Access of Excel to do this? Can
it be done for either leading or trailing spaces?
Any suggestions would be very greatly appreciated.
Thanks,
Tammy
(not looking forward to the editing process....) 5 5423
Look up Trim(), RTrim() and LTrim() in Access Help.
Are these text fields fixed width? I'd really try to get
them into Access then manipulate the contents with queries
and/or code.
Good luck.
--
Nick Coe (UK)
AccHelp v1.01 Application Help File Builder http://www.alphacos.co.uk/
Download Free Demo Copy
----
"Tammy" <ta*****@yahoo. com> wrote in message
news:f7******** *************** ***@posting.goo gle.com... I am doing some genealogy research and I have discovered that there is a lot of data available on the web in text format. The problem is that the columns in the files are lined up by spaces. I'd like to be able to import these files into Access or Excel so that they can be sorted.
What I plan on doing is adding in commas at the end of each field to create a csv file. What I need to know is how can I easily remove the spaces between the comma and the first letter of the next field?
My thought is that I could add commas in front of the field (instead of at the end) and then have either Access or Excel drop the trailing spaces. Is there a way to get either Access of Excel to do this? Can it be done for either leading or trailing spaces?
Any suggestions would be very greatly appreciated.
Thanks, Tammy
(not looking forward to the editing process....)
Folks,
got your details from the newsgroup. Wondered if you could advise.
I'm creating a database and have to import a five field table of text data
from a PDF file.
Obviously I can cut and paste it into excel and then import but I loose the
formatting as it all pastes into one field of excel.
How can I preserve the table formatting and import it into Access
ultimately?
Otherwise I have a truck load of cutting and pasteing ahead.
Any advice greatfully recieved.
Si
"Tammy" <ta*****@yahoo. com> wrote in message
news:f7******** *************** ***@posting.goo gle.com... I am doing some genealogy research and I have discovered that there is a lot of data available on the web in text format. The problem is that the columns in the files are lined up by spaces. I'd like to be able to import these files into Access or Excel so that they can be sorted.
What I plan on doing is adding in commas at the end of each field to create a csv file. What I need to know is how can I easily remove the spaces between the comma and the first letter of the next field?
My thought is that I could add commas in front of the field (instead of at the end) and then have either Access or Excel drop the trailing spaces. Is there a way to get either Access of Excel to do this? Can it be done for either leading or trailing spaces?
Any suggestions would be very greatly appreciated.
Thanks, Tammy
(not looking forward to the editing process....)
Folks, got your details from the newsgroup. Wondered if you could advise.
I'm creating a database and have to import a five field table of text data from a PDF file.
Obviously I can cut and paste it into excel and then import but I loose
the formatting as it all pastes into one field of excel.
How can I preserve the table formatting and import it into Access ultimately?
Otherwise I have a truck load of cutting and pasteing ahead.
Any advice greatfully recieved.
Si
"Tammy" <ta*****@yahoo. com> wrote in message news:f7******** *************** ***@posting.goo gle.com... I am doing some genealogy research and I have discovered that there is a lot of data available on the web in text format. The problem is that the columns in the files are lined up by spaces. I'd like to be able to import these files into Access or Excel so that they can be sorted.
What I plan on doing is adding in commas at the end of each field to create a csv file. What I need to know is how can I easily remove the spaces between the comma and the first letter of the next field?
My thought is that I could add commas in front of the field (instead of at the end) and then have either Access or Excel drop the trailing spaces. Is there a way to get either Access of Excel to do this? Can it be done for either leading or trailing spaces?
Any suggestions would be very greatly appreciated.
Thanks, Tammy
(not looking forward to the editing process....)
Folks,
got your details from the newsgroup. Wondered if you could advise.
I'm creating a database and have to import a five field table of text data
from a PDF file.
Obviously I can cut and paste it into excel and then import but I loose the
formatting as it all pastes into one field of excel.
How can I preserve the table formatting and import it into Access
ultimately?
Otherwise I have a truck load of cutting and pasteing ahead.
Any advice greatfully recieved.
Si
"Tammy" <ta*****@yahoo. com> wrote in message
news:f7******** *************** ***@posting.goo gle.com... I am doing some genealogy research and I have discovered that there is a lot of data available on the web in text format. The problem is that the columns in the files are lined up by spaces. I'd like to be able to import these files into Access or Excel so that they can be sorted.
What I plan on doing is adding in commas at the end of each field to create a csv file. What I need to know is how can I easily remove the spaces between the comma and the first letter of the next field?
My thought is that I could add commas in front of the field (instead of at the end) and then have either Access or Excel drop the trailing spaces. Is there a way to get either Access of Excel to do this? Can it be done for either leading or trailing spaces?
Any suggestions would be very greatly appreciated.
Thanks, Tammy
(not looking forward to the editing process....)
Folks, got your details from the newsgroup. Wondered if you could advise.
I'm creating a database and have to import a five field table of text data from a PDF file.
Obviously I can cut and paste it into excel and then import but I loose
the formatting as it all pastes into one field of excel.
How can I preserve the table formatting and import it into Access ultimately?
Otherwise I have a truck load of cutting and pasteing ahead.
Any advice greatfully recieved.
Si
"Tammy" <ta*****@yahoo. com> wrote in message news:f7******** *************** ***@posting.goo gle.com... I am doing some genealogy research and I have discovered that there is a lot of data available on the web in text format. The problem is that the columns in the files are lined up by spaces. I'd like to be able to import these files into Access or Excel so that they can be sorted.
What I plan on doing is adding in commas at the end of each field to create a csv file. What I need to know is how can I easily remove the spaces between the comma and the first letter of the next field?
My thought is that I could add commas in front of the field (instead of at the end) and then have either Access or Excel drop the trailing spaces. Is there a way to get either Access of Excel to do this? Can it be done for either leading or trailing spaces?
Any suggestions would be very greatly appreciated.
Thanks, Tammy
(not looking forward to the editing process....)
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: SD |
last post by:
Hi, a client of mine has parts such as JT220F that have trailing spaces so
at first look they seem like duplicates in the ITEM table.
Technically they are not because one is JT220F and the other is JT220F + '
' here is the problem, I'm importing it into SQL Server from SQLBase via
ODBC driver, but when the DTS is done the parts are brought...
|
by: ITM |
last post by:
Can anyone tell me how I can prevent Access adding trailing spaces
when I insert a value into a Text column?
For example, if I execute the following statement:
UPDATE Log SET Log.Title = 'Testing'
WHERE Log.Identifier=1;
....then the following statement:
|
by: Darren |
last post by:
I have been attempting to create a reservation planning form in excel
that imports Data from an Access database and inserts that information
automaticly into the correct spreed sheet and the correct cells within
that worksheet. The Excel Book is made up of 12 worksheets named
Jan-Dec. Each worksheet has columns labeled as each day of that...
|
by: Andy B |
last post by:
I've tried using Trim or RTrim to strip trailing space characters from
my data. When I check on the transformed data space characters are
still there.
We have an address table containing two fields: BuildName and
RoadName. Both have the following properties: size 50, not indexed,
not required, allowed zero length. Some records have...
|
by: Ben |
last post by:
Hi All,
I have an Excel issue which I am unable to solve for the past couple of
days.
I have a printable version of a report , which uses the basic
Response.ContentType="application/vnd.ms-excel"; to give the report in
excel.
Now one of the fields is numeric, but Excel adds a trailing space to
every number, hence that column does not give a...
| |
by: bonehead |
last post by:
Greetings,
I'm using the DoCmd.TransferText method to export the results of a MS
Access query to a csv file. The csv will then be used to load an Oracle
table.
In other systems such as TOAD for Oracle, it's possible to force an
additional comma delimiter after the last column, if the column is empty
on a particular row. Oracle requires...
|
by: tommy |
last post by:
Hi all,
I' m adding strings to some fields in my table via Access. The strings
sometimes have trailing spaces and I really need to have it that way,
but Access truncates trailing spaces. How can I force Access not to
truncate?!
Thanx,
/Toommy
|
by: hharriel |
last post by:
Hi,
I am hoping someone can help me with an issue I am having with excel
and ms access. I have collected data (which are in individual excel
files) from 49 different school districts. All districts have used the
same excel template and populated the same 32 data fields (columns). I
created one large excel file from all 49 files which gives...
|
by: brian.j.parker |
last post by:
Hey all, I've noticed an obscure little quirk: it appears that if you
use a login with trailing spaces on the name, SYSTEM_USER
automatically trims those trailing spaces in SQL Server 2000, but not
SQL Server 2005.
Anybody know if this change in behavior is documented? If it is
intentional?
Is there a "quick fix" to revert to the old...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |