Hi guys,
I am trying to find a way for a website user to copy a standard html table from a website and paste it in to a form on my website, which would then upload it to php to a mysql db.
The table they would copy follows the same format however the fields could sometimes have either or numberical or characters as values.
An example of a table I would be trying to upload to my DB is this:
"Date Duty Dep Begin End Arr
1 Apr 14, Wed 7743 HME 04:40 Z 06:20 Z AWY
1 Apr 14, Wed 6473 AWY 06:45 Z 08:55 Z FRG
1 Apr 14, Wed 1231 FRG 09:20 Z 11:25 Z AWY
1 Apr 14, Wed 2222 AWY 11:50 Z 13:25 Z HME
2 Apr 14, Tue STDY0300-Z HME 03:00 Z 15:00 Z
3 Apr 14, Thu 6666 HME 05:00 Z 06:05 Z WAG
3 Apr 14, Thu 5555 WAG 06:30 Z 07:40 Z HME
3 Apr 14, Thu 2222 HME 08:05 Z 10:50 Z NWR
3 Apr 14, Thu 1111 NWR 11:15 Z 13:50 Z HME
4 Apr 14, Fri 4444 HME 04:15 Z 07:05 Z CKC
4 Apr 14, Fri 2222 CKC 07:45 Z 10:15 Z HME"
Does anyone know the best way to try and separate the columns in each row to process with PHP?
Thanks,