Unable to convert data to text to column

Hey Ruchika,

Depends how you want to go about it to be honest, an easy way to do it (assuming your structure doesn't change) is do the following:

Put the headers of the information you require in cells B1:D1 (so B1 would contain SOURCE_IP, C1 would contain ALARM_TYPE and D1 would contain ALARM_EVENT_IDENTIFIER) and then put the below formula in cell B2 and drag it across to D2 and copy down.

Please Login or Register  to view this content.

This will extract the information from the start of your header to the following semi-colon. Just use a concatenate formula (or even more crudely)

Please Login or Register  to view this content.

in cell E2 and you have your result string.

Edit Just to caveat this though, it will only return the first 255 characters of a item, i'm not sure of the actual character limit in the MID function, so someone more learned might want to wade in and correct me, but I'm sure you can just up the 255 number at the end of the function if you require it

In B2 enter this formula and fill down to extract the SOURCE_IP=

Formula:

Please Login or Register  to view this content.

In C2 enter this formula and fill down to extract ALARM_EVENT_IDENTIFIER=....

Formula:

Please Login or Register  to view this content.