<div>
<div class="content wysiwyg-content">
i have a column called DESCRIPTION that contains more information than just a description. &nbsp;I want to extract the data before the first space.<br />
<br />
example:<br />
<br />
Description<br />
ABC blah blah and more 123 blah<br />
BCDEF blah blah and more<br />
CDEFGH blah blah 1234<br />
<br />
The result should be:<br />
<br />
ExtractedDescription<br />
ABC<br />
BCDEF<br />
CDEFGH<br />
<br />
thanks!
</div>
</div>


i have a column called DESCRIPTION that contains more information than just a description.  I want to extract the data before the first space.

example:

Description
ABC blah blah and more 123 blah
BCDEF blah blah and more
CDEFGH blah blah 1234

The result should be:

ExtractedDescription
ABC
BCDEF
CDEFGH

thanks!

Extract data before first space

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.