Recent posts to About codesyshttps://forge.codesys.com/forge/talk/Engineering/thread/3b3e2e7304/2020-06-24T08:58:28.288000ZRecent posts to About codesysAbout codesys2020-06-24T08:58:28.288000Z2020-06-24T08:58:28.288000Zhelgehttps://forge.codesys.com/u/helge/https://forge.codesys.com4fd231403d8f81ce2a880110a5ae62e63c4cba0e<div class="markdown_content"><p>You could also use concatenate functions to add together the variables for GVL<br/>
F10 cell:</p>
<p>=CONCATENATE(<br/>
IF(B10<>"",<br/>
CONCATENATE(B10,":",C10,<br/>
IF(D10<>"",":=",""),<br/>
IF(D10<>"",D10,""),";"),""),<br/>
IF(E10<>"","(<em>",""),<br/>
IF(E10<>"",E10,""),<br/>
IF(E10<>"","</em>)",""))</p></div>About codesys2020-06-24T05:11:25.967000Z2020-06-24T05:11:25.967000Zsaban57https://forge.codesys.com/u/saban57/https://forge.codesys.com384244d7a1ac36612374e91c23dc5a508cc8f4ba<div class="markdown_content"><p>Thank you for answer but daha profosyonel cevaplar arıyorum.</p></div>About codesys2020-06-22T22:46:15.811000Z2020-06-22T22:46:15.811000ZJAPIBhttps://forge.codesys.com/u/japib/https://forge.codesys.com025aa40928c689420cbd5b1c6ed1df456092cbe7<div class="markdown_content"><p>Hello,</p>
<p>1°) You can copy a selected area from excel and paste it into CODESYS only if your Global Variable List (or Local List) is in Textual view.</p>
<p>For example, if My excel part is :<br/>
A | B | C<br/>
---------- | ---------- | ------ <br/>
iVar1 | INT | Comment 1 <br/>
iVar2 | INT | Comment2</p>
<p>When I past into a GVL, I get this :<br/>
VAR_GLOBAL<br/>
iVar1 INT Comment 1<br/>
iVar2 INT Comment 2<br/>
END_VAR</p>
<p>But then you need to correct format, by adding special caracters ":;(",for example : <br/>
iVar1 : INT; (Comment 1)*</p>
<p>2°) I think there is no command to auto-align data types.<br/>
You can simply do this with Tabulation.<br/>
You can also see GVL in Tabular view. In this mode you can also sort variables by name, by type, ...<br/>
But when you look at GVL again in Textual view, you will see it when it was before (witjout sort, without align, ...)</p>
<p>BR</p></div>About codesys2020-06-22T08:31:17.915000Z2020-06-22T08:31:17.915000Zsaban57https://forge.codesys.com/u/saban57/https://forge.codesys.com1c85c80f975f9c2128d97c231ec0abab3fa514cf<div class="markdown_content"><p>First of all hello.<br/>
I have two questions for you.<br/>
1 question:<br/>
I want to standardize variable names in my projects. Can I extract the universal variables I have defined to an excel file?<br/>
I tried but I failed. I can do this process in "comforpoint" software of "honeywell" but I couldn't do it in plc designer.<br/>
My 2nd question:<br/>
Can I auto-align data types when defining variables?<br/>
I need to write a script for this process?</p></div>