CSV.BAT - CSV file manipulation with SQL syntax

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Message
Author
npocmaka_
Posts: 479
Joined: 24 Jun 2013 17:10
Location: Bulgaria
Contact:

Re: CSV.BAT - CSV file manipulation with SQL syntax

#31 Post by npocmaka_ » 27 Nov 2018 13:42

Ed Dyreen wrote:
24 Nov 2018 12:22
why don't you use SQL scripts to create, manage, convert update or delete databases ?

Can your SQL program not do that ?
Because I had CSVs. This script is not bad for basic CSV processing and the JET Engine is a basically a database engine installed with your windows by default. Though It can be extended - It would be useful if you can use/create a custom schema file in order to handle other data types than string.

Squashman
Expert
Posts: 4013
Joined: 23 Dec 2011 13:59

Re: CSV.BAT - CSV file manipulation with SQL syntax

#32 Post by Squashman » 27 Nov 2018 14:10

npocmaka_ wrote:
27 Nov 2018 13:42
It would be useful if you can use/create a custom schema file in order to handle other data types than string.
I thought Rojo explained how to do that in this thread because I had asked him about it.

rojo
Posts: 26
Joined: 14 Jan 2015 13:51

Re: CSV.BAT - CSV file manipulation with SQL syntax

#33 Post by rojo » 28 Nov 2018 12:59

Squashman wrote:
27 Nov 2018 14:10
npocmaka_ wrote:
27 Nov 2018 13:42
It would be useful if you can use/create a custom schema file in order to handle other data types than string.
I thought Rojo explained how to do that in this thread because I had asked him about it.
I think he did. viewtopic.php?p=43562#p43562

npocmaka_
Posts: 479
Joined: 24 Jun 2013 17:10
Location: Bulgaria
Contact:

Re: CSV.BAT - CSV file manipulation with SQL syntax

#34 Post by npocmaka_ » 28 Nov 2018 13:31

rojo wrote:
28 Nov 2018 12:59
Squashman wrote:
27 Nov 2018 14:10
npocmaka_ wrote:
27 Nov 2018 13:42
It would be useful if you can use/create a custom schema file in order to handle other data types than string.
I thought Rojo explained how to do that in this thread because I had asked him about it.
I think he did. viewtopic.php?p=43562#p43562
Thanks.

Post Reply