Hi guys, i have excel in one column i have primarynumber/alt num and the data in this column are like 8686/6868 7979;9696 97979&9696 9696,7070 so i need to seperate primary number and alternate number by split method by using this expres shwng error

Help Studio
, , ,
1

CurrentRow(“primary phn/ alternate phn”).ToString.Split({“/”,“;” “&”, “/”, “,”},StringSplitOptions.None)(0) getting errror as ‘}’ as expected and also getting red line error in the this expression kindly help

2

@Ajay_rocks

You are missing , after “;”

Can you once try the below expression

CurrentRow(“primary phn/ alternate phn”).ToString.Split({“/”,“;”, “&”, “/”, “,”},StringSplitOptions.None)(0)

1 Like
3

@Ajay_rocks

CurrentRow("primary phn/ alternate phn").ToString.Split(New String() {"/", ";", "&", ",", "/"}, StringSplitOptions.None)(0)
4

Hi @Ajay_rocks

You haven’t separated the symbols which you want to split with commas properly, try the below one,

currentRow("primary phn/ alternate phn").ToString.Split({"/",";", "&", "/", ","},StringSplitOptions.None)(0)

If the above one is not working after splitting with proper commas, check the below one,

Input.Split(New String() {"/", ";", "&", "/" ,","}, StringSplitOptions.None)(0)

Hope it helps!!

5

Hi @Ajay_rocks

Try below expression

CurrentRow(“primary phn/ alternate phn”).ToString.Split(New String() {“/”, “;”, “&”, “,”, “/”}, StringSplitOptions.None)(0)

Hope it will helps you :slight_smile:
Cheers!!