Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^2: Looking for appropriate Regex

by better (Acolyte)
on Apr 07, 2013 at 19:18 UTC ( #1027390=note: print w/ replies, xml ) Need Help??


in reply to Re: Looking for appropriate Regex
in thread Looking for appropriate Regex

Well, I parsed variably structured strings, consisting of different characters, like: letters, numbers, space, brackets, minus, comma from a CSV file.

The CSV file is a database output in the form of an Excel worksheet, saved as a CSV file. The first coloumn contains fields with a series of letters and numbers, called IDs, i.e.

|A B 1234 a <1>| |A B 1234 a,b|

In order to look up the image files corresponding to the IDs, I parse the IDs of the CSV file into a text file, which will later be opened as a file handle. During the parsing of the IDs the comma of comma separated letters (like: a,b or c,e) which are part of the ID is accidentally (?) deleted.

Just to point out the context: The parsing is the first step of a file import, see nodes:

Read text file - Encoding problem?

Looking up elements of an array in another array!


Comment on Re^2: Looking for appropriate Regex
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1027390]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (18)
As of 2015-07-28 13:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (254 votes), past polls