Author Topic: import cvs file  (Read 2361 times)

0 Members and 1 Guest are viewing this topic.

georgemt

  • Member
  • Posts: 4
    • View Profile
import cvs file
« 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

Bill Randall

  • Administrator
  • Posts: 53
    • View Profile
    • http://www.fptech.net
Re: import cvs file
« 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 »
Bill Randall

georgemt

  • Member
  • Posts: 4
    • View Profile
Re: import cvs file
« 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.

Bill Randall

  • Administrator
  • Posts: 53
    • View Profile
    • http://www.fptech.net
Re: import cvs file
« 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.
Bill Randall

marcelus23

  • Member
  • Posts: 1
    • View Profile
Re: import cvs file
« 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  ;)

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 :::::::::