split string at comma, ignoring quotation marks

Former Member — Fri, 28 Sep 2012 05:31:21 GMT

I have got a string of format

a = 'b,c,"1,234.0",d,"56,789.54",g'

what i need is something similar to below

an internal table with each data as a line item

1234.0

56789.54

or a string like

a = 'b,c,"1234.0",d,56789.54,g' is good.so that i can split based on comma

Currently I cant split this based on comma .as it will split 1,234.0 into 1 and 234.0

so in general i want to delete comma which comes between "" in a string.and there can be multiple such "" in a single string

Please help ..

Re: split string at comma, ignoring quotation marks

former_member392866 — Fri, 28 Sep 2012 06:27:06 GMT

Hi,

check below logic once.

data : a(30) type c.

data : b(8) type c,

c(8) type c,

d(8) type c,

e(8) type c,

f(8) type c,

g(8) type c,

h(8) type c.

data : x(10) type c,

y(10) type c.

a = 'b,c,"1,234.0",d,"56,789.54",g' .

split a at '"' into b x c y d.

split x at ',' into e f.

split y at ',' into g h.

clear : x,y,a.

concatenate e f into x.

concatenate g h into y.

concatenate b x c y d into a.

clear : b,c,d,e,f,g,h.

split a at ',' into b c d e f g h.

write : / b, / c, / d,/ e,/ f,/ g,/ h.

out put:

1234.0

56789.54

Hope this code solved your problem.

Regards,

BALAJI.