zliczanie w stringu takich samych znakow.

Article View: pl.comp.lang.vbasic

Article #104447

Back to pl.comp.lang.vbasic Previous Next

#104447

From: ThomasX
Date: Fri, 22 Jan 2010 09:42

8 lines
1796 bytes

Mam bardzo dlugie teksty w kolejnych wierszach Excela. Chce by
procedura wyszukiwala w kazdej komorce takie same znaki np: ciag
"aaa", "bbb", "ccc" itd. i po pierwsze zliczyla ile jest ciagów "aaa",
"bbb", "ccc" i po drugie skopiowala te ciagi do kolejnych komorek w
innym arkuszu.... no i oczywiscie wykonywala to samo dla kolejnych
wierszy.

...jaka funkcją moge zliczyc takie same ciagi w stringu?

Technical Details

Message-ID: <c2b98cd6-c539-47f9-8fbd-c1f64f764a3a@l30g2000yqb.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!plix.pl!newsfeed1.plix.pl!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!l30g2000yqb.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!plix.pl!newsfeed1.plix.pl!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!l30g2000yqb.googlegroups.com!not-for-mail
From: ThomasX <matuss@o2.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: zliczanie w stringu takich samych znakow.
Date: Fri, 22 Jan 2010 01:42:41 -0800 (PST)
Organization: http://groups.google.com
Lines: 8
Message-ID: <c2b98cd6-c539-47f9-8fbd-c1f64f764a3a@l30g2000yqb.googlegroups.com>
NNTP-Posting-Host: 195.85.196.35
Mime-Version: 1.0
X-Trace: posting.google.com 1264153362 2754 127.0.0.1 (22 Jan 2010 09:42:42 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 22 Jan 2010 09:42:42 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: l30g2000yqb.googlegroups.com; posting-host=195.85.196.35;  posting-account=yRyhpwoAAAAjsbOpXtrCrjlyHZmsJx14
User-Agent: G2/1.0
X-HTTP-Via: 1.0 SRV3ISASOK
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1;  Trident/4.0; SecureStation; .NET CLR 1.1.4322; InfoPath.1; .NET CLR  2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; SmartCardLogin),gzip(gfe),gzip(gfe)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit