Results 1 to 7 of 7

Thread: append pipe delimited file

  1. #1
    Senior Member
    Join Date
    Nov 2014
    Location
    Kailua, Hawaii
    Posts
    104

    append pipe delimited file

    Hello,

    I will be receiving several files every month that are pipe delimited. I imported a blank foxpro table by the drag and drop method. So far so good.

    Then I tried to import the delimited text file with the command:
    append from HI_10192015.txt delimited with "|"

    also tried:
    append from HI_10192015.txt delimited with character "|"

    And lastly, just to make sure it will append at all, I tried:
    append from HI_10192015.txt delimited
    this appended okay but of course it did field correctly.

    This is the error I got for the first command that I thought would work correctly:
    **** Lianja error ****
    append from HI_POLS_10192015.txt delimited with "|"
    ^
    Syntax error in command

    Seems like it does not like the pipe as a delimiter.
    Is it possible to do this append?

    Thanks,
    Steve

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,799
    Hi Steve,

    Omit the quotes:

    Code:
    append from HI_10192015.txt delimited with |
    Regards,

    Yvonne

  3. #3
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,176
    Hi Yvonne,

    delimited with tab isn't documented. Should that work?

    thanks,

    Hank

  4. #4
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,799
    Hi Hank,

    No, not currently supported.

    Regards,

    Yvonne

  5. #5
    Senior Member
    Join Date
    Nov 2014
    Location
    Kailua, Hawaii
    Posts
    104
    Thanks Yvonne and Hank,

    Unfortunately, that didn't work. I copied Yvonne's command and pasted it into the console window and tried it. But the data came in as if it were a fixed length file. Here's what the data looks like in my first field (all other fields are blank).

    22039012|Y|1|20150809|20150708|20150707|20150707|0 |

    Just for kicks, I tried adding quotes to the first few fields,
    e.g. "22039012"|"Y"|"1|20150809|20150708|20150707|20150 707|0|

    But that didn't make any difference.

    If you have any other suggestions, I'm eager to try them,

    Steve

  6. #6
    Senior Member
    Join Date
    Nov 2014
    Location
    Kailua, Hawaii
    Posts
    104
    Just realized that the max number of fields is 256 which is short of the 344 I need.
    The file extension for the table I created in Lianja ends in ".dbf" but if I try to open it in FoxPro, Foxpro says it isn't a table so I've been assuming it's a Lianja SQL database.

    Is it a Lianja SQL file and if so, does that have a 256 field limit?

    And if it does have a 256 field limit, do you have any suggestions on how I can get around this like maybe using postgres?

    Thanks,
    Steve

  7. #7
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,176
    Hi Steve,

    the maximum number of columns in a table is 256, according to http://www.lianja.com/doc/index.php/System_Capacities.

    Hank

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us