Skip to main content
Question

Remove extra space when using a formula Quiery


Forum|alt.badge.img+5

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+11
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
------------------------------