Removing string from CSV file by provide removal string from other file
What I need is to remove the text from Location_file.txt from each line matching all entries from Remove_location.txt
Location_file.txt
Remove_location.txt
The code I have tried in recessive for loop is not working properly as for each value in Remove_location.txt, first iteration removes only first entry’ h0nmg1cm1’ from file Location_file.txt but for next value ‘grndustyc42’ its considering the initial file without effect/removal of value from previous iterations. Thus output file will always have all previously cleared entries..!
So how I can push new edited file each time with removed entries from Remove_location.txt.
second part of script is Removing duplicate lines and changing , to | also making copy of all files from name of first filed of final.txt to other location.
So Out put file will be below file and copy of files from field1 of this file
final.txt:
Moderator's Comments:
Please wrap all code, files, input and output/errors in CODE tags
Last edited by rbatte1; 08-25-2017 at 11:55 AM..
Reason: Added CODE tags
Hey Folks,
I have a file that contains data that I am working with, sometimes this file has a very long string of text that messes with an awk command in a script i am trying to build. I would like to cut this string of text out of a file and then redirect everything except that string to a new... (5 Replies)
Can someone tell me how I can do this?
e.g:
Say file1.txt contains:
today is monday
the 22 of
NOVEMBER
2010
and file2.txt contains:
the
11th
month
of
How do i replace the word NOVEMBER with (5 Replies)
Hi All,
I want to remove carriage return in a file using some unix command without writing a script
my file is as follows
abc1 abc2 abc3 abc4
abc5 bac6
abc1 abc2 abc3 abc4
abc5 bac6
I want the output as follows:
abc1 abc2 abc3 abc4 abc5 bac6
abc1 abc2 abc3 abc4 abc5 bac6
,
Please... (7 Replies)
Hi ,
I have a simple text file with contents as below:
12345678900 971,76 4234560890
22345678900 5971,72 5234560990
32345678900 71,12 6234560190
the new csv-file should be like:
Column1;Column2;Column3;Column4;Column5
123456;78900;971,76;423456;0890... (9 Replies)
Dear all
From below mention input file I needed op file as show below. I am using below code but not worked.
I/p file
BSCBCH1 EXAL-1-4 WO* SMPS MAINS FAIL
BSCBCH1 EXAL-1-5 WO* SMPS RECTIFIER FAIL
BSCBCH1 EXAL-1-6 WO* SMPS MAJOR ALARM
BSCBCH2 EXAL-1-10 WO* ... (5 Replies)
So, I have a text file that looks like this:
0,0: (168,168,176) #A8A8B0 srgb(168,168,176)
1,0: (168,168,176) #A8A8B0 srgb(168,168,176)
2,0: (166,166,174) #A6A6AE srgb(166,166,174)
3,0: (166,166,174) #A6A6AE srgb(166,166,174)
4,0: (168,168,176) #A8A8B0 srgb(168,168,176)
5,0:... (0 Replies)
Hi have a comma separated file which has numeric and string columns. String columns are quoted and can have comma in between the quotes. How to identify the columns with FS =","
sample records"prabhat,kumar",19,2000,"bangalore,India"
In awk it should be$1 = prabhat,kumar
$2=19
$3=2000... (9 Replies)
Hi, all
I need your help and suggestions.
I want to print particular strings in a field of a csv file and show them in terminal. Here is an example of the csv file.
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw... (9 Replies)
Hi, all
I need your help and suggestions.
I want to print particular strings in a field of a csv file and show them in terminal. Here is an example of the csv file.
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw... (7 Replies)
Hi all,
i have a .csv file with only two columns, like:
Login;Status
Luca;S
Marco;
Stefano;
Elettra;S
Laura;
...
I need to replace the blank space on Status column whit Enabled end, on the same column, S whit Disabled, like:
Login;Status
Luca;Disabled
Marco;Enabled
Stefano;Enabled... (10 Replies)