Remove everything after first phrase

[CGhoST (John)]

I have been trying to figure out how to remove everything after the first phrase. Following is an example:

“<1space><1space><1space><1space>Woodworks and Craft<1space><1space><1space><1space><1space><1space><1space><1space>Metal Works<1space><1space><1space><1space><1space><1space><1space><1space><1space><1space><1space><1space>Steel Works<1space><1space><1space><1space><1space><1space><1space><1space>”

The spaces are not fixed and the phrases are dynamic.

How do i remove everything after Woodworks and Craft please?

[Shakti_Singh]

Use → Regex for this -->Woodworks and Craft

[CGhoST (John)]

I know have to use regex. I don’t know the pattern to use

[ushu (Usha kiranmai)]

@CGhoST Try this. Find below workflow

Example.zip (2.5 KB)

Variable of type String Output = System.Text.RegularExpressions.Regex.Replace(Input, "(?<=Woodworks\s+and\s+Craft).*",String.Empty)

[CGhoST (John)]

Thank you but as i mentioned Woodworks and Craft is dynamic

[ushu (Usha kiranmai)]

@CGhoST Can you share sample two different Phrases

[CGhoST (John)]

I was trying to put spaces but after save they were being removed so i <1space>

[CGhoST (John)]

Another example:

<1space><1space><1space><1space><1space><1space><1space>Volleyball and Netball<1space><1space><1space><1space><1space><1space><1space><1space>Soccer<1space><1space><1space><1space><1space><1space><1space><1space>Cricket<1space><1space><1space><1space><1space><1space>Basketball<1space><1space><1space><1space><1space><1space>Tennis<1space><1space><1space><1space><1space><1space>

Wish everything removed after Volleyball and Netball

I am ok with the spaces after Volleyball and Netball but want everything removed from Soccer on wards in the above example and everything after Metal Works in the first example.

Everything is dynamic

[ushu (Usha kiranmai)]

@CGhoST I hope there is always and between first two words. Is that right ?

[CGhoST (John)]

No unfortunately. It could be Volleyball Netball even

[ushu (Usha kiranmai)]

@CGhoST 1space count will always be same or will it going to vary. I see that before first phrase there were total 7 <1space><1space><1space><1space><1space><1space><1space>Volleyball and Netball

[CGhoST (John)]

The spaces will vary also

[jack.chan]

you mean you just want to remove all the spaces after each phrase?

[CGhoST (John)]

Remove everything after first phrase

[jack.chan]

you want result to look like this? (just remove space )
“<1space><1space><1space><1space> Woodworks and Craft
<1space><1space><1space><1space><1space><1space><1space> Metal Works <1space><1space><1space><1space><1space><1space><1space><1space><1space><1space><1space><1space> Steel Works <1space><1space><1space><1space><1space><1space><1space><1space>”

or this?
“<1space><1space><1space><1space> Woodworks and Craft

[CGhoST (John)]

@jack.chan

“<1space><1space><1space><1space> Woodworks and Craft

This please

[jack.chan]

System.Text.RegularExpressions.Regex.Replace(txt, "(?s)(?<="+phrase+").*", "")

Example (when phrase = “Woodworks and Craft”)

[Yoichi]

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"^\s*\S.*?(?=\s\s|\s$|$)").Value

Regards,

[CGhoST (John)]

Wow. Amazing.

Thank you so much