Skip to main content
Question

AttributeSplitter with no delimiter

  • August 8, 2014
  • 2 replies
  • 49 views

Forum|alt.badge.img
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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

takashi
Celebrity
  • August 8, 2014
Hi,

 

 

You can use the StringSearcher.

 

Regular expression examle:

 

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

 

 

Takashi

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • August 12, 2014
AttributeSplitter with no delimiter results in a string being turned in a list, by character.

 

Can be handy for some further processig.