topic Re: Wildcard string replacement ? in Workato Pros Discussion Board

Wildcard string replacement ?

dunncrew — Wed, 11 Oct 2023 13:32:48 GMT

Hi, is there a way to replace characters using a wildcard with a blank ?

There are always 6 zeroes, and random 3 digits and a period before the 6 zeroes

2023-10-09 17:38:36.243000000 More text here

2023-10-09 17:42:37.770000000 More text here

Becomes

2023-10-09 17:38:36 More text here

2023-10-09 17:42:37 More text here

Re: Wildcard string replacement ?

gary1 — Wed, 11 Oct 2023 15:46:06 GMT

Hi, me again. You can use gsub with a regular expression (regex).

The below regex looks for a period followed by any quantity of numbers and removes them.

[message].gsub(/[.][0-9]+/,"")

Example: "2023-10-09 17:38:36.243000000" becomes "2023-09 17:38:36"

There are a million regex sites out there but I find this one particularly helpful: https://regexr.com/

Re: Wildcard string replacement ?

dunncrew — Wed, 11 Oct 2023 16:59:20 GMT

Thanks. I will add that to my "Tips & Tricks" document I am making for myself.

Re: Wildcard string replacement ?

hilda-o — Sat, 31 Aug 2024 17:16:36 GMT

Hi,

following up on this conversation. What if i want to replace spaces, commas, periods, etc from the string to an empty string. What should I provide in the find regex value?

Ex: string = abc, def inc.

output should be abcdefinc

<string>.gsub(?,'')

Thank you for your help!

Hilda.