cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Argument in WEB-I Variable

abkshatriya
Active Participant
0 Kudos

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

View Entire Topic
abkshatriya
Active Participant
0 Kudos

Hi,

Below Formula helped me to solve the Problem..

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

Thanks to all...