Skip to main content
I'm looking at splitting (text from the numbers) a column (source file is an .xls) into two seperate columns that have a format such as

 

1234A

 

12B

 

123456T

 

. . . 

 

 

Their is no actual delimiter and the values varry in length, so I was wondering what the Format String parameters would look like in order to achieve this?
Hi,

 

 

You can use the StringSearcher.

 

Regular expression examle:

 

^(p0-9]+)(]^0-9]+)$

 

 

Takashi
AttributeSplitter with no delimiter results in a string being turned in a list, by character.

 

Can be handy for some further processig.

 

 


Reply