Take out number from a string

HCL Domino Domino Forum
1

Hi All,

I am having strings of the form,

“Name_of _Person(RCN0379)”

“Name_of _Person(0486)”

"Name_of _Person(RCN0385) "

“Name_of _Person(0446)”

“Name_of _Person(RCN0288)”

string of this form is present in a field. Now from this string, I want only the RCN Number by eliminating Name_of_Person in every case, that is in this case, I want first element of the array to be 0379, second-> 0486, third->0385, fourth->0446 and finally fifth->0288.

Sometime the string RCN is present, sometimes not…

Also I know that how many RCN string will be present. That is in this case, I know that there will be 5 RCN Numbers…

How to achieve this?

Any idea…

Thanks in advance…

Aditya…

2

Subject: Take out number from a string…

@replacesubstring(@left(@right(FIELDNAME;“(”);“)”);“RCN”;“”)

This will generate a list of numbers (in string format), regardless how many items are in the field.

3

Subject: Take out number from a string…

Yoooooohhhhhhhhooooooo…

Thanks…It worked…

I was trying this from last weekend and u jst did it in one line…

Grt Work!!

Once again Thanks!!