ACCESS: extracting strings
jpbart3004
-
Le Pingou Posted messages 12276 Registration date Status Contributor Last intervention -
Le Pingou Posted messages 12276 Registration date Status Contributor Last intervention -
Hello,
I am encountering a difficulty with ACCESS: I have a unique field composed of structured data as follows
*AAAAA*BBBBB*CCCCC*
*DDD*FFFF*VVVVVVVVVVVV*
I want to extract the data between the * (I cannot do what is necessary during import)
1st issue: the strings are of different lengths between each * ;
2nd issue: the asterisk symbol which means all characters in ACCESS (I am using charcode 42)
Thank you in advance,
best regards,
Configuration: Windows 7 / Firefox 4.0.1
I am encountering a difficulty with ACCESS: I have a unique field composed of structured data as follows
*AAAAA*BBBBB*CCCCC*
*DDD*FFFF*VVVVVVVVVVVV*
I want to extract the data between the * (I cannot do what is necessary during import)
1st issue: the strings are of different lengths between each * ;
2nd issue: the asterisk symbol which means all characters in ACCESS (I am using charcode 42)
Thank you in advance,
best regards,
Configuration: Windows 7 / Firefox 4.0.1
2 answers
-
Hello,
Is it possible to see the code you have written (..I'm using charcode 42...)?
--
Regards.
The Penguin-
I tried with a function like this:
Extracchaîne([Champ1]; InStrRev([Champ1];Chaîne$(1;42))-1); in my string, I have 8 asterisks as separators; I need the data to the left (no issues with the Left function and to the right with the Right function, but regarding the data starting from the 3rd asterisk from the left, the length of the text is variable so probably.
Thank you
Best regards, -
-
