If textbefore/textafter with double quotes

[UT_Princess]

I have a field in column A and i want to get the text after PROJ_ but before either ,TR or ",TR. I can get the formula to work if there is not a " but when there is I'm getting an error and formula will not solge

Col A	Col B	Col C	Col D
Field	Desired Result	Formula	Result
Base,USD_Reporting,FY24,TI,TD,LOC_CUST,SUB_ABC,Forecast,Load,PROJ_projectnameA,TR	projectnameA	TEXTBEFORE(TEXTAFTER(A2,"PROJ_"),",TR")	projectnameA
Base,USD_Reporting,FY24,TI,TD,LOC_CUST,SUB_DSS,Forecast,Load,PROJ_projectnameB",TR	projectnameB	if(right(TEXTBEFORE(TEXTAFTER(N2,"PROJ_"),",TR"),1)=""",(TEXTBEFORE(TEXTAFTER(N2,"PROJ_"),"",TR")),(TEXTBEFORE(TEXTAFTER(N2,"PROJ_"),",TR"))	Formula will not process (it highlights the second "PROJ_")

 

[Fluff]

How about

=SUBSTITUTE(TEXTBEFORE(TEXTAFTER(A2,"PROJ_"),",TR"),CHAR(34),"")

 

[UT_Princess]

How about

=SUBSTITUTE(TEXTBEFORE(TEXTAFTER(A2,"PROJ_"),",TR"),CHAR(34),"")

Some of the projects and locations have different lengths. So original field could be like:

Base,USD_Reporting,FY24,TI,TD,LOC_ABC,SUB_ABC,Forecast,Load,PROJ_projectnamemaybeA,TR
Base,USD_Reporting,FY24,TI,TD,LOC_PQRSTZ,SUB_ABC,Forecast,Load,PROJ_projectnameforA,TR
Base,USD_Reporting,FY24,TI,TD,LOC_CUST,SUB_ABC,Forecast,Load,PROJ_projectnamegA,TR

 

[Fluff]

That makes no difference.

 

[UT_Princess]

Thank you so much!! That worked perfectly!!

 

[Fluff]

You're welcome & thanks for the feedback.