change field separator only from nth field until NF
Hi !
input:
With awk, I am trying to change the FS "|" to "; " only from the 4th field until the end (the number of fields vary between records).
In order to get:
I tried something like:
It works for the 4th field, but it also prints the original fields from $5 to $NF after:
Is there any way to to create an array from $4 until $NF without knowing the number of fields (a[$4...$NF])???
Hi, All,
I wonder how to change the field separator of grep from : to space when use grep to display.
for example when I use
grep -e 'pattern1' -e 'pattern2' -n filename
to find patterns, it use : to separate patterns, but I want to use blank space. is there an option I can set to... (2 Replies)
Hello...
Im trying to use "- " as field separator...
I used awk -F"- " '{print $3}' input_file ... but it's not working, it assumes that the field separator is "-" and not "- " ...
Any ideas ?? :(
Thanks (6 Replies)
is there a similar parameter you can set in perl like FS in awk?
I think I've read all the tutorials on the subject, but cannot get this map split and so on thing to work.
I need to sort a file by columns, eg. first, third, fifth...
The script I need to add this column sorting is this:
use... (38 Replies)
Hi All,
I was wondering if anyone knew how to dynamically change the FS in awk to accept vairiable containing a field separator. the current code is as below and does not work when i introduce the dynamic FS change :-(
validate_source_file()
{
source_file=$1
... (2 Replies)
Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Hi,
I have a flat file with fields separated by a X'1F'
i have to fetch 4th field from second line.
please help me how to achieve it.
I tried with below command and its not working.
cut -f4 -d`echo -e '\x1f'` filename.txt
I am using SunOS.
Thanks in advance. (2 Replies)
Hi Experts ,
file :
- How to construct the awk filed separator so that $1, $2 $3 , can be assigned to the each "" range.
I am trying : awk -F"]" '{print $1}'
but it is printing the entire file. Not first field.
The desired output needed for first field... (9 Replies)
Using Awk, how can I achieve the following?
I have set of record numbers, for which, I have to replace the nth field with some values, say spaces.
Eg:
Set of Records : 4,9,10,55,89,etc
I have to change the 8th field of all the above set of records to spaces (10 spaces).
Its a delimited... (1 Reply)
Hello All,
I have a file, but I want to separate the file at a particular record with comma"," in the line
Input file
APPLE6SSAMSUNGS5PRICEPERPIECEDOLLAR600EACH010020340URX581949695US
to
Output file
APPLE6S,SAMSUNGS5,PRICEPERPIECE,DOLLAR600EACH,010020340URX581949695,US
This is for... (11 Replies)