IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Re: Problem with that function
Post #136,229
by deSitter
Picture of deSitter
1/16/04 8:13:38 PM
Reply
New Re: Problem with that function
Just make a While loop until Instr is zero. This will be beastly slow if replacement is happening thousands of times. It's a really short loop though.

Or System("\\Cygwin\\bin\\sed...") nevermind.
-drl
Post #136,294
by Arkadiy
Picture of Arkadiy
1/17/04 2:25:06 PM
Reply
New That can be dangerous for some cases
e.g. replaceWithLoop(replaceIn="abcc", replace="abc", with="ab")
--

"It\ufffds possible to build a reasonably prosperous society that invests in its people, doesn\ufffdt invade its neighbors, opposes Israel and stands up to America. (Just look at France.)"

-- James Lileks
     Replace function in MSAccess - (ChrisR) - (10) - Jan. 16, 2004, 03:16:38 PM EST
         ObVB Mid$ -NT - (deSitter) - (6) - Jan. 16, 2004, 03:55:30 PM EST
             ...with ObVB InStr() -NT - (FuManChu) - Jan. 16, 2004, 04:55:28 PM EST
             Problem with that function - (ChrisR) - (4) - Jan. 16, 2004, 07:29:47 PM EST
                 Re: Problem with that function - (deSitter) - (1) - Jan. 16, 2004, 08:13:38 PM EST
                     That can be dangerous for some cases - (Arkadiy) - Jan. 17, 2004, 02:25:06 PM EST
                 Why write when you can Copy-n-Paste? ;) - (altmann) - (1) - Jan. 17, 2004, 01:46:47 AM EST
                     That's not going to run very well... - (FuManChu) - Jan. 17, 2004, 12:50:18 AM EST
         Which Version of Access? - (altmann) - (2) - Jan. 16, 2004, 04:04:53 PM EST
             Access 2000 - (ChrisR) - (1) - Jan. 16, 2004, 07:27:14 PM EST
                 Access 2000 should have it - (altmann) - Jan. 16, 2004, 10:05:36 PM EST

Would you like fries with that?
112 ms