Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[tranquilo]

I have a user library field of data type string that contains a year and other characters, like "1977ABC...etc", and would like to create a Smartlist where one of the rules checks if the standard field "Year"  (converted to a string) is equal to the first four characters of the user defined field. Sort of like Str([Year])=Mid([MyStringField],0,4).

I have looked at the functions wiki, and found Mid(), but cannot find a function to convert "Year" to a string.

Help?

Edited to add: using MC 12.0.530

[gappie]

i guess

Code: [Select]

if(isequal([year],[MyStringField],8),yeah,hell no), where yes means they are equal, could work.
i did not test it in my machine. but when it does not work. please say so.

 
gab

did test it... this worked for me:

Code: [Select]

if(isequal([year],mid([test],0,4),8),yeah,hell no)

[tranquilo]

Thanks!

Yes, the first solution didn't work as posted, but it gave me a start to try different combinations, so I arrived at one almost the same as your second suggestion:

[=isequal([Year],Mid([MyStringField],0,4),0)]=1

I opted for compare type 0 because with Mid() I can go for a exact match.

Much appreciated; would never have found it without your help.

[gappie]

nice that you found it. yes, the 8 was a left over from my first try.. 0 makes more sense in this case.

 
gab