ParcaEle ( #metin ; #aranan )

Aranan jokerli parçayi yoket ; Replace string with wildcard

Average rating: 4.0 (38 votes) Log in to vote

Kadir Kaleli - Show more from this author
Yordam
http://www.yordam.com

Sample input:

#ParcaEle ( "#650 1 0 Selam #630 3 2 Türkiye
#730 4 1 Selam #12345678Dünya" ; "#^?^?^?^?^?^?^?^?" )

#ParcaEle ( "Hello World Hallo Welt." ; "W^?^?^?^?" )

Sample output:

Selam Türkiye Selam Dünya

Hello Hallo

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

 Case ( IsEmpty(#metin); "" ; 
          not PatternCount ( #metin ; Substitute ( #aranan ; "^?" ; "" ) ) ; #metin  ;

           Let ( [ 
	uzunluk =  Length ( Substitute ( #aranan ; "^?" ; "%" ) ) ;
	aranan = Left (#aranan ; Length ( Substitute ( #aranan ; "^?" ; "" ) ) ) ;

	parca = Middle ( #metin  ; Position ( #metin ; aranan ; 1 ; 1) ; uzunluk ); 
	yenimetin = Case ( PatternCount ( #metin ; aranan) ; Middle( #metin  ; Position ( #metin  ; aranan ; 1 ; 1) + uzunluk  ; Length ( #metin ) ) ; "") ;
	kalan = #ParcaEle( yenimetin ; #aranan )
                   ]; 

              If (not IsEmpty ( parca ) ;
	Middle ( #metin ; 1 ; Position ( #metin ; aranan ; 1 ; 1)  - 1 ) & kalan ; 
	kalan
              ) 
           ) 
)

Bir metinde aranan jokerli parçayi temizlemek için kullanin.
This function removes the string which includes wildcard from text

Comments

		RC, USA Nov 4, 2015
How to replace only first occurrence of string with wildcard?

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ParcaEle ( #metin ; #aranan )

Comments

Support this website.

Support this website.