Summary of input in a list

Questions and Help
1

Hello,
I am new in the community and have been loving Blaze but I am stuck on a new project!

I have as an input a text as below.
Date : 2025-02-02
Cholestérol total : 3515,4 mmol/L
Triglycérides : 2,03 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-04
Cholestérol total : 4 mmol/L
Triglycérides : 3 mmol/L
Cholestérol HDL : 0,93 mmol/L

============

The variable which is Cholestérol total, Triglycérides and Cholestérol HDL can vary from different report I received. Sometime there is a new variable like Hemoglobin but it will alway be on a new line.

So I am trying to extract the numerical value from each variable with the associated date and after to be able to get an output will show a trend. Here an example

Cholestérol total : 3515,4 (2025-02-02) ← 4 (2025-02-04)
Triglycérides : 2,03 (2025-02-02) ← 3 (2025-02-04)
Cholestérol HDL : (2025-02-02) ← 0,93 (2025-02-04)

I tried extractregex and input into data blaze. But I am having difficulty.

If anyone have an idea which command should I try?
I think the formula map could help and the formula list.

Thank you!

2

Hey @robertremblay ,
Does something like this works?

I used extract regex with a caputre and for Hameglobin I used catch() to default it to empty text if not found.

{txt="
Date : 2025-02-02
Cholestérol total : 3515,4 mmol/L
Triglycérides : 2,03 mmol/L
Cholestérol HDL : 0,93 mmol/L
"}
For date {=replace(extractregex(txt, "Date\s*:\s*([\d-]+)"), ",", ".")}
Cholestérol Total is {=replace(extractregex(txt, "Cholestérol total\s*:\s*([\d,]+)"), ",", ".")}
Triglycérides is {=replace(extractregex(txt, "Triglycérides\s*:\s*([\d,]+)"), ",", ".")}
Cholestérol HDL is {=replace(extractregex(txt, "Cholestérol HDL\s*:\s*([\d,]+)"), ",", ".")}
{hemaglobin=catch(replace(extractregex(txt, "Hemoglobin\s*:\s*([\d,]+)"), ",", "."), "")}{if: hemaglobin<>""}Hemaglobin is {=hemaglobin}{endif}

{txt="
Date : 2025-02-04
Cholestérol total : 4 mmol/L
Triglycérides : 3 mmol/L
Cholestérol HDL : 0,93 mmol/L
"}
For date {=replace(extractregex(txt, "Date\s*:\s*([\d-]+)"), ",", ".")}
Cholestérol Total is {=replace(extractregex(txt, "Cholestérol total\s*:\s*([\d,]+)"), ",", ".")}
Triglycérides is {=replace(extractregex(txt, "Triglycérides\s*:\s*([\d,]+)"), ",", ".")}
Cholestérol HDL is {=replace(extractregex(txt, "Cholestérol HDL\s*:\s*([\d,]+)"), ",", ".")}
{hemaglobin=catch(replace(extractregex(txt, "Hemoglobin\s*:\s*([\d,]+)"), ",", "."), "")}{if: hemaglobin<>""}Hemaglobin is {=hemaglobin}{endif}

{txt="
Date : 2029-03-25
Cholestérol total : 42 mmol/L
Triglycérides : 2,35 mmol/L
Cholestérol HDL : 0,99 mmol/L
Hemoglobin : 13,9
"}
For date {=replace(extractregex(txt, "Date\s*:\s*([\d-]+)"), ",", ".")}
Cholestérol Total is {=replace(extractregex(txt, "Cholestérol total\s*:\s*([\d,]+)"), ",", ".")}
Triglycérides is {=replace(extractregex(txt, "Triglycérides\s*:\s*([\d,]+)"), ",", ".")}
Cholestérol HDL is {=replace(extractregex(txt, "Cholestérol HDL\s*:\s*([\d,]+)"), ",", ".")}
{hemaglobin=catch(replace(extractregex(txt, "Hemoglobin\s*:\s*([\d,]+)"), ",", "."), "")}{if: hemaglobin<>""}Hemaglobin is {=hemaglobin}{endif}

3

Thank you for the input! It is appreciated! Actually the goal is really to combine both list and be able to see the trend between multiple dates.

I was able to do it but it is only working with 2 dates and only 3 variables!

But it is not modular, so if I have more dates or more variable it is not taking them.

the input text is :

Date : 2025-02-02
Cholestérol total : 3515,4 mmol/L
Triglycérides : 2,03 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-04
Cholestérol total : 4 mmol/L
Triglycérides : 3 mmol/L
Cholestérol HDL : 0,93 mmol/L

But it is not working if for example it is : Date : 2025-02-02
Cholestérol total : 3515,4 mmol/L
Triglycérides : 2,03 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-04
Cholestérol total : 4 mmol/L
Triglycérides : 3 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-09
Cholestérol total : 2 mmol/L
Triglycérides : 5 mmol/L
Hemoglobin : 120 mmol/L

=========================

{formparagraph: name=Input Text; default=Date : 2025-02-02
Cholestérol total : 3515,4 mmol/L
Triglycérides : 2,03 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-04
Cholestérol total : 4 mmol/L
Triglycérides : 3 mmol/L
Cholestérol HDL : 0,93 mmol/L}

{dates=extractregexall(Input Text, "Date : (\d{4}-\d{2}-\d{2})")}
{cholesterol_total=extractregexall(Input Text, "Cholestérol total : ([\d,]+) mmol/L")}
{triglycerides=extractregexall(Input Text, "Triglycérides : ([\d,]+) mmol/L")}
{cholesterol_hdl=extractregexall(Input Text, "Cholestérol HDL : ([\d,]+) mmol/L")}

Cholestérol total : {=cholesterol_total[1]} ({=dates[1]}) ← {=cholesterol_total[2]} ({=dates[2]})
Triglycérides : {=triglycerides[1]} ({=dates[1]}) ← {=triglycerides[2]} ({=dates[2]})
Cholestérol HDL : {=cholesterol_hdl[1]} ({=dates[1]}) ← {=cholesterol_hdl[2]} ({=dates[2]})

4

Hi @robertremblay ,
Thanks for the full example.
Here is the snippet which should get the result you need

{formparagraph: name=Input Text; default=Date : 2025-02-02
Cholestérol total : 3515,4 mmol/L
Triglycérides : 2,03 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-04
Cholestérol total : 4 mmol/L
Triglycérides : 3 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-09
Cholestérol total : 2 mmol/L
Triglycérides : 5 mmol/L
Hemoglobin : 120 mmol/L; rows=15; cols=40}
{note: preview=no}
{parts=splitregex(`Input Text`, "\n[\n]+")}

{dates=map(parts, (part) -> extractregex(part, "Date : (\d{4}-\d{2}-\d{2})"))}
{cholesterol_total=map(parts, (part) -> extractregex(part, "Cholestérol total : ([\d,]+) mmol/L"))}
{triglycerides=map(parts, (part) -> extractregex(part, "Triglycérides : ([\d,]+) mmol/L"))}
{cholesterol_hdl=map(parts, (part) -> catch(extractregex(part, "Cholestérol HDL : ([\d,]+) mmol/L"), "NA"))}
{hemaglobin=map(parts, (part) -> catch(extractregex(part, "Hemoglobin : ([\d,]+) mmol/L"), "N/A"))}
{endnote}
Cholestérol total : {=join(map(dates, (date, index) -> cholesterol_total[index] & " (" & date & ")"), " ← ")}
Triglycérides : {=join(map(dates, (date, index) -> triglycerides[index] & " (" & date & ")"), " ← ")}{=triglycerides[1]}
Cholestérol HDL : {=join(map(dates, (date, index) -> cholesterol_hdl[index] & " (" & date & ")"), " ← ")}
Hemoglobin: {=join(map(dates, (date, index) -> hemaglobin[index] & " (" & date & ")"), " ← ")}

I have use split with more two new lines to split each section.
Then used map() to find the value I need those parts.

5

Wow! Thank you so much! I will continu working on it I have a couple idea with adding "if" to automatically only output variable of the report! I will post it when I am done!

1 Like
6

Hi Robert,

Here is another version with changes to dynamically update the output when different lab types are added

{note}{formparagraph: name=Input Text; default=Date : 2025-02-02
Cholestérol total : 3515,4 mmol/L
Triglycérides : 2,03 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-04
Cholestérol total : 4 mmol/L
Triglycérides : 3 mmol/L
Cholestérol HDL : 0,93 mmol/L

Date : 2025-02-09
Cholestérol total : 2 mmol/L
Triglycérides : 5 mmol/L
Hemoglobin : 120 mmol/L
; rows=15; cols=40}
{endnote}{note: preview=no}{parts=filter(splitregex(`Input Text`, "\n[\n]+"), (part) -> contains(part, "Date"))}
{dates=map(parts, (part) ->
catch(extractregex(part, "Date\s*:\s*(\d{4}-\d{2}-\d{2})"), "N/A")
)}
{all_labs_lists=map(parts, (part) ->
catch(
extractregexall(part, "([A-Za-zéèêÉÈÊ_]+(?: [A-Za-zéèêÉÈÊ_]+)?)\s*:"),
[]
)
)}
{flattened=reduce(
seq(1, count(all_labs_lists)),
[],
(acc, i) -> merge(acc, all_labs_lists[i])
)}
{unique_labs=unique(flattened)}
{labs=filter(unique_labs, (lab) -> lab <> "Date")}
{lab_results=map(labs, (lab) ->
lab
& ": "
& join(
map(parts, (part, index) ->
catch(
extractregex(
part,
lab & "\s*:\s*([\d,]+(?:\.\d+)?)mmol/L"
),
"N/A"
)
& " ("
& dates[index]
& ")"
),
" ← "
)
)}{endnote}{repeat: for lab_result in lab_results}
{note}{=split(lab_result, ":")[1]}{endnote}{formtoggle: name=; default=yes}{=lab_result}{endformtoggle}
{endrepeat}

1 Like
7

Wow!! It is exactly what I had in mind! It will be so useful! Thank you so much!