Substring after a particular character - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

al355
No customer Topic Starter

2017-06-15T12:57:55Z

Hi,

I would like to retrieve the value from a string after a particular character. For example

abc=123

I want to return the 123 (anything after the =)

If I use substring I then need to use the string length which gets messy, is there any other way?

Thanks

Edited by moderator 2017-06-19T16:58:36Z | Reason: Not specified

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Jon Tofte-Hansen
Paid support

2017-06-15T14:40:19Z

In VC 8.2.7 you can:

{STRING(GetColumn|1|2|=|abc=123)}
or
{REGEX(Match|abc=123|(?<==).+)}

The first will stop at any later "=". The second will not.

Edited by user 2017-06-15T14:44:15Z | Reason: Not specified

al355
No customer Topic Starter

2017-06-15T14:59:41Z

Great, thanks

Gary_W
Free support

2017-06-15T18:34:04Z

Interesting alternatives Jon. My instinct would be to use:

{REGEX(Replace|abc=123|abc=(.*)|$1)}

To tighten up to match one or more decimals:

{REGEX(Replace|abc=123|abc=(\d+)|$1)}

Edited by user 2017-06-15T18:35:32Z | Reason: Not specified