Unanswered

Need help to extract out the time as well on how to slice

(0) Share

Report

Posted on by newbieguy

Hi All,

I facing some difficulties in extracting out the information out of a email body.

"Event Source : xx-xxxxxx",
"Identifier Link:",
"https://console.aws.amazon.com/rds/home?region=ap-southeast-1#snapshot:id=rds:aaaaaaa-2023-03-21-12-06",
"SourceId: rds:aaaaaaa-2023-03-21-12-06",
"Notification time : 2023-03-21 12:08:32.758",
"Message : Automated snapshot created",
"Event ID :",
"http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html#RDS-EVENT-0091",
"--",
"If you wish to stop receiving notifications from this topic, please click or",
"visit the link below to unsubscribe:",
"https://sns.ap-southeast-1.amazonaws.com/unsubscribe.html?SubscriptionArn=arn:aws:sns:ap-southeast-1:123-123-123-123:Prod-AWS-Backup-Alerts:xxxxxxxxxxx-xxxxxxxxxxxxx-xxxxxxxxxxxx&Endpoint=xxx@xxx.xxx",
"Please do not reply directly to this email. If you have any questions or",
"comments regarding this email, please contact us at",
"https://aws.amazon.com/support",

1. Can someone please show me how to extract out just the hh:hh from ["Notification time : 2023-03-21 12:08:32.758",]

2. Can someone please show me how to extract / slice out the just the word [aaaaaaa] from [aaaaaaa-2023-03-21-12-06]

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @newbieguy
You can use slice option

I have did this way

Here i have placed the string as input in compose action

2. Next step is find the text near to Notification time and get hour:minute component from it , ie 12:08
2a. First is to find the Text position of Notification Time: using find text position action

2b. Next is to find the text position of Message word in the input

[Here outputs is the dynamic variable from compose 2 action where our input text is present]

Now use below function to get the hh:mm component from the notification time text

formatDateTime(replace(replace(replace(slice(outputs('Compose_2'),outputs('Find_text_position:_Notiifcation_Time')?['body'],outputs('Find_text_position')?['body']),'Notification time : ',''),'"',''),',',''),'hh:mm')

3. Next step is to find the aaa word
3a. for that find the position of word SourceId: rds: from input text using the Find text position

3b. Find the word aaaaa using the below function

split(slice(outputs('Compose_2'),add(outputs('Find_text_position_2_-_SourceId:_rds:')?['body'],length('SourceId: rds:'))),'-')?[0]

Results obtained:
Notification Time:

Source id rds:

Mark it as solution if this helps in solving your query

Was this reply helpful? Yes No
newbieguy 29 on at

Like (0)

Report

@Nived_Nambiar

I will try it later to see on my flow.

On the same note, can this be done with the compose function instead? The reason for me asking is that there are emails with the same content daily.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

So you are trying to say, whether the find text position and all can be done via expressions instead of using action ?

Was this reply helpful? Yes No
newbieguy 29 on at

Like (0)

Report

Yes. Cause I am getting notifications daily and would like it be more maintenance free.

Was this reply helpful? Yes No