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
-
detlef,
here is a post that is similar to what you need.
http://www.mibuso.com/forum/viewtopic.php?t=5605
hope this helps!!!0 -
kikkoman wrote:detlef,
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
Detlef0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions