Import or Append what else could work for a big comma-delimited file to be transferred into *.dbf ? 6

[german12]

When I have a textfile like this:

aa105, bbb, ccc, ddd......
aa106a, bb, cc176, ddfa34....

and a very huge amount of further lines.

it is of course possible to transfer that into a *.dbf - file by using

[FOR lExpression] [[TYPE] [DELIMITED [WITH Delimiter | WITH BLANK | WITH TAB | WITH CHARACTER Delimiter] | DIF | FW2 | MOD | PDOX | RPD | SDF | SYLK | WK1 | WK3 | WKS | WR1 | WRK | CSV | XLS | XL5 [SHEET cSheetName] | XL8 [SHEET cSheetName]]] [AS nCodePage]]

but that only works, when the amount of data does not exceed the restricted 2 GB Limit for a *.dbf in VFP.

Is there any possibility to pick only the 2nd. "column" in the sample above, when only that is needed?
(It is the "column" with bbb, bb above).
So instead of dividing a textfile "horizontal" into a lot of parts, could it be that it could be done "vertical", by filtering only every 2nd. string (or 3rd,4th)(which could it make possible to split the text into several
*dbf's and therefore it could be possible to create just a few *dbf's?

Again - to take that sample above:
Can I create the following dbfs somehow?:

DBF#1: aa105
aa106a

DBF#2: bbb
bb

DBF#3:cc
cc176

DBF#4:ddd
ddfa34

Could low-level functions eventually help here?
Unfortunately I have no experience with that commands.

Thanks in advance

Klaus


Peace worldwide - it starts here...

 

[Chris Miller]

Yes, I know Mike (of course ).

There are so many ready to use forums and just like a blog you even get them hosted for free - well, for adverts, usually.
Or you can take an open source one and install it on your own domain.

And things like spam prevention and more are usually built in already and any active project of forum software will also fix problems.

https://www.woltlab.com/

as a less known quality example.

Chriss

 

[GriffMG]

I've hosted and moderated forums... what an education that is.

This is pretty sane by comparison.


Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Mike Lewis]

That internal forum I created was in fact based on existing open-source forum software. But just customising it for the client's needs was a major pain. And security was a constant worry. I hope I never have to do anything like that again.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[german12]

What you call experts, I call unscientific typical programmers.

In Germany the answer to such sentences is this:
"Hochmut kommt vor dem Fall"
translated:
Arrogance comes before the fall

Klaus




Peace worldwide - it starts here...

 

[Dan Olsson]

In Germany the answer to such sentences is this:
"Hochmut kommt vor dem Fall"
translated:
Arrogance comes before the fall

That's actually from the Bible, Proverbs 16:18

 

[Mike Lewis]

The more usual expresesion in English is "Pride comes before the fall". Similar to arrogance, but not quite the same.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[german12]

That's actually from the Bible, Proverbs 16:18

Thank you Dan - I did not know that.

The more usual expression in English is "Pride comes before the fall". Similar to arrogance, but not quite the same.

That is also interesting compared with the german expression

btw: My translation "Hochmut" = "arrogance"in english was made by Google.

Pride means "Stolz" in german - one can be proud of his children, his country etc.
In our fairy tales there is also often written about a " proud knight. " (="stolzer Ritter")
So this means in most cases a positive characteristic one can have.

An exception is the term "false pride" - "falscher Stolz" which speaks for itself because of that attribut "false" - e.g. one cannot be proud of always being able to teach others.

That leads to a social distance in the long run.

A man has just been arrested here because he did not comply with the demands of a tank attendant who warned him not to come into the store without a face mask. (protection against Covid)
The man then shot the gas station attendant because of it.
He certainly couldn't be proud of that.

With "arrogance" (masculine) is meant a condescending being, so ALWAYS a negative quality. Haughty people place an unrealistically high value on their own worth, rank, or ability.

There is the word arrogance for this - they are people who pretend to be on the outside - but on the inside they feel inferior. They relate their self-esteem to the fact that they devalue, humiliate or belittle others.

There are many similar words here for arrogance but all of them mean a negative quality.
(german: Überheblichkeit, Anmaßung, Hochmut, Selbstgefälligkeit, Vermessenheit, Blasiertheit, Großspurigkeit - und ein ganz altes Wort:
Dünkel).

Klaus


This knowledge is not my knowledge - if I said so, I would be arrogant.


Peace worldwide - it starts here...

 

[Mike Lewis]

Given that the origin of the phrase was the Bible, then the translation between English and German is not relevant. Presumably both versions were independent translations from the original Hebrew (or Aramaic?), or, more likely, from the early Greek version which was in more widespread use.

A quick search of various English versions of the Bible shows the following:

Wycliffe's Bible (14th C Middle English)
Pride goth befor contricioun, & befor falling the spirit shall ben enhauncid.

Coverdale Bible (1535)
After pryde commeth a fall, but a lowly sprete bryngeth greate worshipe.

King James Bible (1611)
Pride goeth before destruction, and a haughty spirit before a fall.

New English Bible (1970)
??? (Can't find a copy on-line; has anyone got a copy to hand?)

Whether pride is different from arrogance, and whether arrogance is better than ignorance, I'll leave it to others to discuss.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Chris Miller]

This also reminds me of the caution to think the bible is root of most proverbs or sayings. If at all, it's what bible translators made of it.

Chriss

 

[Dan Olsson]

FWIW in older Swedish Bibles the word "Högmod" is used, almost exactly the same as in German.
Google has an English translation as "hauteur", probably from French.
But more modern ones has "stolthet" i.e. pride in English.

 

[Mike Lewis]

That's interesting, Dan. The English word hauteur (which is a noun) is very similar to haughtiness, which in turn is perhaps similar to arrogance.

I think the French word hauteur (also a noun) usually simply means height or altitude. There are also French words arrogant (adjective) and arrogance (noun).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[TamarGranor]

I checked a fairly recent Jewish translation. (My Hebrew isn't good enough to translate it myself.) The whole verse is translated as:

Pride goes before ruin,
Arrogance, before failure.

Tamar