PatternCount ( uppercase Search) - any ideas

[imoree]

Hello everyone;

i was wondering as i don't see any built in functions to check for "A" vs "a" how i can do that!

I even looked on bd's website and can't find matchCaseUpper or Lower,etc

I was trying something like this, but no luck yet!

Let ( [

	  word  = "ArChiVe";     // my word

      marker = "^case^";    // this makes it unique

      find = marker & "ArChiVe" ;   // ^case^ArChiVE

      result = substitute ( word; "ArChiVe"; find )    //What up?



];

position( word; find ; 1 ; 1)

)

- i don't think i am close, need some advice please.

Edited March 27, 2012 by imoree

[Fitch]

Exact

[comment]

i don't think i am close, need some advice please.

Close to what? You didn't say what's the purpose here - and sadly, your process doesn't make it clear either.

[imoree]

Close to what? You didn't say what's the purpose here - and sadly, your process doesn't make it clear either.

I am trying to match the case of Q instead of q

so what i need is to make search criteria, but my string is actually

QWERTYUIOPASDFGHJKLZXCVBNM for uppercase

Using exact, that is what i have to use.

was trying to do a little cleaner

[imoree]

GOT IT!

// MatchCase ( text; search; match )



let([

      tag = "%^Unique^%";

      find = tag & search ;

      text = substitute ( text; search; find )

       ];

       position ( text; find ; 1; 1)  

      )



eg. text = "1234567890qwertyuiopasdfghjklzxcvbnm" . results in 0

      text = "1234567890QWERTYUIOPASDFGHJKLZXCVBNM" . results in 11 ( if search is "QWE"  or uppercase letters here )

Edited March 28, 2012 by imoree

[imoree]

Changes to above; Cleaner

result is either 1 or 0

Let([



      tag = "%^Unique^%";

      find = tag & search; 

      text = Substitute ( text; search; find );

      final = Position ( text; find ; 1; 1 )

];

      Case ( final = 0; 0; 1 )

)

[Lee Smith]

Automatic message

This topic has been moved from "The Presentation Layer → Advanced & Developer Features" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".