topic Re: Putting a space in the middle of a string in General Discussions

Putting a space in the middle of a string

lbolin — Sat, 10 Dec 2022 03:08:57 GMT

is there a simple way to put a space in between the PM and a number. I am new to Regex so i don't really know where to start. Is there a way to do it with out regex.

11:00 AM - 2:00 PM5:00 PM - 9:00 PM

11:00 AM - 2:00 PM4:00 PM - 9:00 PM

11:00 AM - 2:00 PM6:00 PM - 9:00 PM

Re: Putting a space in the middle of a string

PanPP — Sat, 10 Dec 2022 07:23:56 GMT

Hi @lbolin

One way to accomplish this is shown in the attached workflow.

Hope this helps, if it does please like this post.

Re: Putting a space in the middle of a string

lbolin — Sat, 10 Dec 2022 04:33:12 GMT

This worked but i didn't think to include that the other data looks like this:

11:00 AM - 9:00 PM

11:00 AM - 12:00 AM (Next day)

is there a way to do it with out touching the others?

Re: Putting a space in the middle of a string

PanPP — Sat, 10 Dec 2022 04:37:55 GMT

Can you provide the full data set? Regex might be the best option here.

Re: Putting a space in the middle of a string

ShankerV — Sat, 10 Dec 2022 07:22:58 GMT

Hi @lbolin

Can you please share the huge dataset how you data is like.

Also let us know how output should look like, so we can proceed for the solution easily.

Many thanks

Shanker V

Re: Putting a space in the middle of a string

lbolin — Mon, 12 Dec 2022 16:27:59 GMT

I can not provide the entire data set but here is a sample of the records needing to be parsed.

11:00 AM - 9:00 PM
11:00 AM - 1:00 AM
11:00 AM - 10:00 PM
9:00 AM - 8:30 PM
11:00 AM - 2:00 PM5:00 PM - 10:00 PM
8:00 AM - 11:00 PM
9:30 AM - 8:00 PM
11:00 AM - 10:00 PM
7:30 AM - 8:00 PM
11:30 AM - 2:00 PM5:00 PM - 9:30 PM

Result:

11:00 AM - 9:00 PM
11:00 AM - 1:00 AM
11:00 AM - 10:00 PM
9:00 AM - 8:30 PM
11:00 AM - 2:00 PM 5:00 PM - 10:00 PM
8:00 AM - 11:00 PM
9:30 AM - 8:00 PM
11:00 AM - 10:00 PM
7:30 AM - 8:00 PM
11:30 AM - 2:00 PM 5:00 PM - 9:30 PM

Re: Putting a space in the middle of a string

ShankerV — Mon, 12 Dec 2022 16:50:17 GMT

Hi @lbolin

Please find the below output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Re: Putting a space in the middle of a string

ShankerV — Mon, 12 Dec 2022 16:52:57 GMT

Hi @lbolin

Tried with many permutation and combination, The workflow gives the desired output.

Input:

Output:

Hope it resolves your issue, even if the dataset is huge.

Re: Putting a space in the middle of a string

PanPP — Mon, 12 Dec 2022 16:54:07 GMT

Hi @lbolin

I have uploaded a sample WF that accomplishes this without regex.

Hope this helps, if it does please like this post/mark it as a solution.