Gentlemen, it feels like old home week here! Hello Malkie and hello Tom. Good to see both of you up and around.
I work with .csv files and Excel a lot. An awful lot. All in and out of DP. Malkie, I don't understand exactly what the problem is and Tom, I don't get exactly what you're doing but perhaps you have a better handle on Malkie's issues. I'm assuming that you have a file in Excel and want to import the data into DP. You can't import an .xls file but you can work with an Excel export of a .csv file under most conditions. One thing you have to be careful of is that there are no commas within the fields in the Excel file. If there are I have some workarounds. Save the Excel file as a .csv file and pull it into a simple ASCII editor - I use the ED.EXE editor that came with DP Shell, have for years. Take a look at the fields and determine how each field is separated. Some versions of Excel save it very simple with commas between fields, a control return at the end of each line. Other versions will put quote marks around each field so that as you look at it in a text editor each field is separated with a ",". "FIELD1","FIELD2","FIELD3"," and so on. This is great because you can do a global find and replace on the "," replacing it with any oddball character you wish to. Like Tom, I've always used a tilde. You don't really have to do anything at the end of the line. This setup is advantageous because it protects any commas in the field and DP doesn't try to parse the field at that point. Then do an import into DP indicating what characters separate each field and be sure to place the correct fields in the order you want them - you have to tell DP what field goes into what field on the panel - they're numbered. Malkie, I'll be in my office a good part of tomorrow (Sunday) and if you're still having problems just shoot me over a copy of what you're trying to import and I'll have a look at it. I get about two million records an election cycle sent to me in various versions of Excel, .csv formats and other misc. forms and have always been able to work them back into DP. It's really no problem for me. Like NYC, we've been snowed in a bit this week and I'm behind on some projects that I want to finish before Rhoda and I head to warmer climates for a break. Plus football is over and baseball hasn't begun so there isn't much going on on Sundays! Good to hear from both of you! Don On Sat, Feb 13, 2010 at 7:34 PM, Tom Yuhas <[email protected]> wrote: > It is sometimes easy, and sometimes very difficult. > > You need to save xls as CSV file and then import using a comma for field > and hard return for record delimiter. > > Now, when you do the hard return, it DP puts a "~" <CR><LF>. You need > to go back and reenter a space before the ~<CR><LF> -- in place of the ~ . > > If that doesn't work for you, export xls as tab delimited txt file. > > Open Shell editor and replace hard returns with Control E hard returns, > replace tabs with Control R carriage returns and then capture to your WP > Shell clipboard and import clipboard to DP. > > I use Shell 3.1 so Shell4 may be a bit different. > > Or, if data isn't confidential, send me the file and str and I'll do it > for you. > > Tom > > ut [email protected] wrote: > > >Hi Everyone! > > > >Perhaps one of you out there can help me. > > > >I'm trying to IMPORT Excel (xls or csv) (comma delimited) files into > >DataPerfect. I thought it would be as simple as exporting a DP > >datafile into Excel, but apparently it's not. > > > >In the DP import screen, I selected DOS Delimited Text, with a > >"comma" for the Field Delimiter and "CR-LF" for the Record > >Delimiter, but it doesn't work. Any suggestion? > > > >Malkie > >_______________________________________________ > >Dataperf mailing list > >[email protected] > >http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > > > > > > > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
