Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Dataport to ignore empty lines
detlef
Member Posts: 38
Hi
I have a client who wants me to change a dataport so it ignores empty lines.
I tried setting the DataItemSeparator to '<None>' but then it just goes into an endless loop.
If I set the the DataItemSeparator to something that will never occur (i.e. '1hdf345') the dataport will actually read past the empty line but instead of skipping it repeats the import of the previous line.
The third option was to write a function that copies the file leaving out the empty lines and then importing the copied file. This works fine until you have a line longer than 250 chars.
Anybody have any ideas?
Cheers
Detlef
I have a client who wants me to change a dataport so it ignores empty lines.
I tried setting the DataItemSeparator to '<None>' but then it just goes into an endless loop.
If I set the the DataItemSeparator to something that will never occur (i.e. '1hdf345') the dataport will actually read past the empty line but instead of skipping it repeats the import of the previous line.
The third option was to write a function that copies the file leaving out the empty lines and then importing the copied file. This works fine until you have a line longer than 250 chars.
Anybody have any ideas?
Cheers
Detlef
0
Comments
here is a post that is similar to what you need.
http://www.mibuso.com/forum/viewtopic.php?t=5605
hope this helps!!!
Kikkoman
Thanx for that. I have seen that topic before and it did not solve the problem.
However we have solved the problem here.
There was a trigger problem on the table.
Cheers
Detlef