Substituting comma "," for dot "." in a specific column when comma"," is a delimiter
Hi,
I'm dealing with an issue and losing a lot of hours figuring out how i would solve this.
I have an input file which looks like this:
Code:
('BLABLA +200-GRS','Serviço ','TarifaçãoServiço','wap.bla.us.0000000121',2985,0,55,' de conversão em escada','Dia','Domingos')
('BLABLA +200-GRR','Serviço ','TarifaçãoServiço','wap.bla.us.0000000121',2985,0,55,' de conversão em escada','Reduzido','Sábados')
('BLABLA 45-GPR','Serviço ','TarifaçãoServiço','canais.bla.us.0000000222',3073,0,' de conversão de diferença','Noite','Sábados')
('BLABLA 45-GPR','Serviço ','TarifaçãoServiço','canais.bla.us.0000000222',3073,0,' de conversão de diferença','Noite','Segunda - Sexta')
('BLABLA 35-GMS','Serviço','TarifaçãoServiço','VC3 XXXX YYY-Fixo TIM(on)',3121,1,21,' de conversão em escada','Noite','Segunda - Sexta')
('BLABLA-GRN','Serviço','TarifaçãoServiço','Chamadas',1362,1,961,' de conversão em escada','Noite','Segunda - Sexta')
('BLABLA-GPE','Serviço','TarifaçãoServiço','Chamadas',1362,1,9897,' de conversão em escada','Dia Todo','Domingos')
So, sometimes i have 9 columns (if using comma delimiter) (lines 3 and 4) and sometimes i have 10 columns (lines 1,2,5,6,7)
I'd like to replace only this column, which is a number (decimal or not), for a dot... it will look like this:
0.55 0.55 0
0
1.21
1.961
1.9897
So, my final result should be like this:
Code:
('BLABLA +200-GRS','Serviço ','TarifaçãoServiço','wap.bla.us.0000000121',2985,0.55,' de conversão em escada','Dia','Domingos')
('BLABLA +200-GRR','Serviço ','TarifaçãoServiço','wap.bla.us.0000000121',2985,0.55,' de conversão em escada','Reduzido','Sábados')
('BLABLA 45-GPR','Serviço ','TarifaçãoServiço','canais.bla.us.0000000222',3073,0,' de conversão de diferença','Noite','Sábados')
('BLABLA 45-GPR','Serviço ','TarifaçãoServiço','canais.bla.us.0000000222',3073,0,' de conversão de diferença','Noite','Segunda - Sexta')
('BLABLA 35-GMS','Serviço','TarifaçãoServiço','VC3 XXXX YYY-Fixo TIM(on)',3121,1.21,' de conversão em escada','Noite','Segunda - Sexta')
('BLABLA-GRN','Serviço','TarifaçãoServiço','Chamadas',1362,1.961,' de conversão em escada','Noite','Segunda - Sexta')
('BLABLA-GPE','Serviço','TarifaçãoServiço','Chamadas',1362,1.9897,' de conversão em escada','Dia Todo','Domingos')
Any ideas of how should i do this?
I have one, which will not be very effective... and this file contains more than 16million lines
Thanks
Last edited by joeyg; 06-05-2012 at 12:07 PM..
Reason: Please wrap data and commands with CodeTags
Hi Friends,
Can any of you explain me about the below line of code?
mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`
Im not able to understand, what exactly it is doing :confused:
Any help would be useful for me.
Lokesha (4 Replies)
Hi All,
I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations:
1. I am restrained to 2 input files only.
2. Only the "matched" fields are written out to the "matched" output file and... (1 Reply)
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
logs:
"/home/abc/public_html/index.php"
"/home/abc/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
how to use "cut" or "awk" or "sed" to get the following result:
abc
abc
xyz
xyz
xyz (8 Replies)
The system don't boot.
on the screen appears following:
press enter to maintenance (or type CTRL-D to continue)...I checked with format command.
... the slices "0-root","1-swap","2-backup" exist.
...the slises "3-var","6-usr" -unassigned. :( (16 Replies)
Hello.
Following recommendations for one of my threads, this is working perfectly :
#!/bin/bash
CNT=$( grep -c -e "some text 1" -e "some text 2" -e "some text 3" "/tmp/log_file.txt" )
Now I need a grep success for some thing like :
#!/bin/bash
CNT=$( grep -c -e "some text_1... (4 Replies)
How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address
and column 3 contains “cc” e-mail address to include with same email.
Sample input file, email.txt
Below is an sample code where... (2 Replies)
Hello.
System : opensuse leap 42.3
I have a bash script that build a text file.
I would like the last command doing :
print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt
where :
print_cmd ::= some printing... (1 Reply)
Hi 2 all,
i have had AIX 7.2
:/# /usr/IBMAHS/bin/apachectl -v
Server version: Apache/2.4.12 (Unix)
Server built: May 25 2015 04:58:27
:/#:/# /usr/IBMAHS/bin/apachectl -M
Loaded Modules:
core_module (static)
so_module (static)
http_module (static)
mpm_worker_module (static)
... (3 Replies)
Discussion started by: penchev
3 Replies
LEARN ABOUT DEBIAN
merge_fonts
merge_fonts(3alleg4) Allegro manual merge_fonts(3alleg4)NAME
merge_fonts - Merges two fonts into one font. Allegro game programming library.
SYNOPSIS
#include <allegro.h>
FONT *merge_fonts(FONT *f1, FONT *f2)
DESCRIPTION
This function merges the character ranges from two fonts and returns a new font containing all characters in the old fonts. In general, you
cannot merge fonts of different types (eg, TrueType fonts and bitmapped fonts), but as a special case, this function can promote a mono-
chrome bitmapped font to a color font and merge those. Example:
FONT *myfont;
FONT *myfancy_font;
FONT *lower_range;
FONT *upper_range;
FONT *capitals;
FONT *combined_font;
FONT *tempfont;
...
/* Create a font that contains the capitals from */
/* the fancy font but other characters from myfont */
lower_range = extract_font_range(myfont, -1, 'A'-1);
upper_range = extract_font_range(myfont, 'Z'+1, -1);
capitals = extract_font_range(myfancy_font, 'A', 'Z');
tempfont = merge_fonts(lower_range, capitals);
combined_font = merge_fonts(tempfont, upper_range);
/* Clean up temporary fonts */
destroy_font(lower_range);
destroy_font(upper_range);
destroy_font(capitals);
destroy_font(tempfont);
RETURN VALUE
Returns a pointer to the new font or NULL on error. Remember that you are responsible for destroying the font when you are finished with it
to avoid memory leaks.
SEE ALSO extract_font_range(3alleg4), is_trans_font(3alleg4), is_color_font(3alleg4), is_mono_font(3alleg4), exfont(3alleg4)Allegro version 4.4.2 merge_fonts(3alleg4)
06-05-2012
