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

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)

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)

deepak91g

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

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