Split and Clean String to Extract Value

(0) Share

Report

Posted on by CU25111038-0

Hi Everyone,

I have an E-Mail Body that looks like this:

E-Mail:
---------------------------------------
Dear,

text text text text text

text text text text:
•   irrelevant text 15.11.2024
•   irrelevant text 19.11.2024
•   irrelevant text 21.11.2024
------------------------------------------

I want to extract only extracts the dates in red and save each one in different compose to use it later. I do not want to split based on the bullet points "•" as it might change in the future. What I achieved so far is the following array:

[
" 15.11.2024                   ",
"·             irrelevanttext 19.11.2024   ",
"· irrelevanttext 21.11.2024"
]

I split after the first irrlevant text starts an ignore the rest of the e-mail. The problem is that I have spaces after and before each string. and I also have the bulletpoint "·" at the beginning of the string. How can clean each one so I only have dates and store them in different compose?

thanks in advance!

Categories:

Business Process Flows

All responses (3)

Answers (0)

AlexEncodian 4,261 on at

Like (0)

Report
Split and Clean String to Extract Value

Encodian's Utility - Search Text (Regex) allows you to do a regex search on your email.

The following regex query will identify the dates:

\d{2}\.\d{2}\.\d{4}

Output:
Chriddle 7,086 on at

Like (0)

Report
Split and Clean String to Extract Value

The idea is to split your text at <space>. Before that, replace characters like line breaks (or other characters that might be next to your dates) with spaces.
Then filter for items that resemble a date.
Example: length is equal to 10, the third and fifth characters are periods, the first 2 characters are numbers etc.

From

split( replace( outputs('Compose'), decodeUriComponent('%0A'), ' ' ), ' ' )

Filter (advanced mode)

@and( equals(length(item()), 10), equals(substring(item(), 2, 1), '.'), equals(substring(item(), 5, 1), '.'), isInt(substring(item(), 0, 2)), isInt(substring(item(), 3, 2)), isInt(substring(item(), 6, 4)) )
VictorIvanidze 11,840 on at

Like (0)

Report

Split and Clean String to Extract Value

Split by '.2024' and parse each string in the resulting array. Note that the flow will stop worling in 2025.