(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] | +011 (909) 238-9012 c | +011 (909) 912-8678 f


------ Original Message ------
From: "Dan Goldberg" <[email protected]>
To: "[email protected]" <[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]. 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].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/em24b1088c-7bf2-4dba-a87a-8e1b0f89aba2%40pathfinder.

Reply via email to