10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
2. Windows & DOS: Issues & Discussions
I have a requirement to parse a dataflex .txt file and break it into separate files within the Windows server env. Is there any special characters I should pay particular attention on the unix side? Any ideas?
Thanks in advance (2 Replies)
Discussion started by: kicklinr
2 Replies
3. Shell Programming and Scripting
Hi All
I need help to separate entries after commas in my
I have 2 columns in my file like this
Ramush, Shyam, Mohan First
Ram, Mohan, Kaavya Second, Fourth
Kavi, Ram, Shaym, Mohan Third
I ahve to separate entries after comma in a separate row... (9 Replies)
Discussion started by: kareena
9 Replies
4. Shell Programming and Scripting
Hi all
This time my input conatin 3 columns:
ERCC1 (PA155) Platinum compounds (PA164713176) Allele A is not associated with response to Platinum compounds in women with Ovarian Neoplasms as compared to allele C .
CES1 (PA107) methylphenidate (PA450464) Genotype CT is not... (4 Replies)
Discussion started by: Priyanka Chopra
4 Replies
5. Shell Programming and Scripting
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies
6. Shell Programming and Scripting
Hello All
Can anyone please guide me how to solve the issue
In the below code I am getting concat of two value in result variable with comma separated
result=`sqlplus -s / <<EOF
set pages 0 feed off;
set feedback off;
spool abc.txt
select... (4 Replies)
Discussion started by: Pratik4891
4 Replies
7. Shell Programming and Scripting
Hi guys
I have two file which I sdiff.
ie
file 1: AA,12,34,56,,789,101,,6666
file 2: AA,12,34,56,,789,101,,7777
The last comma separated value will always change from one day to the next.
Is there another unix utility I can use that will sdiff two files but ignore the last comma... (1 Reply)
Discussion started by: wny201
1 Replies
8. UNIX for Advanced & Expert Users
Hi All,
Could some one help me on one of my requirement below:
I have a sequential file with 4fields in it and it is a comma (,) seperated file.
Delimeter is 'comma'.
But in of the file column for ex: 3rd column it is 'Description' (column name) I am getting the values with commas.... (6 Replies)
Discussion started by: eskay_s
6 Replies
9. UNIX Desktop Questions & Answers
I would like to copy 2 parts of a csv file from Unix to an XL sheet. However to save time I do not want to format the column ever time I cut and paste into XL(Text2Column). I've used awk -F, '{Print $1, $2....}'. Is there a script or code that can automatically format the csv for XL columns?
... (3 Replies)
Discussion started by: ravzter
3 Replies
10. Shell Programming and Scripting
hi experts,
i have some problem with count data which separate by comma, below sample data :
01,011222823b6d,011222823f29,0028a5,002993,6212345678,
659111111111,6598204507,6281105008,6596197849,_,525016160836958,_,
ffffffff,000000000000000000000000,_,_,_,fd,fd,ff,00,1,0028a5-002993,_,... (10 Replies)
Discussion started by: bucci
10 Replies