Strip unwanted characters

[Guest]

Hi,

I'm using Access 2003 and have a field that I want to split into 2 seperate
fields. This field has a Carriage Return imbedded in the middle of the text.
What I want to do is place the text up to the CR in one field and the text
after the CR in a second field.

I have already created a second field and pasted the contents of field 1
into field 2.

This is from imported data.

My question is, how do I strip off the unwanted data?

Thanks in advance!

 

[Ken Snell [MVP]]

Use an update query:

UPDATE TableName
SET Field2 = Mid([Field2], InStr([Field2], Chr(13)) + 1);