Message 1 of 4
Feature is active with letter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I have an excel sheet which is linked to my model.
In one of the columns it says 'Opties'.
This is a combination of letters.
This can be multiple letter combinations linked to a feature.
Now I have processed each option into a case.
However, is it possible in iLogic to search in the letter code which letter is present and then turn the feature on and/or off, False or True.
Example:
F = vast , then all options are off.(false)
Hijsconstr = h
Zonwering = b
Regensensor = r
Windsensor = w
Inbraak = i
Kabel zonwering = k
I now have several opties: F, Fh, Fhi, Fhik, Fhikbrw, Fkbrw
and 30 combinations more.
Current code:
Select Case Opties Case "F" Feature.IsActive("13360-01", "Hijsconstr") = False Feature.IsActive("13360-02", "Hijsconstr") = False Feature.IsActive("13360-03", "Zonwering") = False Feature.IsActive("13360-04", "Zonwering") = False Feature.IsActive("13360-02", "Regensensor") = False Feature.IsActive("14560-01", "InbraakEind") = False Feature.IsActive("14560-01", "InbraakLi") = False Feature.IsActive("14560-01", "InbraakRe") = False Feature.IsActive("14560-01", "InbraakKop") = False Feature.IsActive("14560-02", "InbraakEind") = False Feature.IsActive("14560-02", "InbraakLi") = False Feature.IsActive("14560-02", "InbraakRe") = False Feature.IsActive("14560-02", "InbraakKop") = False Feature.IsActive("14560-03", "InbraakLi") = False Feature.IsActive("14560-03", "InbraakRe") = False Feature.IsActive("14560-04", "InbraakLi") = False Feature.IsActive("14560-04", "InbraakRe") = False Feature.IsActive("14561-04", "KabelZonwering") = False Feature.IsActive("13362-04", "KabelZonwering") = False
Case "Fkbrw" Feature.IsActive("13360-01", "Hijsconstr") = False Feature.IsActive("13360-02", "Hijsconstr") = False Feature.IsActive("13360-03", "Zonwering") = True Feature.IsActive("13360-04", "Zonwering") = True Feature.IsActive("13360-02", "Regensensor") = True Feature.IsActive("14560-01", "InbraakEind") = False Feature.IsActive("14560-01", "InbraakLi") = False Feature.IsActive("14560-01", "InbraakRe") = False Feature.IsActive("14560-01", "InbraakKop") = False Feature.IsActive("14560-02", "InbraakEind") = False Feature.IsActive("14560-02", "InbraakLi") = False Feature.IsActive("14560-02", "InbraakRe") = False Feature.IsActive("14560-02", "InbraakKop") = False Feature.IsActive("14560-03", "InbraakLi") = False Feature.IsActive("14560-03", "InbraakRe") = False Feature.IsActive("14560-04", "InbraakLi") = False Feature.IsActive("14560-04", "InbraakRe") = False Feature.IsActive("14561-04", "KabelZonwering") = True Feature.IsActive("13362-04", "KabelZonwering") = True
Mvg Jos
Youre drawings are as good as the symbols that compleet them.....
Youre drawings are as good as the symbols that compleet them.....