May 22, 2022 08:35 AM
Hello, how can I extract the 6" and the 8" from these strings?
May 23, 2022 06:29 AM
Thanks, I think i’m doing something wrong with it though as its giving me an error message.
May 23, 2022 06:36 AM
I meant for you to do the formula from the other table, but if you’re doing it from this table, then you need to add &""
after each reference to the field.
Add it IMMEDIATELY AFTER the closing curly bracket for BOTH of your field references.
May 23, 2022 06:45 AM
Amazing, that did it, many thanks!
May 23, 2022 06:46 AM
An once again, there are many different ways of doing things. We were all looking a extracting the number from different strings …
Also, this new screen shot shows more information and an inconsistent data format for the 12
option–it doesn’t have the inches specifier, probably doesn’t have a space, and doesn’t list number of portions. If there is no space, it will mess up the formula that looks for a space.
I still prefer a schema change to get the size in a field by itself, with a formula field to state the portions.
May 23, 2022 06:54 AM
Yeah, people usually use lookups instead of rollups. But that doesn’t mean that lookups are better than rollups. With a rollup, I always know what data type I’m getting at the end (number, string, or array). With a lookup it is hard to be sure. This screen shot is one example why I dislike lookups.