Delimited Text Files to dgn text coming into dgn out of line

Question

.LS=.4

.TH=:1.80

.TW=:1.50

.LL=250

.FT=4

BTNMDIX-V630-CA11-BA006 
 0092-006 
 F0002 
 PHOSGENE GENERATOR #3

BTNMDIX-V630-CA11-BA007 
 0092-007 
 F0002 
 GENERATOR COOLING LOOP SEPARATOR #1

BTNMDIX-V630-CA11-BA008 
 0092-008 
 F0002 
 GENERATOR COOLING LOOP SEPARATOR #2

BTNMDIX-V630-CA11-BA009 
 0092-009 
 F0002 
 GENERATOR COOLING LOOP SEPARATOR #3

BTNMDIX-V630-CA11-WA010 
 0092-010 
 F0002 
 GENERATOR COOLING LOOP CONDENSER #1

BTNMDIX-V630-CA11-WA011 
 0092-011 
 F0002 
 GENERATOR COOLING LOOP CONDENSER #2

BTNMDIX-V630-CA11-WA012 
 0092-012 
 F0002 
 GENERATOR COOLING LOOP CONDENSER #3

BTNMDIX-V630-CA11-AM013 
 0092-013 
 F0002 
 GENERATOR COOLING LOOP EDUCTOR

BTNMDIX-V630-CA11-WA016 
 0092-016R 
 F0003 
 FRESH PHOSGENE CONDENSER

BTNMDIX-V630-CA11-RM017 
 0092-017 
 F0003 
 POST CO/CL2 MIXER

BTNMDIX-V630-CA11-CA018 
 0092-018 
 F0003 
 POST PHOSGENE GENERATOR

for some reason the text is not coming into the dgn space delimited as shown...text comes in out of line...what to do?

George A. Martin · Accepted Answer

Hi Monique! 
 Copy the text (Ctrl C) and Paste (Ctrl V) the Text into the MicroStation "Text Editor - Word Processor" dialog. 
 Assuming you have the correct Text Settings Font, Size, Spacing, etc. settings you can now Set/Adjust the Tab spacing (See attached image.) 
 
 I hope I have the right Idea as to what you are having trouble with.

Lorys · Answer

Monique, 
 Does it have to be Microstation Text? 
 If while in Excel you select all your cells you can control C copy , then in microstation you can paste special and choose excel ( I prefer embedded as it becomes part of the cad file) there are several choices but dont use the image choices... 
 you can then place by dynamic points or size etc .. if you make the excel file xls instead of csv you can use some cool formatting headings, bold, borders around each cell etc and these then are preserved in cad... only issue is if you are forced to use a font.. 
 If you must use a msnt font then there is a little known macro delivered with microstation that will draw a table with lines and use active font etc.. it takes a few practice go's if you never used it before but its pretty great and leaves you original text file intact it just imports it ... search your system for table.bas or try running it from command line with keyin 
 macro table 
 After you run it it asks for your txt file ( you can aslo select csv from pull down) 
 then data point and your table starts drawing and populating via the settings used.. pretty cool really... 
 you'll also find a text file called table in the same folder as an example of the formating FYI it doesnt like over rides on so turn that off from Control B.. otherwise it works fine.. you may have to tweak the results with fence stretch and clip or scale etc but I've been using that on and off since 2002 when I'm not allowed to use windows fonts or excel copy paste... 
 here is screen shot ...I used the engineering msnt font if you cant find the macro or dont have it email me or Private message me and I'll send it to you... 
 
 it has preferences that you need to set ie colours lines on off column widths in master units not characters 
 The first line is the headings, number of columns depend on how you have the column delims set in your text file .. this macro I find works better than plain import text from a file.... 
 Also if you dont want the line work you can just delete it or turn off the options for separators in the settings and have only the text , but I prefer to group the text as a selection so it moves together as one object for ease of location in best spot... 
 Give it a try you'll love it!