Hi
I have to extract certain lines from exported text files ( as attached ) which contain new parts.
Any line starting with 070 is a new part.
The text file contains fixed length fields which are padded where no data exists so I think it's possible to measure each field to extract.
The data I require from the extracted lines are:
Once extracted populate an unbound lest box.
[Part No]
[Part Description]
[Part Price Amount]
The PNG shows field lengths in brackets.
Where do I start ?
Extract New Parts
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Extract New Parts
You do not have the required permissions to view the files attached to this post.
Cheers ...
Dave.
Dave.
-
- 4StarLounger
- Posts: 482
- Joined: 24 Jan 2010, 15:02
- Location: Colorado, USA
Re: Extract New Parts
I would start by creating an import specification for text that matches the columns that you have determined. That will get the data into a table where you can manipulate the data in whatever fashion you need to.
Wendell
You can't see the view if you don't climb the mountain!
You can't see the view if you don't climb the mountain!