Hi, when formatting text I want to ensure Capital Case (i.e. each word capitalised) for example with names in a text field. While there are Upper()
, Lower()
, Find()
, Trim()
and ReplaceRegex()
functions, there its no Split(text, text)
function, which would split a given text into an array of texts to manipulate and then Join()
back together. This would be very useful. Thanks!
i would also like to have a split function as i am importing a few documents that have valuable data in their name i want to split in table fields.
Fibery doesnāt support string arrays, so implementing a dynamic Split function would be challenging.
I understand that @njyoās need includes recombining with a Join function which would result in a single string, but maybe the effect would be best implemented as a single function (something like Map or ForEach) that operates on each word in a string.
Tbh, I think itās unlikely to happen any time soon.
Itās more likely that there would be a specific Capital() function, but even that is not guaranteed
For @dukevannoriās case, if the splitting is predictable (a guaranteed number of elements) it can probably already be done with combinations of Find() and Left() / Middle() / Right()
One example would be the names of contacts that i stored āLastName, FirstNameā in my Obsidian and also in Clickup.
Would be great to split those into two columns for better use in automations for emails etc.
then there is filenames that i used to store like this: āDate & Time (YYY-MM-DD HH:mmā) - (Type) - (Contact Names)
is that something i could split with your reccomendation?
Yes.
For the first example
you would need something like the following formulas:
Middle(Name, Find(Name, ", ") + 1, 99)
Left(Name, Find(Name, ", ") - 1)
For this
you would use variations on this theme, like
Middle(Name,14,3
to get the year
Middle(Name,18,2
to get the month,
and so on, to get the date info.
(assumes that the values remain in the same position every time)
Where there is variability in position, e.g. if Type is a variable length word, I would suggest using a Middle function to strip the first X letters, and then applying the Find function to find the end delimiter, e.g.
e.g. Left(Middle(Name, 35, 999), Find(Middle(Name, 35, 999), ")") - 1)
Alternatively, if you fancy going down a rabbit hole, you can teach yourself regex expressions and use the ReplaceRegex function instead
Or perhaps other Fibery users in the community have even better ideas
everything is possible it seems, even though often times i wonder if it needs to be so complicated
Yeah, I hear you. Unfortunately, our developers are a precious resource, and every little request (āCan it be made to do xyz? Itās just a small thingā¦ā) that they work on is time spent away from some other feature that we (or other users) think is at least as important
The workarounds are really just our way of apologising that the feature that is needed is not yet available
totally understandable and greatly appreciated that you even take so much time and effort to help us users when we get stuck in our ways
you are doing an amazing job. itās one of the reasons why i investigate this as a clickup alternative in the future
Yeah, a Map
or ForEach
function could work. I actually even wouldnāt mind if itās just done as a full-on Regex function, where I can manipulate the matchesā¦
But I understand the resource limitations.
Iām trying to do a very simple thing and Iām not able to get it right.
Iām trying to get the First Name of the Name property, however the formula doesnāt output what I want, which is the first name.
I tried the formula shared here, I tried the formula generated by AI, even review what would be the output of this formula on ChatGPT.
The formula below is not outputting āRenatoā and instead is outputting āRenato Luiz de Carvalhā
Left(
Trim("Renato Luiz de Carvalho"),
Find(" ", Trim("Renato Luiz de Carvalho")) - 1
)
What am I doing wrong?
Check out how the Find()
function works.
You are searching for āRenato Luiz de Carvalhoā within the string " "
On Make, doing that is very simple:
So far, I couldnāt find a simple way of doing that in Fibery.
first(split(full_name; space))
last(split(full_name; space))
Fibery doesnāt allow for arrays of strings. So we have to solve text related challenges differently.
Yes, I realized that
Could someone explain how to implement this example in Fibery? Iāve reviewed the documentation and examples but havenāt found a clear solution.
If this is meant to be straightforward in Fibery, Iād appreciate guidance on the recommended approach. What would be the best way to structure this in Fiberyās system?
How to implement what?
I need help with a formula that extracts the first and last words from a text field containing a personās full name. For example, if the field contains āRenato Luiz de Carvalhoā, I want the formula to return āRenato Carvalhoā. How can I write this formula in Fibery?
ReplaceRegex(Name, "(?<= )\w+ ","")
Thanks Chris.
And to get only the first word/name, I used this formula here, it worked:
ReplaceRegex(Name, " .*$", "")
So for āJohn Michael Smithā it will remove everything from the first space onwards, giving you just āJohnā.
p.s. I had to ask Claude to help me generating the formula. The AI inside Fibery that helps to generate formulas didnāt help me in this case. Although I was explicitly asking help to create a Regex.