eliminating characters

S

susie

I have a field that is imported from another source that
has student information. The field contains the school
the student is attending, in the following format.

"Student from University of Michigan"

I would like to create a field that just contains their
school affiliation. Since the field is consistent with
the "Student from", is there a way I can truncate those
characters so I can have a field that simply states their
school? ex. "University of Michigan"? Thank you in
advance for your help.
 
R

Roger Carlson

Try the Replace function. You can find the syntax in the Help system. Just
replace the string "Student From " with "" (the empty string).
 
S

Susie

Thank you for your reply. I have a somewhat unusual
situation with this one. We have a source that we must
repeatedly download from, and because of this, data must
be manipulated with each download. Since I am not always
involved with each download, the user would have to
perform this process, and that's probably not a good
option. Is there a way to create a permanent field in a
query that would reflect the newly imported data? There
is a way to extract a set number of characters from the
beginning or end of a field, but is there a way to get the
opposite from that data set? For example, if I enter

Student: Left([regtypedescription],12)

The results are "Student from", so is there a way to ask
for just the opposite of this result? I hope this all
makes sense. Thank you for your time on this one.

Susie
 
D

Douglas J. Steele

Easier would be

Student: Mid([regtypedescription], 13)


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Phil said:
Hello,
You got it :
Student: Right([regtypedescription], Len([regtypedescription])-13)
Bye,

Susie said:
Thank you for your reply. I have a somewhat unusual
situation with this one. We have a source that we must
repeatedly download from, and because of this, data must
be manipulated with each download. Since I am not always
involved with each download, the user would have to
perform this process, and that's probably not a good
option. Is there a way to create a permanent field in a
query that would reflect the newly imported data? There
is a way to extract a set number of characters from the
beginning or end of a field, but is there a way to get the
opposite from that data set? For example, if I enter

Student: Left([regtypedescription],12)

The results are "Student from", so is there a way to ask
for just the opposite of this result? I hope this all
makes sense. Thank you for your time on this one.

Susie
-----Original Message-----
Try the Replace function. You can find the syntax in the Help system. Just
replace the string "Student From " with "" (the empty string).

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I have a field that is imported from another source that
has student information. The field contains the school
the student is attending, in the following format.

"Student from University of Michigan"

I would like to create a field that just contains their
school affiliation. Since the field is consistent with
the "Student from", is there a way I can truncate those
characters so I can have a field that simply states their
school? ex. "University of Michigan"? Thank you in
advance for your help.


.
Click to expand...
Click to expand...
Click to expand...
 
Top