How to extract a string that appears before the character #
Solved
traderpierre
Posted messages
316
Status
Member
-
traderpierre Posted messages 316 Status Member -
traderpierre Posted messages 316 Status Member -
Hello,
In Access, I want to extract characters from a hyperlink field that are located before the character #
After trying functions and syntax specific to Excel, which are rejected
I tried:
Left([Product];""#")
It returns an error
Then: Left([Product];#)
And there I get an alert box
"The entered date type expression value is not valid".
What should I do????
Thank you in advance for your help.
In Access, I want to extract characters from a hyperlink field that are located before the character #
After trying functions and syntax specific to Excel, which are rejected
I tried:
Left([Product];""#")
It returns an error
Then: Left([Product];#)
And there I get an alert box
"The entered date type expression value is not valid".
What should I do????
Thank you in advance for your help.
Related links:
- Extract a string contained between two quotation marks, Excel 2010
- Extract data from a cell before a comma ...
- Excel: extract the text after a character.
- Excel formula: "IF" a cell contains a word, then?
- Excel: If contains *text part1* OR *text part2 then...
- Excel: How to search for a string in a range of cells?
1 answer
-
Finally, I found this solution that works wonderfully:
Extracting a string before a specific character, here #:
= Left([Product];Length([Product])-Length(ExtractString$([Product];InString([Product];""#"))))
Extracting a string after a specific character, here #:
= Right([Product];Length(ExtractString$([Product];InString([Product];""#")))-1)