View original (French)

ACCESS: extracting strings

jpbart3004 -  
Le Pingou Posted messages 12273 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

2 answers

Answer 1 / 2
Le Pingou Posted messages 12273 Registration date   Status Contributor Last intervention   1 476
 
Hello,
Is it possible to see the code you have written (..I'm using charcode 42...)?
--
Regards.
The Penguin
0
jpbart30041
 
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,
0
Le Pingou Posted messages 12273 Registration date   Status Contributor Last intervention   1 476
 
Hello,
Thank you for the information.
Same solution as eriiic (greetings).
Regards.
Le Pingou
0