Answered

Help building split expression with multiple separators

(0) Share

Report

Posted on by jessicadduffey

Hello - I am attempting to build an expression to split a string into an array of strings using bullets as delimiters. So, for example...

Input:

• Focus on design, conception, implementation, and evaluation of AI/ML software architectures for solutions classified as medical device according to the current state of art and in compliance with the applicable standards and regulations • Manage and schedule work for software development team of multiple complex projects as well as develop, qualify, and maintain suppliers as partner relationships • Drive conception and implementation of the data interfaces internally at Bayer and between Bayer and external partners for the exchange of sensitive health data in compliance with data protection guidelines and Bayer internal compliance standards

Output:

"Focus on design, conception, implementation, and evaluation of AI/ML software architectures for solutions classified as medical device according to the current state of art and in compliance with the applicable standards and regulations ",
"Manage and schedule work for software development team of multiple complex projects as well as develop, qualify, and maintain suppliers as partner relationships ",
"Drive conception and implementation of the data interfaces internally at Bayer and between Bayer and external partners for the exchange of sensitive health data in compliance with data protection guidelines and Bayer internal compliance standards ",

After a review of our source documents, I'm learning that several types of bullets are being used, including o, •, - , *, and others.

My question is - how do I work these multiple separators into an expression? I used this expression when I thought I only had one delimiter:

split(outputs('JD_-_Remove_Spacing'),'• '), and it worked great...but now I have multiple delimiters. I want to split the string no matter what type of bullet is used. I attempted separating the delimiters with commas like this: split(outputs('JD_-_Remove_Spacing'),'• ', 'o '), but the flow failed. Any suggestions?

Thanks in Advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @jessicadduffey ,

You could replace o, •, - , * with • and then do the split. Please try:

replace(variables('tapString'),items('Apply_to_each'),'• ')

Best Regards,

Bof

Was this reply helpful? Yes No
jessicadduffey on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft - at first I was getting an error message, then it worked beautifully after I initialized the variable, created an array with the bullets, then plugged that into the apply to each step. Thank you!

Was this reply helpful? Yes No
jessicadduffey on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft, I've run into another issue...
One of our job descriptions has a numbered list instead of a bulleted list (see below):
1. Lead the Digital Transformation of SCM in Region Americas and foster
a digital mindset. Review and analyze operative SCM processes and drive
harmonization, standardization, and automation by applying digital tools
and development of automated solutions (e.g., RPAs) across
countries/regions to open opportunities for higher efficiency
2. Lead SCM operational excellence by ensuring continuous process
improvements and promoting innovation via enabling technologies with the
aim to increase operational efficiency and effectiveness. Achieve cost
savings and quality improvements according to defined targets and
business cases
3. Develop and implement global/regional/local tools (e.g., SVT, DVT),
new demand planning systems and ERP implementations/updates, system
upgrades, and migrations. Ensure efficient and sustainable execution of
new established processes and plan and track implementation

Do you have any suggestions on how would I build an expression to replace the numbers with '• '?
Thanks in advance!

Was this reply helpful? Yes No