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 fig...
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
------------------------------