E kaha i ka iieeaii me kaʻaoʻao a me ka mamao mai kela aku i ka Microstation

I kekahi mau makahiki i hala iho nei, ua paʻi aku au i kahiʻatikala e hōʻike ana i keʻano o ka concatenateʻikepili i Excel no e kūkulu i kahi alahele me AutoCAD, me kaʻole e hana i ke kuʻina a pau:

@kawaiokee

I kekahi lā ʻē aʻe aia mākou i ka papa AutoCAD ua nīnau mai kekahi iaʻu inā hiki ke hana ʻia me ka laina kauoha Mikamina. ʻAe ka pane, e hoʻomaopopo wale ʻoe ʻaʻole like ka Microstation's Keyin me ka laina kauoha AutoCAD. E nānā pehea e kūkulu ai, i ka hala ʻana e aʻo ai mākou i nā mea liʻiliʻi i hoʻohana iki ʻia i kēia polokalamu.

ʻO ka pahu ma ka ʻākau he laʻana ia o kahi alahele e pili ana i nā bearings a me nā mamao me kēia ʻano hana.

Me ka mea hiki ke huki i kēia e like me kaʻu i wehewehe mua ai, me ka hemahema kūpono - aʻo ia hoʻokahi o ka AutoCAD -, he mea paʻakikī ke kākauʻana i kekahi me kekahi, hiki ke hana hewa aʻaʻole hoʻi i hoʻonohonohoʻia ka papa mua.

ʻOi,ʻo ka hana o ka concatening he hoʻokahi like e wehewehe wau me AutoCAD, ponoʻoe e hoʻomaopopo i kekahi mea eʻano likeʻole ai ka Microstation.

ʻAʻole kūkulu ʻia ke kī keyin ma ka hana ʻana i nā kauoha ma nā laina kikokiko akā no ke kāhea ʻana i nā kauoha me ke kuhikuhi ʻana o kahi mea, no laila kākoʻo wale ia i nā huapalapala he 56. Hoʻohui hou, koi ʻia i kahi semicolon (;) e hoʻohana e hoʻokaʻawale i nā kauoha no ka mea, ʻaʻole like me AutoCAD, i hele mai kahi loiloi papahana Basic, lawe mai kēia i kahi loiloi Clipper me ka mea a Microstation i hana ai ma laila ua kapaʻiaʻo Ustation.

Hāʻawi ʻia i kēia, ʻo ke ala maʻalahi loa ke kāhea ʻana i nā kauoha mai kahi faila kikokikona me ke kauoha @, aʻu e manaʻo nei he kakaikahi wale nō ka ʻike akā ʻo ia ke kaʻina hana a Microstation i hoʻohana mau ai e hoʻoponopono i nā kauoha batch. Me ka lawe mai i nā helu mai kahi papa inoa txt He mdl kēia e hana nei i kēia.

Ma ka hoʻohanaʻana i ka pepa Excel aʻu i hana mua ai e aʻo i keʻano o ka huliʻana mai nā halihali a me nā mamao a me nā hoʻonohonohoʻana, e hōʻike ana au pehea e hanaʻia ai no ka Microstation:

E hoʻokumu i nā helu.

ʻO ka mea maikaʻi iā mākou i ka hopenaʻo ka Kaomi ma hope loa:

wahi wahi ;xy =374037.736,1580735.145;

ʻO ke kiko wahi ke kiko kauoha, e like me ka hakahaka, ʻo ka semicolon ka mea e kuhikuhi ai i kahi ʻoka ʻē aʻe, ʻo ka xy = ke kauoha e komo i nā kuhi a ʻo nā koina ʻelua uliuli a me nā ʻōmaʻomaʻo nā kiko ʻike Ma ka hopena kahi semicolon hou e kuhikuhi a komo aiʻole i ka neʻeʻana i kahi kauoha hou.

No laila, i ka manaʻoʻana o nā pūnaewele o koʻu hului i U7 a me V7 e hoʻokomo i kēia mea:

= CONCATENATE(“wahi wahi ;”,”xy =",U7,",",V7",";")

Ma kēiaʻano, hoʻopili wale wau i nā mea o ka papa AA i loko o kahi pūnaewele txt, kahi aʻu e hea ai spikedpoints2.txt. Paipai wau e kau pololei iā ia i C no laila paʻakikī ʻole ke ala.

Ma kēia hihia, ke kau nei wau i loko o kaʻu mau palapala,ʻo ke ala e hiki iā: C: \ hoʻohana hoʻohana nā mea hoʻohana a hoʻohana'iaENDNNXX.txt.

no ka holoʻana, hoʻohana mākou i ka puka laina kauoha (kī i loko), ua hanaʻia kēia mai Nā pono hana> kī i loko a laila e hoʻokomo i ka papa kauoha:

@C: \ hoʻohana hoʻohana nā mea hoʻohana o DottedPoints2.txt

Hoʻokomo mākou, a ma laila ʻoe, nā kiko i huki ʻia i kā lākou papa. He maʻalahi ia i ka mānoanoa o ka laina mānoanoa no lākou e hōʻike ʻia.

E hoʻokumu i nā laina.

No kēia, ua like ka hana,ʻo ke kauoha e pono ai mākou ke hana kahi laina, ke hōʻoia nei mākou i ka helu o ka laina a me kahi kikohoʻe.

kahi laina ;xy =374032.234,1580716.255;xy =374037.736,1580735.145;

= CONCATENATE(“kahi laina ;”,”xy =",U6,"",",V6,";","xy =“,U7,””,”,V7,”;”)

Kope mākou a kāpili i ka faila txt, mālama a holo hou

@C: \ hoʻohana hoʻohana nā mea hoʻohana o DottedPoints2.txt

A malaila oe i mea:

A he pānaʻi hou aʻe no ka kūkuluʻana i ka pahu o nā bearings a me nā mamao wale nō e pono ai ke hana ke kope i Excel, a pākuʻi i ka Microstation. Me kahi pākuʻi kūikawā hiki iā ʻoe ke koho ma waena o ke kiʻi, kahi pākuʻi i hoʻopili ʻia a hoʻopili ʻia paha

E hoʻopau i kēiaʻatikala, Ke hoʻonoho nei wau i ka faila hiʻohiʻona i Excel, aʻo kahi wale nō ke kumu o ka hānau, nā kuhikuhi, a me nā mamao e hoʻololi ai a hiki ke hoʻohana i ke kumukūʻai no kēlā me kēia iguana me ka hapalua o nā pākeke.  Eia pū kekahi ma kahi o ka txt.

Koi ʻia kahi hāʻawi manawaleʻa no ka hoʻoiho, a hiki iā ʻoe ke hana me ia Kāleka Kāpena a Paypal paha.