Re^2: Acknowlededment of Contributions

I'm guessing 411 (Info) would be more the thing, but it could be a different number depending on the country/region.

Sets of regexes are good for matching the various formats and unmangling them into a common form. Importing the mess to a DB (one table, with one field?) and then coming up with SQL statements to do the same thing sounds like a lot more work.

Comment on Re^2: Acknowlededment of Contributions

Replies are listed 'Best First'.
Re^4: Acknowlededment of Contributions by chacham (Prior) on Mar 03, 2015 at 17:11 UTC
Databases tend to support (limited) regex these days. So, perl is better, but databases are not out of the picture. Anyway, the OP says: the data comes from power plants the identifiers are not the same she loaded the data into a spreadsheet All this points to many tables (one per plant) with fields (spreadsheet), at the very least, id in one and the rest in another. Matching those ids to each other can be done either through a manual list, or other provided information such as by matching addresses. This can be very easy for a database to do. He should use the best tool for the situation. Perl is the best tool when it comes to text manipulation, any in many, many other cases. Though, a database might be better in this particular case.	[reply]
Re^3: Acknowlededment of Contributions (112) by LanX (Saint) on Mar 03, 2015 at 15:36 UTC
> but it could be a different number depending on the country/region. Embrace the international emergency standard! ;) In the United States, some carriers, including AT&T, will map the number 112 to its emergency number 9-1-1. Cheers Rolf _{(addicted to the Perl Programming Language and ☆☆☆☆ :)} PS: Je suis Charlie!	[reply]


No such thing as a small change
	PerlMonks