Formula Text Field Formatting
Hello: Up that ol creek without a paddle again! I have two fields in a formula text field It is created by using [Building - Group Identifier]&"-"&[Record ID#]. Currently it looks like: 04...
Forum Discussion
The use of Mid will also work!
Using Mid, your formula would look something like:
[Building - Group Identifier] & "-" & Mid(ToText([Record ID#]),1,3) & "-" & Mid(ToText([Record ID#]),4,1) & "-000"
The Mid function uses two identifiers: the first number after the text you're extracting tells the function where to start, and the second number tell the function how many characters to grab.
Using Mid, your formula would look something like:
[Building - Group Identifier] & "-" & Mid(ToText([Record ID#]),1,3) & "-" & Mid(ToText([Record ID#]),4,1) & "-000"
The Mid function uses two identifiers: the first number after the text you're extracting tells the function where to start, and the second number tell the function how many characters to grab.