Find/Mid formula to find report name within long name

[DShack]

Hi I am looking for a formula that would provide the name of the reports with the below array of report paths. I have several thousand like this. For example, the first url, the report name is AP Invoice Details and as you can see they are not all in the same format and length.

Custom/Financials/Payables/Invoices/Test Report/invoices/AP Invoice Details

Custom/Financials/Payables/Invoices/Test Report/CHK Payment report

Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account

Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account - Static filters

Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account concatenation segments

Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account cross SA

Custom/Financials/Payables/Invoices/Test Report/FP&A - AP Invoice Details by Account

Custom/Financials/Payables/Invoices/Test Report/Mass update for invoices

Custom/Financials/Payables/Invoices/Test Report/NEVANS Division Finance - FP&A - AP Invoice Details by Account

Custom/Financials/Payables/Payables Invoice Register - Copy seeded report

Custom/Financials/Payables/Invoices/Test Report/Payables Invoice Register Seeded Copy

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction / Installments Real Time

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction Real Time

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction Real Time demo

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction Real Time testing

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transactions / Disbursements Real Time

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices – Trial Balance Real Time

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices – Trial Balance Real Time - Site

Custom/Financials/Payables/Invoices/Test Report/Payables Invoices – Trial Balance Real Time - Site1

Custom/Financials/Payables/Period Close/Report Components/Payables Posted Invoice Register

Custom/Financials/Payables/Period Close/Report Components/Payables Posted Payment Register

 

[Sufiyan97]

Try

Book3
	A	B	C
1	Custom/Financials/Payables/Invoices/Test Report/invoices/AP Invoice Details	AP Invoice Details
2	Custom/Financials/Payables/Invoices/Test Report/CHK Payment report	CHK Payment report
3	Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account	Division Finance - FP&A - AP Invoice Details by Account
4	Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account - Static filters	Division Finance - FP&A - AP Invoice Details by Account - Static filters
5	Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account concatenation segments	Division Finance - FP&A - AP Invoice Details by Account concatenation segments
6	Custom/Financials/Payables/Invoices/Test Report/Division Finance - FP&A - AP Invoice Details by Account cross SA	Division Finance - FP&A - AP Invoice Details by Account cross SA
7	Custom/Financials/Payables/Invoices/Test Report/FP&A - AP Invoice Details by Account	FP&A - AP Invoice Details by Account
8	Custom/Financials/Payables/Invoices/Test Report/Mass update for invoices	Mass update for invoices
9	Custom/Financials/Payables/Invoices/Test Report/NEVANS Division Finance - FP&A - AP Invoice Details by Account	NEVANS Division Finance - FP&A - AP Invoice Details by Account
10	Custom/Financials/Payables/Payables Invoice Register - Copy seeded report	Payables Invoice Register - Copy seeded report
11	Custom/Financials/Payables/Invoices/Test Report/Payables Invoice Register Seeded Copy	Payables Invoice Register Seeded Copy
12	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction / Installments Real Time	Installments Real Time
13	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction Real Time	Payables Invoices - Transaction Real Time
14	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction Real Time demo	Payables Invoices - Transaction Real Time demo
15	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transaction Real Time testing	Payables Invoices - Transaction Real Time testing
16	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices - Transactions / Disbursements Real Time	Disbursements Real Time
17	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices – Trial Balance Real Time	Payables Invoices – Trial Balance Real Time
18	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices – Trial Balance Real Time - Site	Payables Invoices – Trial Balance Real Time - Site
19	Custom/Financials/Payables/Invoices/Test Report/Payables Invoices – Trial Balance Real Time - Site1	Payables Invoices – Trial Balance Real Time - Site1
20	Custom/Financials/Payables/Period Close/Report Components/Payables Posted Invoice Register	Payables Posted Invoice Register
21	Custom/Financials/Payables/Period Close/Report Components/Payables Posted Payment Register	Payables Posted Payment Register
22
Sheet1

Cell Formulas
Range	Formula
B1:B21	B1	=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99))

 

[Fluff]

What are the expected results for that data?
If it's everything after the last / try

=TEXTAFTER(A2,"/",-1)

 

[kweaver]

If it's always the LAST one and you use 365, try:

=TEXTAFTER(A1,"/",-1)

 

[DShack]

Thank you! all of these ended up working!

 

[Fluff]

Glad we could help & thanks for the feedback.