719446_en-US

liliconcom

Separating a string value

abc.01.d06 Failure to protect
abc-cd.06.d07 Inadequate dependency of stories
ab.01.d05 Unavailability of personnel

 

Hi - I need to separate the above values into separate columns. One column will contain the numerical values and the other will contain the text so for example for the first row, I want abc.01.d06 in the first column and Failure to protect in the second column. Can someone please help? 

Automation and ScriptingRe: Separating a string value

Thank you!

Re: Separating a string value

This can be done in many different ways. Below are fairly interactive methods

 

Starting table

 

Quick formula:

Right click on your column and take first word

 

 

Using recode:

Select your column and go to Cols/Recode, find extract segment (could also use First word)

Use slider to pick correct parts and check from bottom that you are getting correct result

and you will end up with column like

 

Getting the text:

You can then repeat the recode process to create other column or create a column which substitute the newly created values from original column with missing string (might want to add extra space there or wrap it with Trim Whitespace() function)

Substitute(:Column 1, :Column 1 2, "")

 

 

Re: Separating a string value

Select the column in question

Then go to

     Cols=>Utilities=>Text to Columns

 

It will create new columns based upon the selected delimiter.  In your case, us a space to get what you want.