Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
~
(?:\G(?!\A)[^\d\n]+(\d+(?:\.\d+)?)|'([A-Z][^']+)')
~
gmx
Input 1
1
New
0,['' ''] 1,['Size' 'S'] 2,['Energy (kJ)' '1644'] 3,['Protein (g)' '20.9'] 4,['Carbohydrates (g)' '33.6'] 5,['Sugars (g)' '1.8'] 6,['Total Fat (g)' '18.7'] 7,['Saturated Fat' '4.9'] 8,['Trans Fat (g)' '0'] 9,['Dietary Fibre (g)' '5.2'] 10,['Sodium (mg)' '845'] 11,['Serving Size (g)' '180'] 0,['' '' '' ''] 1,['Size' 'S' 'Size' 'M'] 2,['Energy (kJ)' '351' 'Energy (kJ)' '617'] 3,['Protein (g)' '2.3' 'Protein (g)' '4'] 4,['Carbohydrates (g)' '15.4' 'Carbohydrates (g)' '26.9'] 5,['Sugars (g)' '1.9' 'Sugars (g)' '3.3'] 6,['Total Fat (g)' '0.6' 'Total Fat (g)' '1'] 7,['Saturated Fat' '0.1' 'Saturated Fat' '0.1'] 8,['Trans Fat (g)' '0' 'Trans Fat (g)' '0'] 9,['Dietary Fibre (g)' '1.9' 'Dietary Fibre (g)' '3.4'] 10,['Sodium (mg)' '2' 'Sodium (mg)' '4'] 11,['Serving Size (g)' '75' 'Serving Size (g)' '125'] 0,['' '' '' '' '' '' '' ''] 1,['Size' 'S' 'Size' 'M' 'Size' 'L' 'Size' 'XL'] 2,"['Energy (kJ)' '1431' 'Energy (kJ)' '2030' 'Energy (kJ)' '2863' 'Energy (kJ)' '3383']" 3,"['Protein (g)' '5.7' 'Protein (g)' '8.1' 'Protein (g)' '11.4' 'Protein (g)' '13.5']" 4,"['Carbohydrates (g)' '41.5' 'Carbohydrates (g)' '58.8' 'Carbohydrates (g)' '82.9' 'Carbohydrates (g)' '98']" 5,"['Sugars (g)' '1.2' 'Sugars (g)' '1.7' 'Sugars (g)' '2.4' 'Sugars (g)' '2.9']" 6,"['Total Fat (g)' '17.9' 'Total Fat (g)' '25.4' 'Total Fat (g)' '35.9' 'Total Fat (g)' '42.4']" 7,"['Saturated Fat' '7.9' 'Saturated Fat' '11.2' 'Saturated Fat' '15.8' 'Saturated Fat' '18.7']" 8,"['Trans Fat (g)' '0' 'Trans Fat (g)' '0' 'Trans Fat (g)' '0' 'Trans Fat (g)' '0']" 9,"['Dietary Fibre (g)' '3.7' 'Dietary Fibre (g)' '5.3' 'Dietary Fibre (g)' '7.5' 'Dietary Fibre (g)' '8.8']" 10,"['Sodium (mg)' '305' 'Sodium (mg)' '432.1' 'Sodium (mg)' '609' 'Sodium (mg)' '720']" 11,"['Serving Size (g)' '110' 'Serving Size (g)' '156' 'Serving Size (g)' '220' 'Serving Size (g)' '260']"
Extraction
0,['' ''] 1,['Size' 'S'] 2,['Energy (kJ)' '1644'] 3,['Protein (g)' '20.9'] 4,['Carbohydrates (g)' '33.6'] 5,['Sugars (g)' '1.8'] 6,['Total Fat (g)' '18.7'] 7,['Saturated Fat' '4.9'] 8,['Trans Fat (g)' '0'] 9,['Dietary Fibre (g)' '5.2'] 10,['Sodium (mg)' '845'] 11,['Serving Size (g)' '180'] 0,['' '' '' ''] 1,['Size' 'S' 'Size' 'M'] 2,['Energy (kJ)' '351' 'Energy (kJ)' '617'] 3,['Protein (g)' '2.3' 'Protein (g)' '4'] 4,['Carbohydrates (g)' '15.4' 'Carbohydrates (g)' '26.9'] 5,['Sugars (g)' '1.9' 'Sugars (g)' '3.3'] 6,['Total Fat (g)' '0.6' 'Total Fat (g)' '1'] 7,['Saturated Fat' '0.1' 'Saturated Fat' '0.1'] 8,['Trans Fat (g)' '0' 'Trans Fat (g)' '0'] 9,['Dietary Fibre (g)' '1.9' 'Dietary Fibre (g)' '3.4'] 10,['Sodium (mg)' '2' 'Sodium (mg)' '4'] 11,['Serving Size (g)' '75' 'Serving Size (g)' '125'] 0,['' '' '' '' '' '' '' ''] 1,['Size' 'S' 'Size' 'M' 'Size' 'L' 'Size' 'XL'] 2,"['Energy (kJ)' '1431' 'Energy (kJ)' '2030' 'Energy (kJ)' '2863' 'Energy (kJ)' '3383']" 3,"['Protein (g)' '5.7' 'Protein (g)' '8.1' 'Protein (g)' '11.4' 'Protein (g)' '13.5']" 4,"['Carbohydrates (g)' '41.5' 'Carbohydrates (g)' '58.8' 'Carbohydrates (g)' '82.9' 'Carbohydrates (g)' '98']" 5,"['Sugars (g)' '1.2' 'Sugars (g)' '1.7' 'Sugars (g)' '2.4' 'Sugars (g)' '2.9']" 6,"['Total Fat (g)' '17.9' 'Total Fat (g)' '25.4' 'Total Fat (g)' '35.9' 'Total Fat (g)' '42.4']" 7,"['Saturated Fat' '7.9' 'Saturated Fat' '11.2' 'Saturated Fat' '15.8' 'Saturated Fat' '18.7']" 8,"['Trans Fat (g)' '0' 'Trans Fat (g)' '0' 'Trans Fat (g)' '0' 'Trans Fat (g)' '0']" 9,"['Dietary Fibre (g)' '3.7' 'Dietary Fibre (g)' '5.3' 'Dietary Fibre (g)' '7.5' 'Dietary Fibre (g)' '8.8']" 10,"['Sodium (mg)' '305' 'Sodium (mg)' '432.1' 'Sodium (mg)' '609' 'Sodium (mg)' '720']" 11,"['Serving Size (g)' '110' 'Serving Size (g)' '156' 'Serving Size (g)' '220' 'Serving Size (g)' '260']"