Subfield issue

[fashid]

Hi Everybody,

I have an issues with subfield operation .

I have a dataset which contains domin name and username in the folowing format

DOMAIN\abc

DOMAIN\xyz

DOMAIN\efg

I needed to extract just the user names so i used the subfield function

Subfield(Upper([Authenticated user]),'\') as AuthenticatedUser

The issue that i am facing here is that , when i create a list box of the AuthenticatedUser field , Along with the desired output i also get the the original rows which are along with the DOMAIN keyword

eg

ABC

XYZ

EFG

DOMAIN\ABC

DOMAIN\XYZ

DOMAIN\EFG

[PrashantSangle · Accepted solution]

Hi,

Try like,

Upper(Subfield([Authenticated User],'\',2))

Regards

[Anonymous]

Hi,

You need to give a third parameter in the subfiled function.

Try Subfield(Upper([Authenticated user]),'\',-1)

Regards,

Greeshma

[avinashelite]

Hi Nadeem,

If you want the 2 parameter of the sub-field then you need to pass as that as the 3 parameter

Upper(Subfield([Authenticated User],'\',2))

to get second filed we are giving it as 2, if you want 1 then give 1 respectively

[fashid]

None of them are working

[avinashelite]

please share the sample data, will see what s the issue

[fashid]

Actually the duplicate fields were coming from a table further in the script which had the same feld which led to concatenation.

Thanks for all the help guys