How to separate the fields(delimiter

[#1]

Dear Experties,

Please Can anyone Provide the delimiter logic for  the below requirement ,Please see the output results what i am expecting

ID Number                          OutPut Results

A 213,457,890,123                   A     213

B a22/b33/c66                           A     457

C b77&c662&d99                       A     890

D a22 b39 v77                            A     123

                                                   B     a22

                                                    B    b33

                                                    B     c66.

same like for C and D

Thanks.

[vishsaggi]

Try this?

load *,

Subfield(Subfield(Subfield(subfield(Replace(Number, ',', '/'),' '), '&'), '/'), ',') AS Num inline [

ID, Number                         

A, '213,457,890,123'

B, a22/b33/c66                     

C, b77&c662&d99                    

D, a22 b39 v77

];

[effinty2112 · Accepted solution]

Hi Sunni,

Load

ID,

SubField(Number,',') as Number;

LOAD

ID,

Replace(Replace(Replace(Number,'/',','),'&',','),' ',',') as Number;

LOAD * INLINE [

    ID, Number

    A, '213,457,890,123'                        

    B, a22/b33/c66

    C, b77&c662&d99

    D, a22 b39 v77

];

Cheers

Andrew