Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Bug or not?

    Version = SWITCH( TRUE(), ( SEARCH("7", default[Flowsheet],,0) > 0), MID("7",1,5), ( SEARCH("8", default[Flowsheet],,0) > 0), "My folder", "Ohter software")   Too few arguments were passe...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I fixed this by using double commas

     

     

    MID(default[Flowsheet],9,,5)
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

looks like bug with the locale. 

im using ";" not "," as delimiter and for its working good

mid("7";1;5)

bytheway, why dont you use LEFT function if you are trying to get first 5 symbols?

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I fixed this by using double commas

     

     

    MID(default[Flowsheet],9,,5)