Value or character search

[idehen]

Hope you all had a merry xmas and nice holiday.

I am using CR10 and want to search using a formula for a character as in the example.

Nos Name
12345 ABC
6788 DEF
69885 KLM

In this example, what i am trying to get is, where the 4th character or number is 4 name should be ABC and where 4th Character is 8 then DEF.

So last example above "KLM" is false. My problem is, how do i search for a character with data type "number" as "Like" only works for strings or text.

Is there a function for searching within data type numbers?

Thanks

 

[CR85user]

If {table.Nos}[4] = 4 and {table.Name} like 'ABC' then 'True'
else
If {table.Nos}[4] = 8 and {table.Name} like 'DEF' then 'True'
else
'False'

Obviously you can expand on this to give more accurate feedback and alternatives:

//{@Checkmatch}

If {table.Nos}[4] = 4 and {table.Name} like 'ABC' then 'True #4 ABC' else
If {table.Nos}[4] = 4 and not({table.Name} like 'ABC') then 'False #4' else
If {table.Nos}[4] = 8 and {table.Name} like 'DEF' then 'True #8' else
If {table.Nos}[4] = 8 and not({table.Name} like 'DEF') then 'False #8' else
'False - no match'


You can simplify this formula a lot by declaring variables intially for the numeric and string values if need be:

//{@Neatercheck}

Numbervar x := {table.Nos}[4];
Stringvar y := {table.Name}

If x = 4 and y like 'ABC' then 'True #4 ABC' else
If x = 4 and not(y like 'ABC') then 'False #4' else
If x = 8 and y like 'DEF' then 'True #8' else
If x = 8 and not(y like 'DEF') then 'False #8' else
'False - no match'

Hope this helps to get you started.

'J

CR8.5 / CRXI - Discovering the impossible

 

[idehen]

Thanks CR85user.

I am getting a message: A string or an Array values is required here.

I have used the formula.

1) If {table.Nos}[4] = 4 and {table.Name} like 'ABC' then 'True'
else
If {table.Nos}[4] = 8 and {table.Name} like 'DEF' then 'True'
else
'False'


2)
Numbervar x := {table.Nos}[4];
Stringvar y := {table.Name}

If x = 4 and y like 'ABC' then 'True #4 ABC' else
If x = 4 and not(y like 'ABC') then 'False #4' else
If x = 8 and y like 'DEF' then 'True #8' else
If x = 8 and not(y like 'DEF') then 'False #8' else
'False - no match'


Both are coming back with same String or an Array values is required here.

Any advise please. Appreciate the quick response.

Thanks again.

 

[CR85user]

Where is the cursor positioned when it shows that error?

'J

CR8.5 / CRXI - Discovering the impossible

 

[idehen]

The cursor is positioned on the "{table.Nos}".

 

[lbass]

Convert the number to a string first:

stringvar x := totext({table.nos},0,"");
if x[4] = 4 and
{table.Name} = 'ABC' then
true else
if x[4] = 8 and
{table.name} = 'DEF' then
true

-LB

 

[idehen]

Many thanks for your assistance guys.

The conversion did the trick and this works perfect.

Appreciate all the help!!