Discussions

 View Only
  • 1.  Remove extra space when using a formula Quiery

    Posted 15 days ago

    Hello everyone,

    I have a formula that brings in data from another table and it could have multiple results.  When I do there is an extra space at the end before the ";".  I have been trying to figure out how to get rid of the space but no luck.  I either remove all spaces or I only get part of my results.

    Formula: 
    ToText(GetFieldValues(GetRecords("{8.EX.'"&[Project]&"'}", [_DBID_X]), 286))

    Result with extra space before the ;
    1 % ; 1 % ; 1 % or 5 mg ; 10 mg

    Trying to get
    1 %; 1 %; 1 % or 5 mg; 10 mg

    Any help is appreciated. 

    Thanks



    ------------------------------
    Jennifer Silberstein
    ------------------------------


  • 2.  RE: Remove extra space when using a formula Quiery

    Posted 15 days ago
    You can surround the enter formula with search and replace to remove " ; " and give ";" 

    SearchandReplace(ToText(GetFieldValues(GetRecords("{8.EX.'"&[Project]&"'}", [_DBID_X]), 286))," ; ",";")

    PS - I've typed formula from memory , use formula 
    builder if errors

    ------------------------------
    Prashant Maheshwari
    ------------------------------



  • 3.  RE: Remove extra space when using a formula Quiery

    Posted 14 days ago
    Hello Prashant,

    That worked perfectly.

    Thank you

    ------------------------------
    Jennifer Silberstein
    ------------------------------