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

Accepted Solutions (1)

Accepted Solutions (1)

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...

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Work around on Match, if then else and Replace functions Combination of these will achieve your requirement ,

like if (match( Object;" , ")) then replace(object ; "") else if ... else Object

Note : what the problem is data is only in one cell then you will able to view ABCDE , by using /n new line you will be seen like as u mentioned above on one cell

Hope this helps u

Regards

Sunil

abkshatriya
Active Participant
0 Kudos

Hi Sunil,

I tried your formula like..

=If(Match([Name];";")) Then Replace([Name];";";Char(10)) ElseIf(Match([Name];",")) Then Replace([Name];",";Char(10))

I am getting blank cell.....

Thanks

harshil_joshi
Contributor
0 Kudos

Solution:

Create following Variables

To_Remove_1=If(Length([Column1])<>1) Then (Replace([Column1];";";""))

To_Remove_2=If(Length([To_Remove_1])<>1) Then (Replace([To_Remove_1];":";""))

Else [To_Remove_1]

To_Remove_3=If(Length([To_Remove_2])<>1) Then (Replace([To_Remove_2];"/";""))

Else [To_Remove_2]

To_Remove_4=If(Length([To_Remove_3])<>1) Then (Replace([To_Remove_3];"-";""))

Else [To_Remove_3]

To_Remove_5=If(Length([To_Remove_4])<>1) Then (Replace([To_Remove_4];"i.";""))

Else [To_Remove_4]

Last Variable i.e. To_Remove_5 will solve your problem.

* [Column1] is your data column from where your getting this data.

Thanks & Regards.

abkshatriya
Active Participant
0 Kudos

Hi Harshil,

I want all these in single Variable..and if i have to create 5 variables then i am able to create it as i mentioned in my post.

And Result belongs to a single Row but all the Values needs to be in New Line.

Thanks

harshil_joshi
Contributor
0 Kudos

Result will not belong to a single row, it will be in a new line.

Try it, this is also a solution and it is also as per your requirement.

Thanks & Regards.