Replace comma by space for specified field in record
Hi,
i want to replace comma by space for specified field in record, i mean i want to replace the commas in the 4th field by space. and rest all is same throught the record.
the record is
here i want to replace "RIMOUSKI, QC" by "RIMOUSKI QC" and for all the records of the file in the 4th position.
i can do it for file using
but how can i do it only for 4th field ?
Last edited by Franklin52; 04-19-2010 at 06:44 AM..
Reason: Please use code tags!
Hi, what is the better way to replace the , (comma) with a space char? Example:STRING=dir1,dir2,dir3 toSTRING=dir1 dir2 dir3 And.. how to find if in the string there is a comma?
Thanks :) (6 Replies)
Hello,
I have the following xml formatted file. I would like to get the newnumber field number and replace into customernumber for each record.
For example:
<XMLFORMAT>
<customernumberR11>9</customernumberR11>
... (12 Replies)
Hi ,
How to replace all entries of comma in text file by space or other character.
cat temp.txt
A,B,C,D
I want this file to be like
A B C D
Please help!!! (4 Replies)
Hi,
I am new to unix and am trying to do something below:
I have a pipe delimited file with millions of records. I need to replace the third column of the first record to the number of lines in the file. How can I do that.
Will appreciate any advice and help.
Thanks
Simi (3 Replies)
arr_Ent_NameId variable holds 'Prakash pawar' 'sag' '23' '50000' this value
'Prakash pawar' 'sag' '23' '50000' I want to replace space( ) with comma (,)
There are 4 fields here. I don't want to replace first field with comma.
output should be: 'Prakash,pawar','sag','23','50000'
... (2 Replies)
Hello everyone,
I want to replace all "," (commas) with a blank space
My command thus far is:
cat test.text | sed -e s/\`//g | awk '{print$1" "$2" "$3}'
I'm sure you guys know this, but the SED command that I am using is to get rid of the "`" (tics).
which gives me:
name ... (5 Replies)
how to replace the 3rd colum? Each line begins similarly, but they all ends variously.
XX YY 03 variable text here
XX YY 03 more variable text here
XX YY 03 even more variable text here really long setence
XX YY 03 variable numbers also appear 03 11. 123 456
XX YY 03 the occasional comma,... (4 Replies)
Hello Group,
I need to replace the city field in “File 1 (fileld 3), with the entire record line of “File 2” (including delimiters) where the “city” field (File 1, Field 3)matches city field (File 2, Field1). All of the other data in “File 1” should remain intact(Fields 1,2,4,5,6). Only field... (1 Reply)
I have the content of this file that i would like to replace the space by comma.
The file content values in this format
FName LName Date & time
------------------------------------
Gilles John 14/12/17 12:30:45
I want this format
Fname,LName,Date&time... (7 Replies)
Each record coming with column names. I have to replace them in each record as shown below
TIME=20181219110000261|CHAN=FMBKHJBAAAADPCFNAAAAAABA|EVNT=SWIclst|VALU=Session FMBKHJBAAAADPCFNAAAAAABA started|SRC=NSS|UCPU=0|SCPU=0
Output should look like: ... (9 Replies)
Discussion started by: sudhakar1987
9 Replies
LEARN ABOUT DEBIAN
px_put_data_bcd
PX_PUT_DATA_BCD(3) Library Functions Manual PX_PUT_DATA_BCD(3)NAME
PX_put_data_bcd -- Put value into a bcd data field
SYNOPSIS
#include <paradox.h>
void PX_put_data_bcd(pxdoc_t *pxdoc, char *data, int len, char *value)
DESCRIPTION
Converts a bcd string into a value for a data field as it stored in the database file. The string may only contain the charcters `+', `-',
`0-9', and `.'. You should use this function instead of accessing the record data directly.
data points to the start of the data field in the record. It must be calculated by summing up all field length before the field to operate
on and add it to the base pointer of the record.
SEE ALSO PX_put_data_alpha(3), PX_put_data_long(3), PX_put_data_double(3), PX_put_data_short(3), PX_put_data_byte(3), PX_put_data_bytes(3)AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx.
PX_PUT_DATA_BCD(3)