Splitting a field name

[Anonymous]

Hi all,

I am having an issue with loading a field name as two separate fields.

Basically, the field name 'Version' is made up of two strings separated by a space. The length and format of both strings can differ and in terms of length and character composition (mix of numbers and letters).

I have tried to use the Trim and Left/Right functions to split Version into two different fields Version_Type and Version_Number taking the two strings, but because the number of characters differ in each item I can't apply a consistent rule.

The fields appears like this:

Version
DWSZPL X425
LTRB 31JK89
WSRTBBX 90D2Y
JTM PW8

I need to cut them at the space and load them as follows:

Version Type	Version Number
DWSZPL	X425
LTRB	31JK89
WSRTBBX	90D2Y
JTM	PW8

Any suggestions on the best way to do this?

Thanks in advance.

[Peter_Cammaert]

You don't like the mid() and left() functions? They do work though...

[Anonymous]

Sorry, I don't think it works as requested.

This (for Version Type)

subfield('AAA BBB CCC', ' ', SubStringCount('AAA BBB CCC', ' '))

returns 'BBB' instead of expected 'AAA BBB'

[#4]

subfield(Version, ' ', SubStringCount(Version, ' ')) as [Version Type]

subfield(Version, ' ', SubStringCount(Version, ' ')+1)  as [Version Number]