Forum

Aho!

I'm doing the inventory review and I need to remove a substring "cage" from about 1000 of strings. Only the first time this string occurs, case insensitive and only if it occurs at the beginning, say, not farther than 50 characters from the beginning of the source string. Can anyone please help me with the implementation? I tried to use StrReplace, but it replaces all words. However, in some cases, the "cage" substring is a part of other words or is a useful part of a description and should stay unchanged.

Thanks in advance!

If I right understand your task:

Function RemoveCage(str)
   removingSubString = "cage";
   lenSub = StrLen(removingSubString);
   
   firts50 = Lower(Mid(str, 1, 50)); // use Lower for case insensitive
   pos = Find(firts50, removingSubString);
   If (pos > 0) Then
      return Left(str, pos - 1) + Mid(str, pos+lenSub); // remove cage
   else
      return str; // nothing remove
   EndIf
EndFunction

Thank you, Ivan! You're superfast!