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.
[TABLE="width: 567"]
<colgroup><col></colgroup><tbody>[TR]
[TD][BLDG: 90210; RM: 108; ORGANIZATION: UNKNOWN; USER: $svc.FTEV.fsmpss; LAST UPDATE: 08/13/2014]
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 567"]
<colgroup><col></colgroup><tbody>[TR]
[TD][BLDG: 90210; RM: 108; ORGANIZATION: UNKNOWN; USER: $svc.FTEV.fsmpss; LAST UPDATE: 08/13/2014]
[/TD]
[/TR]
</tbody>[/TABLE]
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