Unanswered

Split string at particular word

(0) Share

Report

Posted on by malamenm

Good day,

My flow runs on email attachments if they have the words confirmation or nomination in them. Saves the attachment in a folder named after part of the attachment name.

eg1. 21141202SING - AQUARIUS CONFIDENCE Confirmation.pdf saved in folder 21141202SING - AQUARIUS CONFIDENCE

eg 2. 21141402OPL - DAY Nomination.pdf saved in folder 21141402OPL - DAY

I am struggling to remove the words confirmation or nomination (or any words past that) from the folder name

I have tried using

first(split(variables('varAttachmentName'), 'Confirmation'))

but the flow just seems to run indefinately

i have also tried using

replace(outputs('Compose_2'),'Confirmation',' ')

but the flow doesnt want to replace "confirmation" with a blank value

any help?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @malamenm

Here I have used split and replace expressions.

Above expressions are as follows:

first(split(outputs('Compose'),'Confirmation'))

replace(outputs('Compose_2'),'Confirmation','')

Here are my test results:

Your flow might be running indefinitely for different reasons. Could you please post a screenshot of your flow?

Was this reply helpful? Yes No
malamenm 2 on at

Like (0)

Report
Copy link

Link copied!

Dear @abm

I have tried to simplify the code for testing but still running indefinately

please see below

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
This expression should do what you want:

concat ( if ( contains(variables('varAttachmentName'), 'Confirmation'), trim(substring(variables('varAttachmentName'), 0, indexOf(variables('varAttachmentName'), 'Confirmation'))), '' ), if ( contains(variables('varAttachmentName'), 'Nomination'), trim(substring(variables('varAttachmentName'), 0, indexOf(variables('varAttachmentName'), 'Nomination'))), '' ) )

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @malamenm

There are couple of things you need to look here. Are you always expecting Confirmation and Nomination in your filenames as attachment. If so then add a check and make sure it contains the key words you looking for and clean up using the split or replace.

Next regarding the indefinite error you described. It's the standard behaviour of SharePoint connector when it fails it goes for a retry mechanism and eventually you should get an error associated with that. What's the final error you getting. Leave it running for few minutes and eventually you should get an error.

Thanks

Was this reply helpful? Yes No