473,372 Members | 972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

csv file

The input for this script will be a .csv file which looks like the following.

"Pin Number","Pin Name","Direction"
"10","OTW#","O"
"4","OUTL+","O"
"5","OUTL+","O"
"6","OUTL+","O"
"1","OUTL-","O"
"2","OUTL-","O"
"3","OUTL-","O"
"8","TEST0","I"
"7","TEST1","I"

the output should look like the following

TEST0 =8 =L= =I=
TEST1 =7 =L= =I=
OUTL_PP =4 =R=OUTL+ =O=
OUTL_PP =5 =R=OUTL+ =O=
OUTL_PP =6 =R=OUTL+ =O=
OUTL_MM =1 =R=OUTL- =O=
OUTL_MM =2 =R=OUTL- =O=
OUTL_MM =3 =R=OUTL- =O=


Based on the direction all the inputs with letter "I" are grouped first then outputs "O" are grouped.

The " symbol is replaced as =
The , should be replaced as some blank space
The + sholud be replaced as PP
The - sholud be replaced as MM
Oct 9 '07 #1
2 1314
KevinADC
4,059 Expert 2GB
Nobody here is going to write your code for you. First you post the code you have been trying then someone will help. You have this question on another forum where a very generous and helpful person I know has replied to your question but you have not responded.
Oct 9 '07 #2
Nobody here is going to write your code for you. First you post the code you have been trying then someone will help. You have this question on another forum where a very generous and helpful person I know has replied to your question but you have not responded.
I have attached the code

Expand|Select|Wrap|Line Numbers
  1. $file = 'c:/test3.txt';        
  2. open(INFILE, $file);        
  3. @lines = <INFILE>;
  4. foreach (@lines) { 
  5.     my @values = split(/,/);
  6.  
Oct 9 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: matt | last post by:
I have compiled some code, some written by me, some compiled from various sources online, and basically i've got a very simple flat file photo gallery. An upload form, to upload the photos and give...
5
by: Dave Smithz | last post by:
Hi There, I have a PHP script that sends an email with attachment and works great when provided the path to the file to send. However this file needs to be on the same server as the script. ...
7
by: Joseph | last post by:
Hi, I'm having bit of questions on recursive pointer. I have following code that supports upto 8K files but when i do a file like 12K i get a segment fault. I Know it is in this line of code. ...
3
by: StGo | last post by:
How can i read/write file's custom attributs(like subject,author...) in C#??? Thanks :))
0
by: Lokkju | last post by:
I am pretty much lost here - I am trying to create a managed c++ wrapper for this dll, so that I can use it from c#/vb.net, however, it does not conform to any standard style of coding I have seen....
13
by: Sky Sigal | last post by:
I have created an IHttpHandler that waits for uploads as attachments for a webmail interface, and saves it to a directory that is defined in config.xml. My question is the following: assuming...
1
by: Roy | last post by:
Hi, I have a problem that I have been working with for a while. I need to be able from server side (asp.net) to detect that the file i'm streaming down to the client is saved...
3
by: Shapper | last post by:
Hello, I created a script to upload a file. To determine the file type I am using userPostedFile.ContentType. For example, for a png image I get "image/png". My questions are: 1. Where can...
0
by: troutbum | last post by:
I am experiencing problems when one user has a document open through a share pointing to the web site. I use the dsolefile to read the contents of a particular directory and then display them in a...
0
by: thjwong | last post by:
I'm using WinXP with Microsoft Visual C++ .NET 69462-006-3405781-18776, Microsoft Development Environment 2003 Version 7.1.3088, Microsoft .NET Framework 1.1 Version 1.1.4322 SP1 Most developers...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.