Search Results

Because i am having 10,000 rows and 50 columns .....not only mensioned column so many columns have to converted ....

I have to pass column no and conversion value and converted value ...as...

Hi
I have to search & replace column in the file.For example ..below iam having File1. in which 3rd column ...if it is A it should be 'ACT' if P it should be 'PAD' and if it ils D it should...

Iam confused ....
can you give me exact code please ...........

Thanks yaar . Hi it is working fine.

if iam having 5th 9th column's also having the decimal numbers like earlier the same code can use ???

below is corr

awk 'BEGIN{OFS=FS="|"}
{
...

Hi ....
Iam having the file ....in which 3rd column is numerical having 8 decimal part... i want that to cut to 2 decimal part ...

Source File :

E100|0|19940.10104030|0|1ABC...

Hi Yogesh,
I have studied ....but still iam confused ...i have written like below ....t

sort +1 +2 +3n +4 +5n this is correct ?

can u give me code ....for key columns which numeric also...

Hi ....
iam having a file with 20,000 rows and 56 colums.

Iam trying to sort a file ....for that iam using 'sort' command.
If iam having 3 and 5 key colums etc ... as numerical this 'sort'...

awk '{gsub(/^\|| +\|/,"") a\ if(NF!=6){for(i=1;i<=(6-NF);i++)printf("%s|",k[i]);print;next}{for(i=1;i<=3;i++)k[i]=$i}print}' FS='|' key.txt

awk: cmd. line:1: {gsub(/^\|| +\|/,"") a\...

We are calling Unix through SQR.
I want to know there is any operator available in Unix ...so that the remaining command should go to the next line
I will explain , find the below code . It is in...

Hi
I must pass column variables in to awk command to print in desired order and desired number of columns.File which i have given is sample example
iam printing only few columns of actual file...

we have a file File1.I have used the below code to append 'file1' to each row.it is appending 'file1' but there is 5 empty space is coming after the end of each row.i found this opening in 'vi'...

awk 'NF!=10{for(i=1;i<=(10-NF);i++)printf("%s,",k[i]);print;next}{for(i=1;i<=3;i++)k[i]=$i}1' FS=',' f1

This code is working for some what .

it is not working in case of ',' or '|'...

awk '{print "File1,"$1,$2,$3,$4,$5,$6}' Source_File> Result_File
:confused:
The code is useful ....but 'File1' is not appending . I tried many times...empty space is coming .....

...

It is not working ......
Can you please check & give exact code . ......

Iam new to unix .....

sorry ,

I got the following error :

sed: can't read s/./&,/5: No such file or directory
sed: can't read s/./&,/15: No such file or directory
sed: can't read s/./&,/16: No such file or...

Hi
I have below file with 3 rd column as date ....i want to make 3 column to mm/dd/yyyy .
in the below file 2 row date is like 1/23/1994 so i want to append '0'
to month i,e. 01/23/1994 ...

I have the below fixed file ..... and the sample code to convert csv ...last week it was working good ....to day i face error ....can you solve ...
Note : Iam passing ending positions as variables...

Thanx Franklin.

why my code is not working ????? Can u please tell me .....

sed -e 's/./&,/4' 's/./&,/5' 's/./&,/15' 's/./&,/16' 's/./&,/20' 's/./&,/24' File1.txt > delimited.csv


where...

Hi , I have the below file with 6 columns.I want to append 'File1' as the 1 column to the file. i have the sample code .It is not working . can u please correct this or make new one .....
awk...

I have below fixed lenth file . I have to convert this to delimitted file.

File1.txtE116005/29/19930E001E000
E12201/23/19940E001E003
E10406/4/19940E001E003

I want to convert this to :...