S
Søren M. Olesen
Hi
I need to split a comma delimited text, however if the comma is between ' '
then no split should occur
ie:
Class.Value, 'true' , 'some text', 'false', 'text, text, text'
should split into:
Class.Value
'true'
'some text'
'false'
'text, text, text'
Class.Value, 'true' , 'some text', Class.Name, '1a2, 3c4, k'
should split into:
Class.Value
'true'
'some text'
Class.Name
'1a2, 3c4, k'
and so on, what split expression should I use for that??
TIA
Søren
I need to split a comma delimited text, however if the comma is between ' '
then no split should occur
ie:
Class.Value, 'true' , 'some text', 'false', 'text, text, text'
should split into:
Class.Value
'true'
'some text'
'false'
'text, text, text'
Class.Value, 'true' , 'some text', Class.Name, '1a2, 3c4, k'
should split into:
Class.Value
'true'
'some text'
Class.Name
'1a2, 3c4, k'
and so on, what split expression should I use for that??
TIA
Søren