Split function

Q&A
,
1

Hi
I have to extract treatment name from the below column and I have tried using the function but it is not working . Please help me on this
ifelse(
split({Ad Set Name} , ‘-’ ,1) != “001” OR
split({Ad Set Name} , ‘-’ , 2) = “001”

    )

Column:
Ad Set Name
Lipoma-Coimbatore-Sep23
Lipoma-Chennai-Sep23
Varicose Vein-Bangalore-Sep23
Piles-Hyderabad-Sep23
001-Circumcision-Vizag-Urology-LG
Lipoma-Trivandrum-Sep23
Piles-Kochi-Sep23
001-Circumcision-Kochi-Urology-LG
Piles-Chennai-Sep23
001-Piles-Vizag-Procto-LG
Lipoma-Coimbatore-Sep23
001-Circumcision-Kochi-Urology-LG
Circumcision-Hyderabad

2

Hi @Fatima

  1. there is the “then” and “else” part missing.
  1. the operater isnt right.

BG