Recent content by jmarvino

Ah, thanks Plog and special thanks to Isladogs and Mark!

Only thing is, I don't think i can use the split function in a query. I may be wrong...

The destination fields are more restrictive... 30 characters only. Both of these two fields have to be populated, so distributing an even amount of wording would be boss. Juuuuust in case we get a company name that is 60 characters long. Anything above 60 characters will just have to be...

Nope. This sadly is real life.

Here's another interesting puzzle: Say if I had TWO strings: 1) The Institute for Insane Resource Management 2) Bobs Company I need to split these into two fields, with 30 character limits, as evenly as possible. Without braking a word. How can I get that to work??

Holy moly... it worked! See...??? Something that simple. Wow. THANKS isladogs

Hi guys! I'm new here. But I have a really mind numbing question that may be really easy to you all. I have a string of "Names" that I need to extract the first word from (which was easy), but I also need to extract the last few words AFTER that point. For example: Red Box Underwear I...