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 passed to the MID function. The minimum argument count for the function is 3.
  • Anonymous's avatar
    Anonymous
    6 years ago

    I fixed this by using double commas

     

     

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

2 Replies

  • az38's avatar
    az38
    Community Champion

    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

      I fixed this by using double commas

       

       

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