Subfield???

[soha1902]

Hi All,

I am having one column which is having values like

A/B/C

B/C/D/A

A/B

A

Now my requirement is I want to create a new field with help of this field which contains all the values which comes after first '/' from left.

Expected field contains:

B/C

C/D/A

B

A

Thanks...

[Anonymous]

use subfield(yourstring, '/', 2) to get text right of first char /

[#3]

Hi Soha,

try like this in scripting...

subfield(string, '/', 2) as "Your New fieldName"

[MK_QSL · Accepted solution]

Load *, Mid(FIELD, Index(FIELD,'/',1)+1) as NEWFIELD Inline

[

FIELD

A/B/C

B/C/D/A

A/B

A

];

[soha1902]

I dont want right most only. Please see expected fields.

[Anonymous]

=

right(yourstring,len(yourstring)-FindOneOf(yourstring,'/',1))