|
Need help converting text file to comma delimited
|
|
|
hello9920
Newbie
|
18. February 2009 @ 04:51 |
Link to this message
|
|
The files have Business Name-Business Code-Address-City-Zip-DBA
I can find and replace in Text editor everything but Business Name and Address. I can't figure out how to convert them other than manually. That is not feasible. I would appreciate any help.
Thank you
|
|
Advertisement
|
|
|
|
AfterDawn Addict
|
18. February 2009 @ 10:32 |
Link to this message
|
|
I am not sure what you are saying the problem is.
If the fields are separated with a - why can't you do a find/replace on all "-" to ","? There must be another reason otherwise you wouldn't have posted here.
I have dones several conversions such as you have described and have some special techniques for doing so.
The other might be that you are using notepad or some minimally functioning text editor. Have you tried using a full featured test editor such as Ultra-Edit or Context?
|
|
hello9920
Newbie
|
18. February 2009 @ 19:06 |
Link to this message
|
I am just not familiar with this so I know I didn't explain it very well.
I download lists into pdf then change to text file, and it looks like this
#1 SON HOME IMPROVEMENT 072754700 4915 WILLOW LAWN DRIVE CHATTANOOGA 37416
It is supposed to look like this
'#1 SON HOME IMPROVEMENT','0727547-00','4915 WILLOW LAWN DRIVE','Chattanooga',' 37416','';
I don't know what I am doing wrong.
I have tried different text editors, so it is for sure operator error. lol
Thank you so much for repling.
|
AfterDawn Addict
|
19. February 2009 @ 01:11 |
Link to this message
|
|
OK, how does .pdf play into this?
.pdf is for non-modifiable text files.
Converting from .pdf format is very likely to cause errors.
What is the native format of the list?
.pdf is not a "native" format. This is most likely your problem.
|
|
hello9920
Newbie
|
19. February 2009 @ 02:33 |
Link to this message
|
I was given a website to access that had the files I sent earlier.
Here are the instructions I received: Login to the website navigate to the reports page and run the reports pdf. Then you will select and copy the records from the pdf to a text file. Then you use the find and replace command on your text editor to create 100 records that look like the first two records that I created above.
Thank you for your time
|
|
evnflow
Suspended due to non-functional email address
|
19. February 2009 @ 03:09 |
Link to this message
|
|
some info i found that might help you: "A comma delimited file is a database exported into a format where each record is a single line and each field in the record is indicated by a comma. Where necessary (e.g., if the field has a comma in it) the field will also be quoted. If you have Excel, use the import feature of Excel to import the file. Specify comma delimited format as the import format. Then export to whatever format you require for the data. You can also usually import this format directly into most any database program or spreadsheet program as well. This file type is often associated with Microsoft Excel as this is one of the standard ways to transfer data into and out of a spreadsheet."
Dolla Dolla Bill Ya'll
 This message has been edited since posting. Last time this message was edited on 19. February 2009 @ 03:19
|
|
hello9920
Newbie
|
19. February 2009 @ 04:42 |
Link to this message
|
|
Ok ...Good thank you very much.
|
|
evnflow
Suspended due to non-functional email address
|
19. February 2009 @ 05:07 |
Link to this message
|
|
no prob..hope it helped you out..good luck
Dolla Dolla Bill Ya'll
|
|
Advertisement
|
|
|
|
txbratt
Newbie
|
1. March 2009 @ 08:47 |
Link to this message
|
I know I am getting into this late, but there is another thing you can do if you have at least a standard version of Adobe Acrobat. Export the pdf into a word document and the open in excel and follow the propts for text tab delimited files.
|
