text placed at X Y from an Ascii file

Status
Not open for further replies.

Magic

Usenet Archive
Joined
Aug 30, 2001
Messages
3
Reaction score
0
Has anyone had experience placing text from a column at coordinates X,Y in adjacent columns Text,X,Y I have a spreadsheet that I want X,Y coordinates labeled with the text in a third column Regards
 
MicroStation supports script files, which are simply ASCII files with one valid keyin on eack line. You can send datapoints to MicroStation using the keyin XY=x-coordinate,y-coordinate,optional-z-coordinate and I often create a formula column in a spreadsheet to combine adjacent columns into valid keyins. For example, if you had three columns AB & C with x, y and "some text string" in row1 and wanted to place the "some text string" at coordinate x,y in Excel, you could enter the following formula:
="set parseall on;/ptext;"&C1&";xy="&TRIM(A1)&","&TRIM(B1)&";null"

If you have a whole column of data, simply copy the formula down to the end of the data.

Then selact the column of the formula and copy and paste it into notepad and save the file.

Then in MicroStation, set your text attributes and keyin:
@full_path_to_script_file

substituting the actual full path filename.

"Magic" wrote:
Has anyone had experience placing text from a column at coordinates X,Y in adjacent columns Text,X,Y I have a spreadsheet that I want X,Y coordinates labeled with the text in a third column Regards
 
Status
Not open for further replies.

Latest threads

Back
Top