topic Separating a string value in Discussions

Separating a string value

dn610 — Mon, 29 Jan 2024 17:04:30 GMT

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?

Re: Separating a string value

txnelson — Mon, 29 Jan 2024 17:31:47 GMT

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.

Re: Separating a string value

jthi — Mon, 29 Jan 2024 17:39:13 GMT

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

dn610 — Mon, 29 Jan 2024 18:22:22 GMT

Thank you!