Segregate the field

[iahmadmca1]

Team,

Just I want to small help from your side, I have one column which contains the id and name I want to segregate the id separate and name separate.

Please find the below example. which I need.

source column:

TABID. Name
12345.AM_DA 2314.AMI_Test

Results:

TGB ID	TGB Name
12345	AM_DA
2314	AMI_Test

So, I request to you please write the script for segregate the one column into two.

Thanks,

Irshad Ahmad

[Anil_Babu_Samineni]

May be this?

LOAD SubField([TABID. Name], '.', 1) AS [TGB ID], SubField([TABID. Name], '.', 2) AS [TGB Name] Inline [

TABID. Name

12345.AM_DA

2314.AMI_Test

];

[iahmadmca1]

Thanks, Anil.

[Anil_Babu_Samineni]

NP, Please close this thread by flag correct answer and helpful. that may easy understand for new users

[iahmadmca1]

Hi Anil,

for small changes I going open the loop

could you please tell me how you can use the group by [TGB Name] in this script I tried to use group by but it is throwing error could you write the script for this.

[Anil_Babu_Samineni]

Please share full script and error image, May be

[iahmadmca1]

Anil,

Currently, this work in the hold will let you know once it starts.

Thanks.

Irshad Ahmad

[Chanty4u]

you can try below script also:

a:

load * Inline [

idname

12345.AM_DA

2314.AMI_Test

];

result:

LOAD *,

KeepChar(idname,'1234567890') as ID,

PurgeChar(idname,'.1234567890') as nmae

Resident a;