Menu
Community /Pin to ProfileBookmark
@NogDogApr 16.2014 — #The quick-and-dirty solution would be to change this line (assuming it's a field that might have this issue)...
Now your job is to figure out how the heck that regular expression works -- assuming I got it right. ?
PS: There probably is a SQL-base solution using regexes in the query itself.
PPS: Prepared statements in either PDO or MySQL[b]i[/b] could both clean the code up a bit and make it work at least somewhat more efficiently.
Remove subset of data
Team,
I have a script that uploads a CSV file into a MySQL database. In this CSV file is a column of two sets of numbers. Ex: 48 / 54.
There are times when this set of numbers is 06 / 54 and interpreted by the spreadsheet creating the CSV as a date (06/01/54).
I need a way to determine of this field of data is set up like a date, and if so to remove the middle set (/01) or (01/) so my end result is 06 / 54
This line is for TxRxMBPS, line_of_data[4]
Code below.
[CODE]
while (($line_of_data = fgetcsv($file_handle, 1000, “,”)) !== FALSE) {
$line_import_query=”
INSERT into bridges (
MAC,
DeviceName,
SignalNoiseDBM,
Distance,
TxRxMbps,
CCQ,
ConnectionTime,
LastIP,
ComputerName,
ExpectedRig
) VALUES (
‘”.mysql_real_escape_string($line_of_data[0]).”‘,
‘”.mysql_real_escape_string($line_of_data[1]).”‘,
‘”.mysql_real_escape_string($line_of_data[2]).”‘,
‘”.mysql_real_escape_string($line_of_data[3]).”‘,
‘”.mysql_real_escape_string($line_of_data[4]).”‘,
‘”.mysql_real_escape_string($line_of_data[5]).”‘,
‘”.mysql_real_escape_string($line_of_data[6]).”‘,
‘”.mysql_real_escape_string($line_of_data[7]).”‘,
‘”.mysql_real_escape_string($compname).”‘,
‘”.mysql_real_escape_string($ExpectedRig).”‘
)
“;
mysql_query($line_import_query) or die(mysql_error());
}
I appreciate your help
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogApr 16.2014 — #The quick-and-dirty solution would be to change this line (assuming it's a field that might have this issue)...[code=php]
mysql_real_escape_string($line_of_data[5])
[/code]...to something like...[code=php]
mysql_real_escape_string(preg_replace('#b(d+)/d+/(d+)b#' "$1 / $2", $line_of_data[5]))
[/code]Now your job is to figure out how the heck that regular expression works -- assuming I got it right. ?
PS: There probably is a SQL-base solution using regexes in the query itself.
PPS: Prepared statements in either PDO or MySQL[b]i[/b] could both clean the code up a bit and make it work at least somewhat more efficiently.