Extract text from string

[Dr.Acula]

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.

[whiteyoh]

Hi, you could do this using php and a function called "substr".

http://php.net/manual/en/function.substr.php

[Dr.Acula]

Hi, you could do this using php and a function called "substr".

http://php.net/manual/en/function.substr.php

Hey man thank you so much, this help a great deal. Do you know if I could use "substr" on Filemaker? Or SQL?

[Dr.Acula]

What can I use php on? Is there a certain program?

[whiteyoh]

take a look at WAMP or XXAMP

[Dr.Acula]

Can I use this on MySQL? Or SQL Server?

[whiteyoh]

it all works with mysql

WAMP is Windows, Apache MySql and PHP

[styagi96]

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