HMGforum.com

Hello all

I'm Using hmg v3.0.25. I'm trying to append to a dbf from a delimited data txt file using:
APPEND FROM xcFile DELIMITED WITH optional clause

I can actually import data this way if the fields from file txt came delimited with commas.

But if data are separated with other different character as Pipe '|' APPEND FROM xcFile DELIMITED WITH '|' do not function as clipper/dbase original design was made

It seems like if nothing else was need this option with harbour actually..
or maybe I am doing something bad?

Thanks in advance
Arturo

Im Using hmg v3.0.25
C:\hmg.3.0.25\HARBOUR\bin>harbour
Harbour 2.0.0 (Rev. 13372)
Copyright (c) 1999-2010, http://www.harbour-project.org/

Saludos
Arturo

I found the way this command is implemented in harbour:

APPEND FROM DELIMITED WITH PIPE

Is very usefull if comma may to be used inside a field, as part of data, like in a addres, etc..

I hope this will hope to somebody

Saludos desde Mexico
Arturo.

Thanks a lot for the info.

Hola Arturo, saludos desde Turkiye

arturo_lopesoria wrote: APPEND FROM xcFile DELIMITED WITH '|' do not function.
...
I found the way this command is implemented in harbour:
APPEND FROM DELIMITED WITH PIPE
Is very usefull if comma may to be used inside a field, as part of data, like in a addres, etc..

Does "PIPE" is a built-in (by Harbour) constant or we have declare and initialize it ?

such as
Anyway it isn't logical
will work, though
doesn't work.

If so, IMHO this will be considered a bug in Harbour

Any opinion

This is from Harbour changelog:

APPEND FROM ... DELIMITED WITH TAB
APPEND FROM ... DELIMITED WITH PIPE
APPEND FROM ... DELIMITED WITH ( { cStrDelim, cFldSeparator } )

It seems that, 'PIPE' is hard coded in src/rdd/dbcmd.c

Thanks Rathi

Best regards

Esgici, Rathi.
Thanks to both as allways
Arturo

The command

COPY FIELDS ID,NAME TO temp.txt DELIMITED

works fine, but the

APPEND FROM temp.txt TYPE DELIMITED

can't even pass the compile process...


==================================

EDIT: never mind and forget it, JPARADA show me the right way*, thank you.

* http://hmgforum.com/viewtopic.php?f=24& ... TED#p10950

Czarny_Pijar wrote:APPEND FROM temp.txt TYPE DELIMITED
can't even pass the compile process...

Can't have the TYPE. Try in this way: