Search Results

Thanks a lot.

I have a csv dump from sql server that needs to be converted so it can be feed to another program. I already sorted on field 1 but there are multiple columns with same field 1 where it needs to be...

any thoughts ?

Following will search the directory for specified file and do replacement at the same time.


find <type of file> | xargs perl -pi -e 's/value1/values2/g'

for instance, to find all xmls and...

try this:

find <type of file> | xargs perl -pi -e 's/value1/values2/g'

Thanks for explanation, was looking around as well why $2=$2. Also is it possible to sort further and have uniq $1 and append $4 based on different value of $2. i,e in second/third line, $2 changes...

yes, it should be fine. Basically, i am looking for three columns that can be feed back to process the file.

so from following:

ES FP,SL22 (70000)|XX22 (80000)
VIL SJ,SL22 (20000)|XX22 (20000)...

That a lot, how can i even sort on f1 again and append f2.

i.e

from

ES FP,I,SL22 (70000)|XX22 (80000)
VIL SJ,I,SL22 (20000)|XX22 (20000)
VIL SJ,N,SL22 (25040222)|XX22 (25040222)
MING...

To make it easier, i gave following example. It is not homework or classwork. Instead, i have a huge csv file dump from tsql with 15 columns and around 300 rows. I was able to extract content that...

To make it easier, i gave following example. It is not homework or classwork. Instead, i have a huge csv file dump from tsql with 15 columns and around 300 rows. I was able to extract content that...

Hi,

I have a file that needs to be converted:

content is:

a, b, 4
a ,b, 5
x, y, 1
a, b, 1
x, y, 3

how can i get:

a, b, 1|4|5

x,y 1|3