Forum Discussion

JenniferSilbers's avatar
JenniferSilbers
Qrew Trainee
3 years ago

Remove extra space when using a formula Quiery

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
------------------------------
formula queries
  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Captain
    3 years 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
    ------------------------------
    • JenniferSilbers's avatar
      JenniferSilbers
      Qrew Trainee
      3 years ago
      Hello Prashant,

      That worked perfectly.

      Thank you

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