Position and Pattern Count - DIFFERENT RESULTS ! !

[CoZiMan]

Hello all,

Just seeking confirmation of a bug or a workaround.

I am working on copying and pasting text from existing html for re-purposing.

So here's the issue. I can do a pattern count and the result is positive.

When I use a Position statement in a field calculation it returns 0 - no data found.

I believe this is related to unicode support. Since v7 we can't choose ASCII as an indexing option so it doesn't strip the extra bit codes.

I am also using a filter to strip all but the basic characters and it doesn't work either.

Not expecting a quick answer.

here's a sample file.

TheBiz.zip

[RalphL]

I see one problem, look at the calculation for Fax.

Case ( PatternCount (Text1 ; Constants::Fax );

TextSize (

TextStyleAdd (

Let(Phone = Filter(

Substitute ( TrimAll (

Middle (

Text1;

Position ( Text1; Constants::Fax; 0; 1 ) + Length ( Constants::Fax );

(Position (Text1; Constants::eMail ; 0;1)) - (Position ( Text1; Constants::Fax; 0; 1 ) + Length ( Constants::Fax)))

; 1 ; 0 ) ;[ "

[CoZiMan]

Understood. That's one more layer that's coming.

[transpower]

According to FM Help,

"If you have been using the ASCII setting for sorting and indexing data in previous versions of FileMaker Pro, you can use the Unicode setting to achieve similar results."

Are you saying that you used to use ASCII, which worked, and are now using Unicode, which doesn't work?