Member Avatar for 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.

  • 3 Contributors
  • 7 Replies
  • 207 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by styagi96
Member Avatar for Dr.Acula

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

Member Avatar for whiteyoh

take a look at WAMP or XXAMP

Member Avatar for Dr.Acula

Can I use this on MySQL? Or SQL Server?

Member Avatar for whiteyoh

it all works with mysql

WAMP is Windows, Apache MySql and PHP

Member Avatar for styagi96

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.