I have Excel file with the below three columns, i need your expertise in converting this to .csv file delimiter "|"
Excel -
Reuested this to converted to .csv file with delimiter "|" and for the column Serial name.. if any of the records having serial number with Serial name, the serial number should be ignored... and the desired csv file should be like below
Last edited by Corona688; 12-20-2018 at 01:06 PM..
Reason: Code tags for code please
When I create filesystems in AIX i often get confused(using smit)
When you specify size in aix, it is asked like this
SIZE of file system (in 512-byte blocks)
I never seem to grasp this, what is the equation to get say
500mb? Or is there a program anyone knows of that does this, like a... (1 Reply)
Hello,
I transferred some .txt files from windows to Unix. When i used the editor in Unix to open up the file, all the <cr> show up. How to I get rid of all of them? (4 Replies)
I want to convert string into uppercase string. How can i do that ? Ex: Enter the user name:
read name
show=upper(name)
echo $show --- This output should be the uppercase output.
Thanks (3 Replies)
I use Sco_Sv 3.2v5.0.5 with parellel conection using dump terminals and i want to convert them to desktop pc.
Anybody knows what hardware and other thing that would be involved? (3 Replies)
Hi - I have seen some similar posts but I am a bit stumped here
below is the first line of a 'od -c filename' command. I want to change the \0 to \n
0000000 l s \0 c d - \0 c d . . \0 l s
I have tried a sed construct in a script.........
sed... (2 Replies)
Hi all,
I have never written a script so I guess you could say I am very yellow.:) However, I could use some help.... I need to write a Korn Shell Script that converts coins. Meaning if I print or echo "Please enter amount:" and the user puts in 3.87, I need to know the least amount of coins... (11 Replies)
I have a file that ends with a ctlU:
> cat -v test.file
blah,blah,blah,GEAEA*1*xx0000111xxx^UIEA*xxx0^U
would like to replace the ctlU (^U) with a "\12"...due to printers or something.
I believe I might be able to utilize the tr command, if I could only identify the correct... (4 Replies)
So i have been asked to write a script for a friend who has a server running solaris 11. My problem is the correct syntax i can't seem to get it work with the follow code, i have read through the date man page and found no work around
Below is the code for part of the rsync script.
The code i... (2 Replies)
I have a set of values separated by a tab
ch:12 1 3 4
ch:13 3 3 4
ch:25 1 8
ch:23 2 8 1
There is a missing value in the third column and i would like replace it with
NA such that the final output would look like
ch:12 1 3 ... (7 Replies)
Discussion started by: johnkim0806
7 Replies
LEARN ABOUT FREEBSD
uplcom
UPLCOM(4) BSD Kernel Interfaces Manual UPLCOM(4)NAME
uplcom -- USB support for Prolific PL-2303/2303X/2303HX serial adapters driver
SYNOPSIS
To compile this driver into the kernel, place the following lines in your kernel configuration file:
device usb
device ucom
device uplcom
Alternatively, to load the driver as a module at boot time, place the following line in loader.conf(5):
uplcom_load="YES"
DESCRIPTION
The uplcom driver provides support for various serial adapters based on the Prolific PL-2303, PL-2303X and PL-2303HX USB-to-RS232 Bridge
chips.
The device is accessed through the ucom(4) driver which makes it behave like a tty(4).
HARDWARE
The uplcom driver supports the following devices and adapters:
o ADLINK ND-6530 USB-Serial Adapter
o Alcatel One Touch 535/735 Phone
o Alcor AU9720 USB-RS232 Serial Adapter
o AlDiga AL-11U Modem
o Alltronix ACM003U00 Modem
o Anchor Serial adapter
o ATEN UC-232A
o BAFO BF-800 and BF-810
o Belkin F5U257
o BenQ S81 Phone
o Corega CG-USBRS232R Serial Adapter
o Cressi Edy (Seiko) Diving Computer
o ELECOM UC-SGT Serial Adapter
o HAL Corporation Crossam2+USB IR commander
o Hama USB RS-232 Serial Adapter
o Hamlet exagerate XURS232
o HP LD220 Point-Of-Sale (POS) Display
o IOGEAR UC-232A
o I/O DATA USB-RSAQ, USB-RSAQ2, USB-RSAQ3 and USB-RSAQ5
o iTegno WM1080A GSM/GFPRS Modem
o iTegno WM2080A CDMA Modem
o Leadtek 9531 GPS
o Micromax 610U Modem
o Microsoft Palm 700WX
o Mobile Action MA-620 Infrared Adapter
o Motorola Cables
o Nokia CA-42 Cable
o OTI DKU-5 cable
o Panasonic TY-TP50P6-S flat screen
o PLX CA-42 Phone Cable
o PLANEX USB-RS232 URS-03
o Prolific Generic USB-Serial Adapters
o Prolific Pharos USB-Serial Adapter
o RATOC REX-USB60
o Radio Shack USB Serial Cable
o Sagem USB-Serial Adapter
o Samsung I330 Phone Cradle
o Sandberg USB to Serial Link (model number 133-08)
o Sanwa KB-USB2 Multimeter cable
o Siemens/BenQ EF81, SX1, X65 and X75 Mobile Phones
o Sitecom USB-Serial Adapter
o SMART Technologies USB-Serial Adapter
o Sony QN3 Phone Cable
o Sony Ericsson Datapilot
o Sony Ericsson DCU-10 and DCU-11 (Susteen) USB Cables
o SOURCENEXT KeikaiDenwa 8 (with and without charger)
o Speed Dragon USB-Serial Cable
o Syntech CPT-8001C Barcode Scanner
o TDK UHA6400 and UPA9664 USB-PHS Adapters
o TRENDnet USB to Serial Converter (TU-S9)
o Tripp-Lite U209-000-R USB-Serial Adapter
o UIC HCR331 Magnetic Stripe Card Reader
o UIC MSR206 Magnetic Stripe Card Reader
o Willcom W-SIM DD PHS terminal.(WS002IN)
o YC-Cable USB-Serial Adapter
o Zeagle N2iTion3 Diving Computer
SEE ALSO tty(4), ucom(4), usb(4)HISTORY
The uplcom driver appeared in NetBSD 1.6. This manual page was adopted from NetBSD by Tom Rhodes <trhodes@FreeBSD.org> in April 2002.
BSD July 25, 2012 BSD