Forum Discussion

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

    That worked perfectly.

    Thank you

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