Subfield() help

[mahitham]

Hi Experts,

Can any one please help me in below requirement.

In ID field I have the records like below.

ID                                                                                  Output ID

75963865                                                                      75963865 

987596386                                                                    987596386

789456123_04586_Transfer_Time                               789456123

789456123_0WR_Transfer_Time                             

From the above id I have to remove the data after  '_ ' need to get the Output ID.

Please help me on this.

Thanks in advance

[Chanty4u]

load*

,

keepchar(ID,'0123456789')  as NewID;

load * inline[

ID

.....

.......

];

[Chanty4u · Accepted solution]

try this

subfield(ID, '_' ,1)    as New