Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
];
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