Thursday, 28 January 2016

Excel sub string formula based on last space

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)))
=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)))

Excel find leading and trailing spaces



=if(len(A1)-len(trim(A1))>0,"yes","no")

Tuesday, 26 January 2016

Aras Innovator - Properties and Attributes


Properties are used to define the data for an Item;
Attributes are meta-data for the Item or Property, which are used to control the server logic and Methods.
Think of attributes like command line switches, or as arguments to a function.
In addition to the type, id, and action attributes mentioned below there are several
additional attributes used to control the server. The following is the attribute
reference for the <Item> tag:

Ex 1:

<Item action="add" type="Part">
    <item_number>1234</item_number>
    <description>welcome to new part</description>
  </Item>

Ex 2:
  <Item action="get" type="Part" id="1234">
  </Item>

Properties : item_number, description

Attributes: action,type, id

Friday, 22 January 2016

Tuesday, 19 January 2016

Add users under IIS_IUSRS



 Control panel -> user account -> change account type -> Advanced -> Groups ->IIS_IUSRS

or
This PC-->Right click--> Manage--> Local Users and Groups-->IIS_IUSRS


Add your name (Account name)