jonnyp138
Board Regular
- Joined
- May 2, 2015
- Messages
- 50
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
Hi there, I have a data dump in a table format, in one of the columns each cell contains numerous strings, the string can be of varying lengths and can contain different words each time, however there is one constant in every cell which is the event ID and is in the form of something like Id:IIWS_IMServer.ntuzof.2715373
I need a formula to extract that event ID.
An example of one of the full cell contents are as follows:
FAILED TO CREATE INCOMING ASSET INCIDENT:
Asset has not been associated to any Person (No Requester Details)
Description (Full): LOWD12SHP10APP01V - Windows 2003 monitoring is CRITICAL: Please investigate
Id:IIWS_IMServer.nu06v4.2719657
Client address:146.12.34.12
Any ideas how best to achieve this?
I need a formula to extract that event ID.
An example of one of the full cell contents are as follows:
FAILED TO CREATE INCOMING ASSET INCIDENT:
Asset has not been associated to any Person (No Requester Details)
Description (Full): LOWD12SHP10APP01V - Windows 2003 monitoring is CRITICAL: Please investigate
Id:IIWS_IMServer.nu06v4.2719657
Client address:146.12.34.12
Any ideas how best to achieve this?