Search Results

Hi,

I want to insert the text 'Unknown' in 2 specific columns in a csv file (actually | separated) if the column is blank. Its always the same columns.

I have tried using sed: sed...

Excellent..:b:

Thanks..works a treat

Excellent.

Thanks

Thanks. that works if the column is 3 digits only. One issue

$1 is 15 digits in lenght and the 15 digit number is generally different in each row.
e.g. 405030001534176

but its only the 405...

I don't understand the question?

I want to add into the awk statement a check to see what $1 begins with to decide whether to output a 1 or a 3 in column 3.

Hi,

I want to insert columns into a file. Some are standard (e.g. 1) and some are dependent on the contents on other columns. I am using the following code

In the below the first 1 (after $2),...

Ok...Here is some sample data

405038002621334|918602232979||59.161.255.135|59.161.255.67|INTERNET|402|40128|1|1|05/01/2011 00:02:30...

Hi,

This looks great. I do get an error when I run it:
> ./script.pl < test.csv
Month '-1' out of range 0..11 at ./script.pl line 13

If I change m-1 to be just m in line 13 I get an error...

Works great

Thanks for all the replies

Works a treat..

Thanks for all the replies

Sure

Input:
|402|40128|1|1 |401|40128|1|1
|403|40199|1|1 |404|40211|1|1

Output required:
|402|128|1|1 |401|128|1|1
|403|199|1|1 |404|211|1|1

Thanks

Thanks for the reply. That seems to replace every occurrence of 40 in the row.
I want to change the 40128 to 128 like it does but leave the 401 or 402 (or 403 or 404)

|402|40128|1|1...

Hi

I want to remove the first row in a list of files and am trying to do via the following.
I've tried various quotes to redirect the modifed file to a newly named version of itself but no joy....

Hi,

How do I run multiple sed on a file similar to the below in one command?
I can't global substitute the 401 as it can occur elsewhere in the row and needs to
be maintained if it does.
sed ...

I just saw that with the split which means I have to fix up each file and probably loose a row.
Is there a better way to split so I get full rows. How difficult is it to split the file based on the...

Thanks for the reply.

I am working on AIX 5.3 with ksh. I will try that code.

With regard to split. There is a timestamp in each row of the file but I don't necessarily need to split the file...

Hi,

I have a number of large files (up to 4GB) that I wish to split in 96 parts e.g. one for each 15 minutes of the day. The split can be random so I am using

split -b 42M filename.csv

I...