append pipe delimited file

[StevenH]

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

[yvonne.milne]

Hi Steve,

Omit the quotes:

append from HI_10192015.txt delimited with |

Regards,

Yvonne

[HankFay]

Hi Yvonne,

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

thanks,

Hank

[yvonne.milne]

Hi Hank,

No, not currently supported.

Regards,

Yvonne

[StevenH]

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

[StevenH]

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

[HankFay]

Hi Steve,

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

Hank