cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
craigmk1987
Helper II
Helper II

Removing text from within array items and keeping certain items.

Hello, 

 

I have a compose action that outputs the following information from a PDF extraction

 

array.png

I would like some assistance in understanding how to keep the first 6 digits, and the last digit (which is a quantity item) and then return them so I can create some header information. 

 

The desired output would look like:

 

217390, 1

 

As there are lots of products, I would then create some headers and split each item out (which I think I can manage, but any assistance with the first would be helpful :)). 

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Community Champion
Community Champion

Hi @craigmk1987 

 

You can achieve it with a select actiona as follows:

 

DamoBird365_0-1616843745753.png

 

Output is:

 

DamoBird365_1-1616843769616.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

 

View solution in original post

3 REPLIES 3
DamoBird365
Community Champion
Community Champion

Hi @craigmk1987 

 

You can achieve it with a select actiona as follows:

 

DamoBird365_0-1616843745753.png

 

Output is:

 

DamoBird365_1-1616843769616.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

 

View solution in original post

Hi Damien,

 

Thank you so much that's really helped. I noticed that some of my product names are longer than others so I've used this flow to remove "unwanted characters" Flow: Stripping Unwanted Characters or Special Characters From a String - (alanps1.io)

Thank you so much Damien. 

DamoBird365
Community Champion
Community Champion

Hi @craigmk1987 

 

Great to hear that helped you out.  Can you mark my answer as a solution so that it is easier for others to find in the future.

 

Thanks,

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (25,485)