Want to find "+" value from a variable

[MurugarajSa]

Hi,

I have 3 variables - Receiver, ISA07, ISA08

I will have to update ISA07 and ISA08 variables based on the value of Receiver.

if Receiver has value as 12+0975677. I need to validate whether receiver variable has "+" value. If so I will update ISA07=12 and ISA08=0975677. How to achieve it in formula mode.

Thanks

[gary1 · Accepted solution]

Try this:

For ISA07:

Receiver.include?("+") ? "12" : ISA07

For ISA08:

Receiver.include?("+") ? "0975677" : ISA08

If Receiver does not include "+" the variables will remain the same.

[shivakumara · Accepted solution]

Hi @MurugarajSa ,

You can use below formulae for the match 

ISA07:
Receiver.match?(/[\/+]/)? "12" : "ISA07" 

ISA08:
Receiver.match?(/[\/+]/)? "0975677" : "ISA08"  

[gary1 · Accepted solution]

Try this:

For ISA07:

Receiver.include?("+") ? "12" : ISA07

For ISA08:

Receiver.include?("+") ? "0975677" : ISA08

If Receiver does not include "+" the variables will remain the same.

[MurugarajSa]

Hi @gary1 

It worked perfectly. But

One concern is Receiver variable might have value "+" or "/". (E.g. 12+0975677,  12/0975677).

ISA07 should be 12 and ISA08 should be 0975677.

Can you please suggest me how I can achieve this?

Thanks in advance.

[shivakumara · Accepted solution]

Hi @MurugarajSa ,

You can use below formulae for the match 

ISA07:
Receiver.match?(/[\/+]/)? "12" : "ISA07" 

ISA08:
Receiver.match?(/[\/+]/)? "0975677" : "ISA08"  

[MurugarajSa]

Hi @shivakumara 

Thanks