That looks like it will fit the bill! Thx
Dan Goldberg From: [email protected] <[email protected]> On Behalf Of Bruce Chitiea Sent: Tuesday, June 22, 2021 8:48 AM To: [email protected] Subject: Re: [RBASE-L] - Extract first word (SSUBCD(data,1,' ')) Capture substring #1 from data using delimiter <space> Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA [email protected]<mailto:[email protected]> | +011 (909) 238-9012 c | +011 (909) 912-8678 f ------ Original Message ------ From: "Dan Goldberg" <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Sent: 6/22/2021 8:43:27 AM Subject: [RBASE-L] - Extract first word I have a need in a report to only display the first word of a field. I am drawing a blank. Field value John Doe is the best Display only John TIA Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E920F24%40EXCHANGE10<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E920F24%40EXCHANGE10?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em24b1088c-7bf2-4dba-a87a-8e1b0f89aba2%40pathfinder<https://groups.google.com/d/msgid/rbase-l/em24b1088c-7bf2-4dba-a87a-8e1b0f89aba2%40pathfinder?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E920FDA%40EXCHANGE10.
