Change file definition of a CSV file - Clipper

On Thu, 2 Oct 2008 19:56:57 +0200, E®!k \\/!sser <nospam@nospam.com>
wrote:

Hello Erik,

>VS has everything you need and so much more, you might get overwelmed.
>(at least I am ..<g> )
>

But does it have block select?

Windows and Office is used by millions as well. Does that make it a
good product?

Dick

On Sep 30, 8:13 am, "Stephen Quinn" <stevej...@SPbigpond.AMnet.au>
wrote:
> Rob
>
> >I need to update the contents of an CSV file. I can not use Excel
> > because I basically need to change the record definition of this CSV
> > file. Has someone experience with opening CSV files in VO and saving
> > it as an (amended) CSV file using VO?
>
> CSV are text files so using FOpen()/Fread()/FClose() would be the way to go
> OR
> simpler still is use the FileObj class that's in the old VO25Forum Library.
> Eg
>     oFile := FileObj{ cFileName, FO_READWRITE }
>     DO WHILE ! oFile:EOF
>         Aadd( anArray, oFile:Read() )
>     ENDDO
>     // Do whatever with the array
>
> CYA
> Steve

Hi Steve, when I need to do this (we work a lot with csv files to port
to state systems), I rename source, read it one line at a time, modify
as necessary (sometimes records are dropped, sometimes altered), and
then write it back to the original filename as the destination.

hope this is useful

Tony

100k? Are you kidding.... I heard the number was more like 5 million ( and
I read that more than a year ago.... it may be more now ). Maybe the 100k
was at any one time during the day. ( Simultaneous users ) It's hard to
believe those numbers but just think of just the schools. My son is a
computer science student and he's been using VS since high school.

Al

"E®!k \/!sser" <nospam@nospam.com> wrote in message
news:6kkgbcF8g88sU1@mid.individual.net...
> What is the bet?
>
> Dick, VS is dayly used by >100k developers all over the worlds.
> Do you really think they would use a criple dev envoirenment?
> VS has everything you need and so much more, you might get overwelmed.
> (at least I am ..<g> )
>
> Erik
>
>
>
>
>
>
>
> "D.J.W. van Kooten" <public@ic2remove.this.com> schreef in bericht
> news:451ae4dep7dtiglidc4u85r5j09flmpcl7@4ax.com...
>> On Thu, 02 Oct 2008 18:15:31 +0200, Karl Faller
>> <k.faller_withoutthat_@onlinehome.de> wrote:
>>
>>>>No, that's interesting. In what way?
>>>Shift-Shift ("Double Shift") +Arrow marks blockwise, did that almost
>>>from the beginning...
>>>
>> Hello Karl,
>>
>> Ah, I thought it supported Textpad someway!
>>
>> Yes, I think VIDE is a brilliant product. I bet VS doesn't support
>> this!
>>
>> Dick
>

Of course it has block select.... column select keyboard recordings etc etc.
That's pretty basic stuff. I have my VS text editor set so it uses exactly
the same keyboard short cuts as my Multi Edit editor... ( The Brief commands
are an option so you can just select that and change as needed. )

Al

"D.J.W. van Kooten" <public@ic2remove.this.com> wrote in message
news:s9aae4lpc444h3tvduj11rbd18fdeohkkh@4ax.com...
> On Thu, 2 Oct 2008 19:56:57 +0200, E®!k \\/!sser <nospam@nospam.com>
> wrote:
>
> Hello Erik,
>
>>VS has everything you need and so much more, you might get overwelmed.
>>(at least I am ..<g> )
>>
>
> But does it have block select?
>
> Windows and Office is used by millions as well. Does that make it a
> good product?
>
> Dick

On Thu, 2 Oct 2008 20:05:00 -0600, "Al Acker" <al@thexbasefiles.com>
wrote:

Hi Al,

>Of course it has block select.... column select keyboard recordings etc etc.
>That's pretty basic stuff.

As I am not using VS, I wouldn't know. I just took the ****ogy with
other MS products which are usually 5-10 years behind in introducing
useful new stuff. For example, PDF export in Word was introduced in
2007 while it was present in WordPerfect since 2001. PDF import,
present since the previous version of WordPerfect will probably be
there in Word 2012. I haven't found a single MS product for which
there are not one or more better alternatives. I can't imagine VS to
be the exception. The number of users isn't the proof I would say.

Dick

Hi Dick,

>>VS has everything you need and so much more, you might get overwelmed.
>>(at least I am ..<g> )
>>
>
> But does it have block select?
Al spoiled it , otherwise I would say "you wanted to bet, so first to tell
me what the bet is...."

> Windows and Office is used by millions as well. Does that make it a
> good product?

Pretty mature stuff. I do not complain about them. It can everything I want
and does it in a reliable way.
Last version of WP I used, came for free together with a HP inktcartridge.
I think it was a Corel WP 6 or 7
Never seen such a criple, lame and instable product!!

You use automation for mailmerge. Have you ever tried to get that stable
with WP?


Erik

On Fri, 3 Oct 2008 09:13:16 +0200, E®!k \\/!sser <nospam@nospam.com>
wrote:

Hi Erik,

>> Windows and Office is used by millions as well. Does that make it a
>> good product?
>
>Pretty mature stuff. I do not complain about them. It can everything I want
>and does it in a reliable way.

Reliable? There's so much which doesn't work properly. Have you ever
tried to make a good working table of contents in a 100 page document?
It didn't work in Office 2003 and it still doesn't in Office 2007. If
you like I can send you a document - and I bet you can't get a correct
and complete TOC in it either -whatever tricks you try.

If I read your postings in the Grafx.VS section I would conclude that
the stability of VS also leaves to be desired....

>Last version of WP I used, came for free together with a HP inktcartridge.
>I think it was a Corel WP 6 or 7
>Never seen such a criple, lame and instable product!!

Admitted. That's partly why they lost the market. However, from
version 9 it is much better and has several features I use daily not
found in Office. For example: the 'underwaterscreen' allowing you to
edit codes is vastly superior to the way you have to struggle with
trying to change (incorrrect set) lay-out in Word. Reading the exact
position of your text instead of estmating it from the rulers.
Exporting PDF since version 9, only now in Office 2007 (even importing
from WordPerfect X3). If this would all be present in Office 2007 I
wouldn't complain.

I think most MS applications are mediocre products bought by everyone
because "everyone uses it". No doubt it's the same for VS...
>
>You use automation for mailmerge. Have you ever tried to get that stable
>with WP?

No, because none of my clients use WP unfortunately and then it's too
much work. But it's a shame.

Dick

Hi Dick,

> Reliable? There's so much which doesn't work properly. Have you ever
> tried to make a good working table of contents in a 100 page document?
> It didn't work in Office 2003 and it still doesn't in Office 2007. If
> you like I can send you a document - and I bet you can't get a correct
> and complete TOC in it either -whatever tricks you try.

I must admit I never mkae a TOC. What arew you using this for, writing
helpfiles?
I have better tools for that.

>
> If I read your postings in the Grafx.VS section I would conclude that
> the stability of VS also leaves to be desired....

I am sorry if I express myself not well enough.
All problems I come across with Visual Studio are related to the integration
of Vulcan.

>
>>Last version of WP I used, came for free together with a HP inktcartridge.
>>I think it was a Corel WP 6 or 7
>>Never seen such a criple, lame and instable product!!
>
> Admitted. That's partly why they lost the market. However, from
> version 9 it is much better and has several features I use daily not
> found in Office. For example: the 'underwaterscreen' allowing you to
> edit codes is vastly superior to the way you have to struggle with
> trying to change (incorrrect set) lay-out in Word. Reading the exact
> position of your text instead of estmating it from the rulers.
> Exporting PDF since version 9, only now in Office 2007 (even importing
> from WordPerfect X3). If this would all be present in Office 2007 I
> wouldn't complain.
>
> I think most MS applications are mediocre products bought by everyone
> because "everyone uses it". No doubt it's the same for VS...
>>
>>You use automation for mailmerge. Have you ever tried to get that stable
>>with WP?
>
> No, because none of my clients use WP unfortunately and then it's too
> much work. But it's a shame.

Be happy, you wouldn't get it to work properly.


Erik

On Fri, 3 Oct 2008 11:04:08 +0200, E®!k \\/!sser <nospam@nospam.com>
wrote:

Hello Erik,

>I must admit I never mkae a TOC. What arew you using this for, writing
>helpfiles?
>I have better tools for that.


For writing books and publications. Nothing to do with my programming.
Dick