I have a text file, I am told the delimiter is as quoted below. My question is how to I set the delimiter inside PHP?
ie this would set it as TAB delimiter in my script
$csv->delimiter = "\t"; # tab delimited
Field Separator (FS): SOH (ASCII character 1)
Record Separator (RS) : STX (ASCII character 2) + "\n"
For example, these characters are represented in programming languages as shown below:
Perl:
$field_separator = chr(1);
$record_separator = chr(2) . "\n";
Java:
String fieldSeparator = String.valueOf((char)1);
String recordSeparator = String.valueOf((char)2) + "\n";
A sample of the file looks like this:
#export_datecollection_type_idname
#primaryKey:collection_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
12766788028576TV Season
12766788028578Movie Bundle
12766788028577Ringtone
12766788028574Compilation
12766788028571Album
12766788028572MaxiSingle
12766788028573Orphan
12766788028575Audiobook
#recordsWritten:8