Skip to Content
0
Apr 10, 2013 at 09:17 AM

Multiple Argument in WEB-I Variable

30 Views

Hi All,

Currently i am getting data in a field/Column like

A,B,C;D-.E i.F

i need to create a variable which will identify the symbol ",",";","i." etc and create result like

A

B

C

D

E

F

i am able to perform this for single Symbol..like if i have 5 symbols then i have to create 5 formulas

Like:

=Replace([Name];",";Char(10))

=Replace([Name];"i.";Char(10))

if i am doing this i am getting result in 5 different Columns but i need a formula which will use all this symbol and give me the desired result in

single Column.

Thanks