Unanswered

Trying to extract string from plain text

(0) Share

Report

Posted on by AhmetC

I have output like this in plain text:

BEGIN:VCALENDAR
PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VEVENT
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:email@emailaddress.com
ORGANIZER:email@emailaddress.com
DTSTART:20230710T100000Z
DTEND:20230710T113000Z
UID:e61m11jt9fxe9107402h0561263af9b
DTSTAMP:20230703T150531Z
DESCRIPTION:Description of invite
SUMMARY:Test summary here
LOCATION:england
END:VEVENT
END:VCALENDAR

How can I extract the text after "SUMMARY:" and the same for other things for each one of these invites?

Thanks

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

S-Venkadesh 923 Moderator on at

Like (1)

Report

Hi @AhmetC ,

You can use the Substring formula to extract the desired text.
The following example demonstrates how to extract the string after the "SUMMARY" text:
substring(variables('varText'), add(indexOf(variables('varText'), 'SUMMARY:'), 8))

Below screenshot is for your reference:

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @AhmetC

I have used a string variable 'varInputString' to store the input text in the given example:

Next, using expression in 'Compose' action, we will fetch the Summary text. The expression needs to be written in the expression window:

The expression used inside 'Compose' box is:
first(split(last(split(variables('varInputString'),'SUMMARY:')),decodeUriComponent('%0A')))
Pls replace the variable name as per your need. Likewise, you can fetch the other information from the input text.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
AhmetC 13 on at

Like (0)

Report

Unfortunately, this was giving everything after SUMMARY: including next lines which I didn't need.

Was this reply helpful? Yes No
AhmetC 13 on at

Like (0)

Report

Thank you sir 🙂

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (1)

Report

One way to do this is to dynamically find the starting position of Summary and Location (you would do this for other values too). This allows you to grab subtext between the two positions in your text. This has worked really well for me in production flows and is dependable. Let me know if this works for you - always glad to help! Tom

The successful runPart 1Part 2

get string.docx

Was this reply helpful? Yes No
S-Venkadesh 923 Moderator on at

Like (2)

Report

Hi @AhmetC ,

Below screenshot explains how to extract the string after "SUMMARY" and before "LOCATION" from the input text
I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No