I have been going through every command I can find and trying to tweak it to extract 2 separate sets of data into new columns. I was able to get half but the other would not work.
I need to extract just the BLDG# "90210" in one column, not always 5 characters but the "BLDG: " and the following semi-colon are always there.
In teh second column I need just the RM# whcih can vary from 1 to 6 characters in length and also always includes the "RM: " and following semi-colon.
<colgroup><col></colgroup><tbody>
</tbody>
Alternatively if there is a way to just import that column into another spreadsheet and automatically delimit it I could easily make this work also.
Background info:
The spreadsheet this is in is being extracted fro Active Directory using a VBS script. This spreadsheet then gets imported into an Access database to track/manage assets, including location as entered every 60 days by moronic users that like to screw up our whole system.
Thanks
I need to extract just the BLDG# "90210" in one column, not always 5 characters but the "BLDG: " and the following semi-colon are always there.
In teh second column I need just the RM# whcih can vary from 1 to 6 characters in length and also always includes the "RM: " and following semi-colon.
[BLDG: 90210; RM: 108; ORGANIZATION: UNKNOWN; USER: $svc.FTEV.fsmpss; LAST UPDATE: 08/13/2014] |
<colgroup><col></colgroup><tbody>
</tbody>
Alternatively if there is a way to just import that column into another spreadsheet and automatically delimit it I could easily make this work also.
Background info:
The spreadsheet this is in is being extracted fro Active Directory using a VBS script. This spreadsheet then gets imported into an Access database to track/manage assets, including location as entered every 60 days by moronic users that like to screw up our whole system.
Thanks