Split by delimiter, but keep the delimiter?

(1) Share

Report

Posted on by richardj5

I have text as per below which I need to split so that a new line is started whenever there is a "."

Tried splitting using the . as delimiter, but it removes the . (which is required)

Current text

1DOE/JOHNMR .L/ABCDEF .R/TKNE HK1 1112300348396/1-DOE/JONMR .R/SEAT HK1 9F .R/FQTV XX 60041234-1DOE/JONMR 1SMITH/KARENMISS .L/GHIJK .R/TKNE HK1 1112300219029/2-1SMITH/KARENMISS .R/SEAT HK1 8A .R/CHKD HK1 011-1SMITH/KARENMISS

Required Output Text

1DOE/JOHNMR
.L/ABCDEF
.R/TKNE HK1 1112300348396/1-DOE/JONMR
.R/SEAT HK1 9F
.R/FQTV XX 60041234-1DOE/JONMR
1SMITH/KARENMISS
.L/GHIJK
.R/TKNE HK1 1112300219029/2-1SMITH/KARENMISS
.R/SEAT HK1 8A
.R/CHKD HK1 011-1SMITH/KARENMISS

Any help on how to achieve this (in either cloud or desktop flow) appreciated

Many thanks

Categories:

Building flows

I have the same question (1)

All responses (4)

Answers (1)

Verified answer

trice602 15,402 Super User 2025 Season 2 on at

Like (1)

Report

Hi @richardj5 ,

That's an interesting use case for sure! Here's what I may try:

Start by replacing the "." with a ".~" using the replace() function in an expression. That's going to add the "~" to every "." in your current text.

Split by "." - you already have this...

Next now replace "~" with the "." and you have your "." back in your data.

Was this reply helpful? Yes No
richardj5 53 on at

Like (0)

Report

Sounds ideal, will give it a try and let you know if it achieves what I require, many thanks

Was this reply helpful? Yes No
richardj5 53 on at

Like (1)

Report

Worked perfectly, thank you 👍

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

Like (0)

Report

Hi @richardj5 ,

Awesome! Please mark as a solution to help others find this solution too!

Was this reply helpful? Yes No