iceshark17
New Member
- Joined
- Jun 24, 2014
- Messages
- 7
I have a specific code structure that I would like to be automatically generated based off of text from other columns in the same row.
The code Structure is: XX.XXXX.XXXX (PROCESS AREA . COMPONENT/DISCIPLINE . ITEM)
The first two digits are meant to represent an "Area" (##.XXXX.XXXX)
The next four digits are meant to represent a "Component" (XX.##XX.XXXX) as well as a "Discipline" if applicable (XX.XX##.XXX), if not applicable the ##s will just be zeros.
The last four digits will represent an item number, 0001-9999 that will simply follow the order in which the row was entered.
Example of text:
so, for example, I'd like to fill out a row such as the one below with all the text information and have the code automatically generate.
Any guidance would be much appreciated. Thank you!
The code Structure is: XX.XXXX.XXXX (PROCESS AREA . COMPONENT/DISCIPLINE . ITEM)
The first two digits are meant to represent an "Area" (##.XXXX.XXXX)
The next four digits are meant to represent a "Component" (XX.##XX.XXXX) as well as a "Discipline" if applicable (XX.XX##.XXX), if not applicable the ##s will just be zeros.
The last four digits will represent an item number, 0001-9999 that will simply follow the order in which the row was entered.
Example of text:
![R9PpmYh.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FR9PpmYh.jpg&hash=3eaccc6e3c97a3cf9497b4d5e165cfee)
![4StGCQB.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2F4StGCQB.jpg&hash=1c39cf1f78abb686e56c649ba57750ec)
![BTIB7Nf.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FBTIB7Nf.jpg&hash=4275a0a42e4b1becf5646a16bc8e1ff4)
so, for example, I'd like to fill out a row such as the one below with all the text information and have the code automatically generate.
![Zli1IDt.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FZli1IDt.jpg&hash=55f1038eac3b27c08ef585327457edad)
Any guidance would be much appreciated. Thank you!