|
Trim data in Excel 2003
Hi there
I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data Desired Output Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24 |
Trim data in Excel 2003
=LEFT(A1,FIND("extract",A1)+7)
On 15 Kwi, 14:14, wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data * * *Desired Output *Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe * * *LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract * * * *test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24 |
Trim data in Excel 2003
try,
=LEFT(A2,FIND("extract",A2)+6) " wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data Desired Output Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24 |
Trim data in Excel 2003
Sorted!
=LEFT(A13,FIND("_",A13,LEN(A13)-(FIND("_",(RIGHT(A13,26+7)),2)+26))-IF (FIND("_",(RIGHT(A13,26+7)),2)=3,5,IF(FIND("_",(RI GHT(A13,26+7)),2) =2,6,1))) '7' is used as a fiddle factor! On 15 Apr, 13:21, Jarek Kujawa wrote: =LEFT(A1,FIND("extract",A1)+7) On 15 Kwi, 14:14, wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data * * *Desired Output *Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe * * *LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract * * * *test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24- Hide quoted text - - Show quoted text - |
Trim data in Excel 2003
my (slightly adjusted) formula gives a desired result
=LEFT(A1,FIND("extract",A1)+6) On 15 Kwi, 19:00, wrote: Sorted! =LEFT(A13,FIND("_",A13,LEN(A13)-(FIND("_",(RIGHT(A13,26+7)),2)+26))-IF (FIND("_",(RIGHT(A13,26+7)),2)=3,5,IF(FIND("_",(RI GHT(A13,26+7)),2) =2,6,1))) '7' is used as a fiddle factor! On 15 Apr, 13:21, Jarek Kujawa wrote: =LEFT(A1,FIND("extract",A1)+7) On 15 Kwi, 14:14, wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data * * *Desired Output *Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe * * *LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract * * * *test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24- Hide quoted text - - Show quoted text -- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
| All times are GMT +1. The time now is 12:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com