0

I need help guys, I want to be able to extract text from a string. This is an example of the string:

@
ANSI 6360100102DL00390204ZF02430034DLDAACRUZ,JULIO,MIGUELDAG626 SIESTA KEY BLVD APT 434DAIDEERFIELD BEACHDAJFLDAK33441-0000 DAQC620433894240DARE DASA DAT DBA20141124DBB19891124DBC1DBD20080801DBHN DAU511
ZFZFA ZFB ZFCR050808010243ZFD

I wanna be able to extract "CRUZ", "JULIO", "626 SIESTA KEY BLVD APT 434", "DEERFIELD BEACH", "FL", and "33441" and put them into certain fields. Is that possible? If so, can you guys point me in the direction of how I can do this? Do I need a code? Or script? Any help will be appreciated.

3
Contributors
7
Replies
9
Views
7 Years
Discussion Span
Last Post by styagi96
0

I understand that this can be easily done using a php script but can it be done only by using MySql queries?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.