Search Results

Hi,

Could you please help me in removal of newline chracter present in between the double quotes and replacing it with space.

For example ...

Every field is wrapped with double quotes...

Follwoing is the error while running the below script

awk -F\" '$6==99999999{$6=""}1' OFS=\" Test.csv

awk: syntax error near line 1
awk: bailing out near line 1

Could you please help in unix scripting for below scenario...

In my input file, there might be a chance of having a string ( Ex:"99999") after 5th double quote for each record. I need to replace...

I'm trying to replace a string "99999999'" with the blank where ever is there in the file. Could you please help in unix scripting.

Thank You.

tyler_durden...

It contains a double quote (") at 8th position.

Hi Experts...

I am trying to find out separting the records which are staring with double quote(") and a six digit number(ex: 012456,987654,etc) from a file.

For example :

Source File :
...

i have tried with the following script....

sed -n '/^$/q;p' inputfile

for writing a new file till it finds the empty record....

But...now i am trying to write a code for deleting the last 7...

can you please give shell script for daleting the last 7 records of file...

It is working ...Thankyou!

Jean-Pierre...

sed code is working fine but, It is not deleting the empty record which is next to last main record.

jean-Pierre...

Following error is coming...

awk: syntax error near line 1
awk: bailing out near line 1

ryandegreat25..

I am not sure wether each record will start with " and a number....

But, I am sure , after the main records are over, there will be an empty record/s....form there onwards, ...

In my actual file, there wouldn't be any name called "MainRecord" or "Footer" ...for understanding purpose I have given previously...Here you can fine the replica of the actual file....
...

Hi,

I have file with footer (5records) at end of the file. I want to delete the footer as well as the empty records between the main records and footer record.(The gap between main records and...

It is working fine.....

Thankyou!!!

Hi radoulov/quintet,

Above script is working fine but when ever it finds second and third souble quotes, in between these quotes what ever the commas(,) present are replacing with Tilde (~).
But...

Panyam...

The script is working but as It is working for only one set of double quotes in one record....If it finds second second set of double quotes in the same record , it is ignoring the first...

Hi Experts,

I have a file with some of the records contain double quotes. If I found a double quote(") in any particular record , I need to look for the next double quote in that particular...

Hi Experts,

I have a file with some of records contain double quotes ("). I need to write these records in separate file and have to delete the same records from the original file.

For...