delimit the fields

[Gowtham174]

Hi ALl,

I have the below fields and i need to separate based on the data

input

[(337, 118, 58, 80), (1, 65, 73, 84), (428, 21, 132, 171)]

Output

in difference fields

337

118

58

80

Thanks,

Gowtham

[HirisH_V7 · Accepted solution]

PurgeChar(SubField(F1,',',1),'(,)') as 1
Based on ',' Counts keep on increasing Field no.
PurgeChar(SubField(F1,',',2),'(,)') as 1
PurgeChar(SubField(F1,',',3),'(,)') as 1

HTH,
HirisH

[pradosh_thakur]

Can you please tell what happens to the (1, 65, 73, 84), (428, 21, 132, 171) bit? if you be a bit clear on your input and output, it would be easier to help.