|
-
March 10th, 2012, 03:04 PM
#2
Re: Tough Parse Task
Left$(), Right$() and Mid$() are your friends. Might be slow, but once you figure out the coordinates to use for each field, set them up and parse each record.
Code:
a1 = Left$(v1,6)
a2 = Mid$(v2,4,12)
Opps. Wrong forum!
You'll want to convert to string, then use .SUBSTRING(4,14)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|