Filter objects from excel

Belias
Member Posts: 2,998
how many times did you have an excel file with a list of object numbers and you wanted to filter them in object designer?the painful procedure to do is manually mark the objects reading them from excel...
well, with this stupid form you can copy the excel column with the values, paste it in the textbox and click the button...
the odd "crlf" characters will become beautiful "|"...then you can copy the textbox and use it as a filter in obj designer, after that, you select all and mark...what a pleasure...enjoy!
well, with this stupid form you can copy the excel column with the values, paste it in the textbox and click the button...
the odd "crlf" characters will become beautiful "|"...then you can copy the textbox and use it as a filter in obj designer, after that, you select all and mark...what a pleasure...enjoy!
OBJECT Form 99999 Filter Maker { OBJECT-PROPERTIES { Date=11/02/09; Time=12.16.31; Modified=Yes; Version List=; } PROPERTIES { Width=8140; Height=1650; } CONTROLS { { 1101327000;TextBox;220 ;220 ;5720 ;440 ;SourceExpr=TXTNumbers } { 1101327002;CommandButton;220;770;2200;550 ;CaptionML=ITA=Mark; OnPush=BEGIN CR := 13; LF := 10; TXTNumbers := CONVERTSTR(TXTNumbers,FORMAT(LF),'|'); TXTNumbers := DELCHR(TXTNumbers,'=',FORMAT(CR)); TXTNumbers := DELCHR(TXTNumbers,'>','|'); END; } } CODE { VAR TXTNumbers@1101327000 : Text[1024]; CR@1101327001 : Char; LF@1101327002 : Char; TBObj@1101327004 : Record 2000000001; BEGIN END. } }
0
Comments
-
The way I do it simple and doesn't involve having any objects.
You have the list in excel. In a column.
21
32
50000
In Excel. I copy the column. Right click in an empty cell and select Paste Special. I check Transpose and click OK.
Then I copy the Row and paste in Notepad. In Notepad I open the replace window and paste the TAB with |
that's it
To copy the TAB, you just highlight the empty space in notepad.0 -
you're welcome.0
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