Jump to content
Forum Roportal
Sign in to follow this  
b00b00r00za

Separare cifre de litere dintr-un camp

Recommended Posts

Am intr-un .dbf un camp numit serienumar, in care am trecute impreuna si seria si numarul unei facturi, una dupa cealalta, fara spatii intre ele (de exemplu ABC1234). Ma intereseaza sa separ seria si numarul, punandu-le in campuri diferite. Vreau ca secventa(de preferat in FOX) sa caute in toata baza de date in campul serienumar litere pana cand da de o cifra, sa puna acele cifre in noul camp numit serie, iar restul caracterelor(cifrele ramase dupa extragerea literelor din fata), sa le puna intr-un nou camp numit numar.

Multumesc mult de tot :lol2: :*

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×