Dataport: Uneven record column numbers
How do I dataport data records with uneven column numbers?
should I use COPYSTR()?
and how about filtering lines starting with "001" and "008"?
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.
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.
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions