RemoveCarriages ( text )
Removes Multi carriage returns within a text
Average rating: 4.4 (30 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
It will only replaces the no of carriages returns within the input text and keeps only one in each case. Means if there are 4 consecutive carriage returns in some place then it will replace all and keep only a single one.
Aug 22, 2014
|I’m not getting this to work out-of-the-box.
I remember other CFs that can do this, take a look at RemoveExtraReturns?
Aug 23, 2014
|So you accomplish what here?
This seems to demonstrate that even with a really simple problem statement, solved successfully by others, you propose a solution which does not work, which changes the user's data if # characters already exist in the user's data, which requires outside technical review and mods to eventually achieve a functioning and reliable result.
Aug 25, 2014
In place of this "#", you can take any chacarter.
is wrong, since "¶" is not allowed.
you should change "#" to a character not used in text
may be right.
Something like Char(1) may be used any case.
Aug 25, 2014
|Yes, There is also a CF which is doing the same.
But here I mentioned this as it is simpy a 1 line code that replaces all the carriage returns only within the text. In once cases I found some values(field values) which have more no of carriage returns and I want to remove that. So I did it to replaces all the extra carriage returns withins that field values.
Below is the data that needs to be passed by this custom function.
23¶567¶¶43¶23¶¶¶89 and it should be like this 23¶567¶43¶23¶89.
I haven't also tested for other character. Thanks Unix for showing me the same.
|CesarRG, Oviedo, Spain
Mar 9, 2015
|Your original function
1#¶¶2¶¶¶¶2¶¶ return 12¶2
The function with the clarification of unix, returns
Substitute ( Text ; ["¶¶" ; "¶" & Char(1) ];[Char(1) & "¶";""] ;[Char(1);""] )
1#¶¶2¶¶¶¶2¶¶ return 1#¶2¶2
Change the function to unix clarification
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.