Forum Discussion

deepak91g's avatar
deepak91g
Icon for Resolver II rankResolver II
8 years ago
Solved

Split (left) a text column based on '-' or '_' as Delimiter?

 

I would like to achieve this task. I tried using split columns http://prntscr.com/ibe7hy

InputOutput
A_BA
AB_CAB
AC-DAC
ABC-E_CABC
AC_E-DAC
Need Help
  • gooranga1's avatar
    gooranga1
    8 years ago

    You could also use a formula like;

     

    Column x = left(SUBSTITUTE(Table6[Column1],"-","_"),FIND("_", SUBSTITUTE(Table6[Column1],"-","_"),1,LEN(SUBSTITUTE(Table6[Column1],"-","_"))+1)-1)able6[Column1],"-","_"))+1)-1)

  • deepak91g's avatar
    deepak91g
    8 years ago

    gooranga1 Thanks for suggestion and giving an idea to approach this problem.

     

    with some changes, this worked for me

     

    left(SUBSTITUTE(ad_word_api_report_config[client_customer_name],"-","_"),FIND("_", SUBSTITUTE(ad_word_api_report_config[client_customer_name],"-","_"),1,LEN(SUBSTITUTE(ad_word_api_report_config[client_customer_name],"-","_"))+1)-1)

  • Anonymous's avatar
    Anonymous
    8 years ago

    deepak91g

     

    You can also use Splitter.SplitTextByAnyDelimiter({List of delimiters},Source)

     

    list of delimiters can be {"&","/"}