본문 바로가기
반응형

전체 글180

windows 10 user profile modify [windows] + r > netplwiz 2021. 5. 31.
ALL LIST of DYNAMO v2.0 Dynamo List Usage Examples (based on v2.0) This blog mostly contains small tips and unique ideas about Revit. Revit Family Download plevit1.blogspot.com 2021. 4. 16.
f(x) = MID(text, start_num, num_chars) f(x) = MID(text, start_num, num_chars) f(x) = FIND(find_text, within_text, [start_num]) Workset1 : Structural Foundations : Foundation Slab : RC_Mat Foundation, FC27_THK1200, F1 : id 208671 1) id 추출 =RIGHT(B2,6) >> 208671 : 오른쪽에서 6자 출력 2) 카테고리 추출 =FIND(":",MID(B2,12,LEN(B2)))-2 >> 22 : 12자 잘려진 문자열에서 ":" 찾은 위치 - 2 >> "Str...ons" 문자길이 22자 =MID(B2,12,FIND(":",MID(B2,12,LEN(B2)))-2) >> Structural Fo.. 2021. 4. 8.
f(x) = TEXTJOIN() add-in for Excel 2013 f(x) = TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) 첫번째 MS 보다 두번째 오빠두 모듈이 범위를 지정할 수 있어 효과적임. 1. Open a blank workbook 2. Press ALT+F11 to open the VBA editor 3. In the Project window on the left, right-click on the workbook name and choose Insert ->Module 4. Paste this code in the resultant window 5. Enter the code: from the Microsoft version below or the code from the Oppadu version bel.. 2021. 4. 6.
Update sheet; xr, -la s 0, pu, pdf, saveas 2000, Close (defun c:zz( ) (command "-insert" "gc-sheet=C:\\Users\\...\\Documents\\gc-sheet_stamp" "y") (command \e "resume") (command "-insert" "gc-xr-plan=C:\\Users\\...\\Documents\\gc-xr" "y") (command \e "resume") (command "-insert" "gc-xr-sec=C:\\Users\\...\\Documents\\gc-xr" "y") (command \e "resume") (command "-insert" "gc-xr-elev=C:\\Users\\...\\Documents\\gc-xr" "y") (command \e "resume") (command .. 2021. 4. 6.
PDF 자동출력 (defun findplotarea (blocks / en lst ipt ipt&en data xsort xysort) (while (setq en (ssname blocks 0)) (setq lst (entget en)) (setq ipt (cdr (assoc 10 lst))) (setq ipt&en (cons ipt en)) (setq data (cons ipt&en data)) (ssdel en blocks) ) (setq xsort (vl-sort data (function (lambda (a b) ( (cadar a) (cadar b)))))) ) (defun c:sd(/ ss plotlist filename pdfnameprefix pdfpath pdfname vlename min max ll.. 2021. 4. 6.
반응형

티스토리툴바