Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You don't like the mid() and left() functions? They do work though...
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'
subfield(Version, ' ', SubStringCount(Version, ' ')) as [Version Type]
subfield(Version, ' ', SubStringCount(Version, ' ')+1) as [Version Number]