EViews.com

Hi

I have an alpha series (6 million or so) that I've been trying to split from one series into two where the size of the string varies making @trim difficult


For example, I'm attempting to split the string into two - generate two additional series - one containing all characters up to the space preceding "["

the second containing the string with the []

the number of characters in the strings vary across the dataset

here's a example of a typical string:

Accounting, tax preparation, bookkeeping and payroll services [BS541200]

thanks

Hello,

As a starting point, here's an example of creating new alpha series (left and right) by splitting an existing alpha series (orig) on a specific character ("[").

big help - thanks