Hi all, please consider the following scenario. I have 979 csv files in a folder each with 3 lines, first line col2 has fixed value "a", second line col2 has "b" and third line col2 has "a/b".
The first column has random names (no pattern).
filename1.csv
namefile2.csv
File3.csv
4thfile.csv
In another file there are serial numbers for each of the names. The names with "a" and "b" should have just 1 serial number, sometimes it is absent.
The names with "a/b" should always have more than 1 serial number,,sometimes absent.
Serials.csv
What I want to do is add serial numbers to the names in the 979 files, and when absent, just hardcode the word "absent" in the second column.
What is important here is order must be maintained, so 1st line must be "a", second line must have "b" ,,,"a/b" starts from the 3rd line.
filename1.csv.out
namefile2.csv.out
File3.csv.out
4thfile.csv.out
If I do
... it's just pulling 1 "a/b" value. How can I get all of them?
Last edited by rbatte1; 03-11-2015 at 09:46 AM..
Reason: Tightened CODE tags to remove unecessary space int he post.
i have an external device sending serial messages i want to connect this device to a serial port in my sun blade box and record those messages to a file, how can i read the serial port and write it to file?
Thanks (4 Replies)
I need to transfer files from a sco/unix system to a windows xp system and they are only connected via a digiboard serial connection. The terminal emulation software connects and runs a program but I need to transfer files. Anyone know a good solution? (2 Replies)
Hello!
I am working on an application which reads environmental instruments which have serial ports. The application requires a serial port to be present to talk to the device (i.e. /dev/ttyS0 ). In some instances the environmental devices will be 100's of yards away from the computer, so a... (5 Replies)
Hi,
I have a SCO Unix ver 5.0.7 from which I need to get some files. The problem is that I'm working remotely (have no physical access) and using Dejawin because this server is only has a serial connection to a Windows machine. Ucopy isn't on the server. What I was thinking is to do a print... (5 Replies)
I am working on a file, I need add a column with serial # in a file, the column will be the first column. and the serial # will be decide by each raw, say if I have 6 raws, I need serial # from 1 to 6 in the first column. Anyone know how to add that. I really appreciate. Thanks (2 Replies)
Dear All,
i am having text file below
rama 123 done
raju 456 not done
keshav 123 done
...............
............
i want to add a serial number to this file, the output should be
1 rama 123 done
2 raju 456 not done
3 keshav 123 done
99 ...............
100 ............
... (3 Replies)
I have a unix system that only has AWK to program with which hooks up to a windows or linux based system with all progamming and software capabilities. The link between the systems is typically a 9600 baud TTY port on the AWK system and COM1 on the other system. I can cat <filenm> from the unix... (4 Replies)
Hello ppl,
I'm working on a windows program simulating an existing Unix program,
the program is a firmware downloader, it sends a binary firmware file through the serial port (rs232) to a Set-Top Box running under unix system too, as i'm a poor unix user and not a unix programmer i choosed the... (10 Replies)
i have connected with my board through serial interface using minicom and i am running a bash script, which should test ethernet (ping test), USB read/write, RS232 ..
I have managed to test ethernet and USB read/write.
I test ethernet with ping.
I test USB read/write, using dd and verifying... (10 Replies)