Unanswered

Delete string content from specific word to other specific word

(0) Share

Report

Posted on by Community Power Pla...

Hi, I'm building a flow which receives a json, in the json there is a property I need to show in a report but the property content is kinda unreadable

Example:

Hello Team,\n\n \n\nPlease assign the ticket to the IT support team.\n\n \n\nThanks,\n\*****\n\n \n\nFrom: *****V S\nSent: Wednesday, March 8, 2023 11:41 AM\nTo: *****V <*****@*****.com>; *****S E <*****@v*****.com>\nCc: ***** *****<*****@*****.com>; ***** *****\n<*****@*****.com>\nSubject: RE: IN10 - VAN - Unable to make payment via h2h\n\n \n\nHi Sid,\n\n \n\nI have requested the concerned team to discuss this with SAP and provide an\nupdate. Kindly note the timeline for these kind of requests are relatively high

I would like to know if there is a way to delete the string content between "From:" to "Subject:"
And have this as a result

Hello Team,\n\n \n\nPlease assign the ticket to the IT support team.\n\n \n\nThanks,\n\*****\n\n \n\nRE: IN10 - VAN - Unable to make payment via h2h\n\n \n\nHi Sid,\n\n \n\nI have requested the concerned team to discuss this with SAP and provide an\nupdate. Kindly note the timeline for these kind of requests are relatively high

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Hi @Anonymous ,

Here's my demo:

indexOf(outputs('Compose'),'From:') take(outputs('Compose'),outputs('Compose_2')) add(indexOf(outputs('Compose'),'Subject:'),8) slice(outputs('Compose'),outputs('Compose_4')) concat(outputs('Compose_3'),outputs('Compose_5'))

Here's result:

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi, thanks for the response

Is there another alternative in case that those string doesn't exist (from:, to:, cc:, subject:).
Sometimes the text will look like this
Hi Team, Please check we are getting error while posting. attached screenshot for reference.
And the indexOf() function is going to return a -1, that will make the take() function fail

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Then you have to find a word which will absolutely show up as a flag, so that you can locate to the content you want and don't want.

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No