Welcome, Guest. Please login or register.

Login with username, password and session length
Pages: [1]   Go Down
Print
Author Topic: import cvs file  (Read 2289 times)
0 Members and 1 Guest are viewing this topic.
georgemt
Member

Posts: 4


View Profile
« on: September 28, 2009, 06:40:34 PM »

import ascii doc=/u/public/Lisa/Physicancom.cvs R=CHR("13") F=","  I am trying to import a cvs file field delimited with commas and end of record is a carriage return line feed I believe.

George
Logged
Bill Randall
Administrator

Posts: 53


View Profile WWW
« Reply #1 on: September 29, 2009, 06:53:15 AM »

George,  Change your import statement to:

import ascii doc=/u/public/Lisa/Physicancom.cvs R=\n F=,
  
« Last Edit: October 12, 2009, 02:28:24 PM by Bill Randall » Logged

Bill Randall
georgemt
Member

Posts: 4


View Profile
« Reply #2 on: September 30, 2009, 06:15:40 PM »

Bill Thank you I am a happy camper works great.  Where do you find this in help or the manual.
Logged
Bill Randall
Administrator

Posts: 53


View Profile WWW
« Reply #3 on: September 30, 2009, 06:28:30 PM »

In the manual under IMPORT you will find that a " is a valid field delimiter so putting quotes around the delimiter that you really want will only confuse filePro.  Also, there is a section of that same subject that states:

IMPORTANT: You may use a few special codes with the IMPORT ASCII format to identify delimiters or field separators:

\r for carriage return
\f for form feed
\n for new line
\t for tab

Hope that helps.
Logged

Bill Randall
marcelus23
Member

Posts: 1


View Profile
« Reply #4 on: February 14, 2011, 10:59:51 AM »

George,  Change your import statement to:

import ascii doc=/u/public/Lisa/Physicancom.cvs R=\n F=,
  

Thanks for the information had the same problem and I have already solved. thanks  Wink

diseņo webdiseņo graficodiseņo web malagadiseņo web madriddiseņo grafico malagadiseņo grafico madriddiseņo de paginas webdiseņo de logotiposdiseņo web en malagagraphic designcreanetweb design
:::::::: MARCUS LORE :::::::::
Logged
Pages: [1]   Go Up
Print
Jump to:  

Valid XHTML 1.0! Powered by SMF 1.1.15 | SMF © 2011, Simple Machines | Massive Blue Theme By Cadosoas Valid CSS!