列数 [英] number of columns

问题描述

如何知道.csv文件的列数？我想将

导入数据库。

谢谢。


Atse

解决方案

atse写道：

我怎么知道.csv文件的列数？我想
将它们导入数据库。

拆分和未结算可能


-

William Tasso - http://WilliamTasso.com

你能告诉我更多细节吗？有样品吗？谢谢。


" William Tasso" <是ne **** @ tbdata.com>在消息中写道

news：ux **************** @ TK2MSFTNGP11.phx.gbl ...

atse写道：

我如何知道.csv文件的列数？我想将它们导入到数据库中。

分裂和不受欢迎

-
William Tasso - http://WilliamTasso.com

2003年10月6日星期一19:02:19 GMT，atse <杜****** @ yahoo.com>写道：

你能告诉我更多细节吗？有样品吗？谢谢。

威廉塔索 <是ne **** @ tbdata.com>在消息中写道
新闻：ux **************** @ TK2MSFTNGP11.phx.gbl ...

atse写道：

>我怎么知道.csv文件的列数？我想
>将它们导入数据库。

拆分和未绑定可能

s =" a，b，c ，d，e"

a = split（s，，）

n = ubound（a）


At这一点，n应该等于4，因为a是一个基于零的数组。任何比这更多的b $ b，我将不得不向你收取咨询费:)

Hi,

How can I know the number of columns of the .csv files? I want to import
them to the database.
Thanks.

Atse

解决方案

atse wrote:

How can I know the number of columns of the .csv files? I want to
import them to the database.

split and ubound maybe

--
William Tasso - http://WilliamTasso.com

Can you tell me more detail? Any sample? Thanks.

"William Tasso" <ne****@tbdata.com> wrote in message
news:ux****************@TK2MSFTNGP11.phx.gbl...

atse wrote:

How can I know the number of columns of the .csv files? I want to
import them to the database.

split and ubound maybe

--
William Tasso - http://WilliamTasso.com

On Mon, 06 Oct 2003 19:02:19 GMT, "atse" <du******@yahoo.com> wrote:

Can you tell me more detail? Any sample? Thanks.

"William Tasso" <ne****@tbdata.com> wrote in message
news:ux****************@TK2MSFTNGP11.phx.gbl...

atse wrote:

> How can I know the number of columns of the .csv files? I want to
> import them to the database.

split and ubound maybe

s = "a,b,c,d,e"
a = split(s, ",")
n = ubound(a)

At this point, n should equal 4 since a is a zero based array. Any
more than this, I will have to charge you a consulting fee :)

这篇关于列数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！