BREAKING APART A BIG FIELD

[Raptor136]

Hi All,
How do you break apart a big field. I have a text field that is 133 characters wide. What I'd like to do is run a query or code to take the contents of 1-10 and put them into another field in a different table. Then repeat with 11-25, etc. All help appreciated. Thanks.

Rap

 

[Zeroanarchy]

yea you could run an update query an in the field enter the following values.

'This will grab the first 10 characters
Expr1: Left([fieldname],10)



'This wil grab caracters 11-25
Expr2:Mid(fieldname, 11, 25)

'This wil grab caracters 26-35
Expr3:Mid(fieldname, 26, 35)

'Repeat until toward the end

If you want to get the last lot of values this works similat to Left except it takes the last 10 characers
Expr3:Right(fieldname, 10)


Should do the job. Let me know if you need any more info

ZeroAnarchy Experience is a wonderful thing. It enables you to recognize a mistake
when you make it again.

 

[Raptor136]

Thanks My Man. I'll give it a shot. -- Rap