Options

Dataport: Uneven record column numbers

It4Ch1It4Ch1 Member Posts: 36
How do I dataport data records with uneven column numbers?
should I use COPYSTR()?

and how about filtering lines starting with "001" and "008"?
001 027001112564 20100504 10152724 4966230232904802 01 20100504 000012                                      4300 1 001772
001 027001112564 20100504 10152724 4506180037464337 01 20100504 000013                                    199000 1 007598
002 027001112564 20100504 00000000203300 000000000002 00000000000000 000000000000 00000000000000 000000000000
003 027001112564 20100504 00000000000000 01450 000000000000 00000000000000
004 027001112564 20100504 00000000203300 01380 000000002806 00000000200494
005 027001112564 20100504 00000000000000 01450 000000000000 00000000000000
006 027001112564 20100504 00000000000000 01450 000000000000 00000000000000
007 027001112564 20100504 00000000000000 02500 000000000000 00000000000000
008 027001112564 20100504 00000000203300       000000002806 00000000200494
001 027001112663 20100504 10152718 5239450030332653 03 20100504 000504                                     11800 1 R40242
001 027001112663 20100504 10152718 4283320019305210 02 20100504 000505                                     40800 1 007670
002 027001112663 20100504 00000000052600 000000000002 00000000000000 000000000000 00000000000000 000000000000
003 027001112663 20100504 00000000000000 01450 000000000000 00000000000000
004 027001112663 20100504 00000000000000 01380 000000000000 00000000000000
005 027001112663 20100504 00000000000000 01450 000000000000 00000000000000
006 027001112663 20100504 00000000011800 01450 000000000163 00000000011637
007 027001112663 20100504 00000000000000 02500 000000000000 00000000000000
008 027001112663 20100504 00000000052600       000000000726 00000000051874

Previous topic regarding using <space> as Field Separator: http://www.mibuso.com/forum/viewtopic.php?f=23&t=41781

EDIT: I sort of go around this by treating each line as one column and used COPYSTR as much as possible to gather what I need.

As for filtering, I used OnAfterImportRecord and SKIP.

So, sorta solved for now.
Sign In or Register to comment.