Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Italian exchange rates
Lec11
Member Posts: 91
Hello,
I want to extract automatically the daily exchange rates from the site of Banca D'Italia. I've downloaded the csv file (I believe that italians know about his file) with the daily exchange rates and now I want to manage this file in order to import the rates into Navision. My issue is with the separator between the records. If I open the file with Excel I can see each currency on a separate line, but if I open it as a text file it looks like there is no record separator.
Can some italian guy guide me in the right direction?
Thank you!
I want to extract automatically the daily exchange rates from the site of Banca D'Italia. I've downloaded the csv file (I believe that italians know about his file) with the daily exchange rates and now I want to manage this file in order to import the rates into Navision. My issue is with the separator between the records. If I open the file with Excel I can see each currency on a separate line, but if I open it as a text file it looks like there is no record separator.
Can some italian guy guide me in the right direction?
Thank you!
0
Answers
If you "don't see" any field separators then the file is probably TAB separated. In many (or almost all) cases there really is no record separator because each record is in a new line.
Yes, I also thought about TAB separated file. And it is TAB because now I saved the file as "Text (tab delimited)" and I can see it properly in notepad.
But my issue is the following: I entered <TAB> as a record separator before and it didn't work. And still doesn't work ... neither with TAB or NewLine.
Anyway, meanwhile I gave up using a dataport to import the csv. I used a bigtext variable to store the file and I searched only for the currencies I'm interested in.