Hi,
i want to extract value between two strings. below is the text and I want to extract 7460 between from and to .
4/6/2022 5:46 AM: Answered outgoing call from 7460 to 1214 Praveen Kumar (00:45)
Hello, you can use the MID and FIND functions like this :
MID(
"4/6/2022 5:46 AM: Answered outgoing call from 7460 to 1214 Praveen Kumar (00:45)",
FIND(
"from",
"4/6/2022 5:46 AM: Answered outgoing call from 7460 to 1214 Praveen Kumar (00:45)"
) + 4,
FIND(
"to",
"4/6/2022 5:46 AM: Answered outgoing call from 7460 to 1214 Praveen Kumar (00:45)"
) - FIND(
"from",
"4/6/2022 5:46 AM: Answered outgoing call from 7460 to 1214 Praveen Kumar (00:45)"
) - 4
)
MID: Returns character from the middle of a text string, given a starting position and length
FIND: Returns the position of the search_text string in text
