I have a requirement to remove certain spaces from a table of information, but I'm unsure where to start.
A typical table will be like this:
The goal is to remove only the spaces between the artist names (where more than 1 name exists), but leave everything else the same, like this:
I can't work out how to do this as the number of columns will vary depending on how many names the artist has. To complicate matters, some artists will also have numbers in their names. The number of columns before and after the artist names will always be the same, if that helps? Please help, very stuck and can't see a way around it!
Last edited by radoulov; 02-07-2011 at 11:40 AM..
Reason: Code tags, please!
Sorry, still inconsistent results with the whole dataset. I was trying to keep things simple with a small amount, but here's a much better dataset to work with:
Last edited by radoulov; 02-07-2011 at 12:30 PM..
Reason: Code tags, please!
Hi,
I've a requirement like, in a csv file of 30+ fields where all the columns are having double quotes I need to remove the double quotes from certain fields and certain field should remain as it is.
Eg:... (6 Replies)
Hello,
I have two tab delimited text files. Both files have the same number of rows but not necessarily the same number of columns. The column headers look like,
File 1:
f0order CVorder Name f0 RI_9 E99 E199 E299 E399 E499 E599 E699 E799 E899 E999
File 2:... (9 Replies)
I have a file like:
s_20331 803 1 1 5 1:2=0.00000000 1:3=0.00000000 1:4=0.11111111
s_20331 814 1 1 5 1:2=0.00000000 1:3=0.12611607 1:4=0.00000000I would like to remove the four characters "x:x=" from all columns containing them (in my actual file, there are 15 total columns (i.e. columns... (1 Reply)
Hi guru's,
I am trying to write a script to generate a csv file by connecting to database run a query and put the values into csv file.
But the problem i face is i am getting lot of space after one value.how can i remove those values?.
Please help.
#!/bin/bash
export... (2 Replies)
Hi. I am not sure the title gives an optimal description of what I want to do.
I have several text files that contain data in many columns. All the files are organized the same way, but the data in the columns might differ. I want to count the number of times data occur in specific columns,... (0 Replies)
Hello
i have a text file like this:
1 AB AC AD EE
2 WE TR YT WW
3 AS UY RF YT
the file is bigger , but that's an example of the data
what i want to do is to merge all columns together except the first one,
it will become like this :
1 ABACADEE
2 WETRYTWW
3 ASUYRFYT (8 Replies)
If I have a data test.txt with 1000 columns such as:
id sex gene1 gene2 gene2.dl gene3 gene4 gene4.dl .......
1 1 AA AT AT TT AT AT .......
2 1 AG TT TT TA AA AA .......
3 2 AA AT AT TT AT ... (2 Replies)
Hi all,
im a linux newbie, plz help!
I have a file -
box
--------
Fox-2
--------
UF29
zip42
--------
zf-CW
SNF2_N
Heli_Z
--------
Fox
--------
Kel_1
box (3 Replies)
I have a file with only one field something like this :
213.45
220.65
240.47
345.67
320.45
I want to remove all spaces in between. Is there any unix command for that ?Thanks in advance.. (2 Replies)