Skip to main content

Questions tagged [text-processing]

Manipulation or examining of text by programs, scripts, etc.

1 vote
3 answers
64 views

edit all the values in a specific column based on row numbers range

I have a PDB file (coordinates of atoms in a protein) on a Linux machine: ATOM 1 N GLY A 1 0.535 51.766 5.682 1.00 0.00 ATOM 2 CA GLY A 1 -0.712 50....
Paolo Lorenzini's user avatar
0 votes
5 answers
78 views

Match multiple vars across two lines and delete entire entry

MATCH1.MATCH2 { always same MATCH3 } All three MATCH(es) must match. input: foo.bar { always same bus } 1.2 { always same 3 } a.b { always same c } i.ii { always same iii } b.2 { ...
sloppy's user avatar
  • 121
4 votes
5 answers
467 views

Remove the first field (and leading spaces) with a single AWK

Consider this input and output: foo bar baz bar baz How do you achieve with a single AWK? Please explain your approach too. These are a couple tries: $ awk '{ $1 = ""; print(substr($0, 2)) ...
mbigras's user avatar
  • 3,422
1 vote
5 answers
433 views

How to remove every first duplicate line in a column from mac terminal?

A huge txt file with 360k lines. Lines needed to be deleted are duplicated in both column 1 (id) and column 2 (nick), but differ in column 3 (category). There're only 2 lines for all duplicates in ...
user729388's user avatar
0 votes
2 answers
85 views

List and count ciphers used by cryptsetup in /dev/mapper devices

In my Linux Computer there are many files called file1, file2, file3 ... in /dev/mapper/. Now I want to have an overview from the files what cipher is used how often. I tried this for i in /dev/...
user447274's user avatar
9 votes
6 answers
664 views

How to display duplicate lines with different first field

Regarding this information below: 807:Lipstick:Cosmetics:50:250 808:MixerGrinder:Electronics:10:35000 809:MixerGrinder:Electronics:10:35000 I am expecting to display this information below: 808:...
Ismael Sanchez's user avatar
0 votes
0 answers
43 views

Extracting "devname" from log message with re_extract

Can anyone help? I've exhausted my knowledge and troubleshooting skills trying to get this working. Here is the example data from "msg": date=2025-03-26 time=12:45:57 devname="this-is-...
user2008555's user avatar
1 vote
2 answers
86 views

Filter for arbitrary AND patterns [duplicate]

Consider a command which takes arguments like this: cmd foo bar baz [arbitrary args...]. How do you build a filter of AND patterns based on those arguments? Something like this pipeline of greps: grep ...
mbigras's user avatar
  • 3,422
0 votes
1 answer
89 views

Use sed to replace only part of a string

I'm trying to replace bobearl with jim in the following string "billy" "bobearl" and "johnny" I can do something like this: sed 's/bob/jim/' /tmp/text.txt "billy&...
goswell's user avatar
2 votes
5 answers
626 views

How to display and count vowels in file

I have a file with a name list as shown below: Ishmael Mark Anton Rajesh Pete I am trying to print something like this: Iae 3 a 1 Ao 2 ae 2 ee 2 I developed this code: cat names.txt | grep -Eo '...
Ismael Sanchez's user avatar
0 votes
0 answers
51 views

Advanced CLI tool/code to determine text encoding (besides enca)

Looking for advanced CLI tool/code to determine text Codepage/Language (besides enca). Goal: Automate as much as possible conversion of hundreds/thousands of 8-bit text files (including non-ASCII ...
strider's user avatar
  • 43
0 votes
2 answers
93 views

On Ubuntu 20 server, I must replace all occurances of the color #640000 with #06172A

On Ubuntu 20 server, I have to replace all occurances of the color #640000 with #06172A. I have tried the following commands to replace Go to folder where the relevant files reside: $ cd /path/to/the/...
Lars Bratt's user avatar
8 votes
5 answers
1k views

Run command on each line of CSV file, using fields in different places of the command

I have a CSV file and want to run a command for each line, using the fields of the file as separate arguments. For example given the following file: foo,42,red bar,13,blue baz,27,green I want to run ...
luator's user avatar
  • 272
4 votes
3 answers
220 views

Add columns from variable number of files to base file

I'm dealing with a series of bed files, which look like this: chr1 100 110 0.5 chr1 150 175 0.2 chr1 200 300 1.5 With the columns being chromosome, start, end, score. I have multiple different files ...
Whitehot's user avatar
  • 245
-4 votes
5 answers
127 views

Command to display all the employees whose first name have more than 6 characters

From the script below I need to know the following: EmpNo#Email#Name#JobLevel#Experience 641357#Amrit_Mohanty#Amrit Mohanty#3#2 678522#Puneet_Mishra#Puneet Mishra#3#1 670242#Vikas_Bharti#Vikas Bharti#...
Ismael Sanchez's user avatar

15 30 50 per page
1
2 3 4 5
568