deja2000
10-18-2012, 07:50 AM
I have a spreadsheet that consist of lines of copied text strings from a Notepad file. The text strings are in column A and look like this, "D:\CallRecorder\Recordings\21955\2012-10-01\21955_2012_10_01_115748_Outbound_JasonKnight_888-575-5762.wav".
In Column B I have a MID function formula to pull out the date in the sting, "=MID(A8,34,10)". This works great, but I also need to pull out the associate’s name from the string, i.e. "JasonKnight". But the name of the caller falls differently in the string if it is an outbound call versus an inbound call, so I couldn't use the MID function.
In Column C I tried the following formula to pull out the names of the associates, "=IF(FIND("Jason",A8),"Jason",IF(FIND("James",A8),"James",IF(FIND("Katie",A8),"Katie",IF(FIND("Lindsay",A8),"Lindsay",IF(FIND("Bryce",A8),"Bryce","")))))".
The formula works if the string contains Jason's name, but I get the "#Value!" error if the name is any of the other associates.:banghead:
In Column B I have a MID function formula to pull out the date in the sting, "=MID(A8,34,10)". This works great, but I also need to pull out the associate’s name from the string, i.e. "JasonKnight". But the name of the caller falls differently in the string if it is an outbound call versus an inbound call, so I couldn't use the MID function.
In Column C I tried the following formula to pull out the names of the associates, "=IF(FIND("Jason",A8),"Jason",IF(FIND("James",A8),"James",IF(FIND("Katie",A8),"Katie",IF(FIND("Lindsay",A8),"Lindsay",IF(FIND("Bryce",A8),"Bryce","")))))".
The formula works if the string contains Jason's name, but I get the "#Value!" error if the name is any of the other associates.:banghead: