|
sathiya.sw has asked for the wisdom of the Perl Monks concerning the following question:
What is a good delimiter for Perl ?
In other languages, while parsing data we would expect the $#$ to not appear in it, and use it as delimiter. But here $ means a scalar, so which is a good delimiter here ?
|
Re: good delimiter in data for Perl
by JavaFan (Canon) on Jan 07, 2009 at 13:28 UTC
|
What is a good delimiter for Perl?
That's not an interesting question. You shouldn't choose your delimiter based on the language the program(s) that process the data, but on the data itself.
When I have to pick a delimiter, the questions I ask are:
- Do I want to look at the data myself?
- Is the data generated or edited by humans?
- Are there characters (or short sequences of characters) that cannot occur in the data?
- If the answer of the previous question is 'no', what delimiter is expected to be rare? (I also have to start thinking about an escape sequence).
- Do I want the delimiter to be surrounded by optional whitespace? (If any of the first two questions is 'yes', the answer to this one tends towards 'yes'; if the data can have fields with leading or trailing whitespace, the answer tends towards 'no').
| [reply] |
Re: good delimiter in data for Perl
by Corion (Patriarch) on Jan 07, 2009 at 13:16 UTC
|
You seem to be confused about the distinction between data and code. Perl has no problem with using a record or field separator of $#$. Personally, I prefer the tabulator (chr 09) as a universal field separator. Why do you think that Perl has a problem with using $#$ as a separator?
| [reply]
[d/l]
[select] |
|
|
Perl has no problem in doing it. But when i use the $#$ as the delimiter, then i need to escape it to avoid interpreting it as variable..
My data can have tabs also, so what i can have as delimiter was my question ?
| [reply] |
|
|
my $delimiter = '$#$';
my @columns = split /\Q$delimiter\E/, $data;
So, again, I'm not sure why you see this as a problem, as Perl provides many convenient escaping mechanisms, like single quotes and quotemeta. | [reply]
[d/l] |
Re: good delimiter in data for Perl
by zwon (Abbot) on Jan 07, 2009 at 13:16 UTC
|
| [reply] |
|
|
No, because my data itself can have those separators which the CSV will be using. so these separators may clash, and data parsed wrongly !!
| [reply] |
|
|
| [reply] |
|
|
CVS has standard ways to handle special characters in data:
1,2,3,4 is (1, 2, 3, 4)
1,"2,2,2",3,4 is (2, '2,2,2', 3, 4)
1,"2,""2""2",3 is (1, '2,"2",2', 3, 4)
| [reply]
[d/l] |
Re: good delimiter in data for Perl
by Tanktalus (Canon) on Jan 07, 2009 at 16:22 UTC
|
Just use Text::CSV_XS and be done with it. Parsing strings with arbitrary delimiters which may or may not be present in the actual data isn't exactly a hard problem, but there are too many special cases to concern yourself with that end up making a simple split on a regex painful. Seeing as this is a common problem, someone has taken the time to put it in a module so that we don't need to continue to worry about those special cases and, instead, concentrate on the real problem at hand.
In fact, I would suggest using DBD::CSV instead, as it takes care of yet another layer or three of abstraction so that the data in your table really gets treated like data, again, to allow you to concentrate more on business logic than data logic.
Of course, from there, it's a relatively small step to put the data in a real database (whether SQLite, MySQL, DB2, Oracle, or whatever) and gain further abstraction, speed, and utility. This is my goal for nearly all my data. I can't always get there, but I do try to design my data that it COULD get to a database, which includes using DBD::* whenever possible.
| [reply] |
Re: good delimiter in data for Perl
by Lawliet (Curate) on Jan 07, 2009 at 19:44 UTC
|
The delimiter should depend on the data. If you know you are not using tabs or commas, use them for delimiters. If you know you are not going to use the string "KJBLDGL45W89Y0SDFAHKSDAFPOIU3WE8Y9", use that as a delimiter. Or maybe use '<(-^.^-)>' x 100; -- you get the idea.
I think we would need more information about the data you are trying to delimit in order to suggest the best delimiter.
Oh, and, just to cover some more bases, if you are searching for a delimiter for 'Perl', I would go with '' to be safe ;) (assuming you want each character).
And you didn't even know bears could type.
| [reply]
[d/l] |
|
|
