Search Results

Hallo Team

I can perform the task manually but i would like to automate this process. ok here goes. I have a perl script which runs every Wednesday every week and the name of the script is...

Thank you MadeInGermany,

fgrep -f FILEA FILEB > FILEC -- somehow this does not work

awk -F, 'NR==FNR {A[$0]; next} {for (a in A) if (index($1,a)) {print; next}}' FILEA FILEB > FILEC -- this is...

Hallo Team,

I have 2 .csv files file A has 47600 lines and file B has 67000 lines

FILEA

SD0o9rb01-1d320ddbcc8d220f572739ebed5f58d1-v300g00
SD8bt0101-a0810bfe0e3396060126ec51b30dac0a-v300g00...

Hallo Team,

I am trying to get rid of the dollar sign. I managed to remove all the other special characters but i am struggling with this one.

-bash-3.2$ cat -e...

Sea, i guess i will have to initialize $pattern right?

so should the code be like :

SRC=Sample1.txt
PARSE=BW*20141112*.csv
OUT=/home/paxk1/test.csv
PATTERN=BW

while read pattern;do
...

Hallo Team,

I need your help and its rather urgent.
I have a file with thousands of lines. Here is a sample below:

Sample1.txt

BW235045560121114833444044@196.35.130.5...

Hallo Friends,

I would like to compare two files, then write the difference between the two into output file then find a pattern then search for that pattern.

-bash-3.2$ cat...

You guys are amazing. My solution is working like clock work thank you for helping.
This is the route that i took below:

grep "Y,Unknown scenario:BST" BW*2014* > Accntfound.csv
sed -i...

The lines in each file differ. One file might have a hundred line and one file might have 800 lines.

-bash-3.2$ ll...

Hallo Team,

I have thousands of .csv files with the following naming convention BW*2014*.csv. I will attach a sample for one file. This is what i would like to do:

1. If field 12 is equal to No...

Thank you R.Singh,

You are a LEGEND.

R.Signgh ...... no luck my friend

-bash-3.2$ cat lack.csv >> `ls -ltr BW*|tail -1`
-bash: `ls -ltr BW*|tail -1`: ambiguous redirect
-bash-3.2$

Akshay thank you but its not working:

-bash-3.2$ ll -ltr BW*|tail -1 >> cat lack.csv
-bash-3.2$ grep -l lemontwistpax BW*2014*
-bash-3.2$ cat lack.csv
lemontwistpax
-bash-3.2$ grep...

Hallo Team,

I would like to redirect an output from a file into another file. Here are the two commands/files.

-bash-3.2$ cat lack.csv
lemontwistpax
-bash-3.2$ ll -ltr BW*|tail -1
-rw-r--r--...

R.Singh........you are a rockster.

Hallo Team,

I would like to replace filed 4 and 7 with filed 39 how can i achieve this ?

-bash-3.2$ cat dip1.csv| cut -f4,7,24,36,39 -d","|sort -u...

)(*&^% blond moment. Thanx Kamaraj

---------- Post updated at 04:12 PM ---------- Previous update was at 04:00 PM ----------

i celebrated too soon. Corona please explain how can this be...

Hallo Team,

I have thousands of lines and i would like to manilpute a pattern but i am getting an error:

File lo0ks like below:
...

Hallo Team,

I need you you help. I need to sum up all the columns in a .csv file. Lets call the file file1.csv and it looks like below:

[mind@util1-pkl MHG_201408]$ cat file1.csv...

but how do i make sure that only field 24 is changed?

Hallo Team,

I would like to change everything on field 24 that starts with

10.0.108.* to be 10.0.108.11


-bash-3.2$ cat pax1.csv|cut -f24 -d","|sort -u
10.0.108.11
10.0.108.11100...

Chubler thats awesome brother.

I am sorry i have a question on top of what i asked.
i have another file called max3.csv and looks like below:
[mind@util1-pkl MHG_201408]$ cat max3.csv...

Thank you RudiC,

How ever the time format is important. Is there a way we can keep it in the desired format hhhh:mm:ss ?

Thanking you for all the hard work and dedication.

Regards,

Pax...

I re posted a new post which is clearer.

Hallo Team,

I hope my explanation is clear. Please assist if you can.

max1.csv
AccountCode,AccountName,TotalCalls,TotalCallDuration,TotalCost,TotalTelkomAsIf
485554,MHG - Polmed -...