linux - Bash: Read in file, edit line, output to new file -


i new linux , new scripting. working in linux environment using bash. need following things: 1. read txt file line line 2. delete first line 3. remove middle part of each line after first 4. copy changes new txt file

each line after first has 3 sections, first ends in .pdf , third begins r0 middle section has no consistency.

example of 2 lines in file:

 r01234567_high transcript_01234567.pdf  high school transcript  r01234567 r01891023_application_01891023127.pdf   application r01891023

here have far. i'm reading file, printing screen , copying file.

#! /bin/bash cd /usr/local/bin; #echo "list of files:"; #ls; index in *.txt; echo "file: ${index}"; echo "reading..." exec<${index} value=0 while read line    #value='expr ${value} +1';    echo ${line}; done echo "read done ${index}"; cp ${index} /usr/local/bin/test2; echo "file ${index} moved test2";  done

so question is, how can delete middle bit of each line, after .pdf before r0...?

updated answer assuming tab delim

since there tab delimiter, cinch awk. borrowing deleted answer , @geek1011 deleted answer:

awk -f"\t" '{print $1, $nf}' infile.txt

here awk splits each record in file tab, prints first field $1 , last field $nf nf built in awk variable record's number of fields; prepending dollar sign, says "the value of last field in record".


original answer assuming space delimiter

leaving here in case has space delimited nonsense assumed.

you can use awk instead of using bash read through file:

awk 'nr>1{for(i=1; $i!~/pdf/; ++i) firstrec=firstrec" "$i} nr>1{print firstrec,$i,$nf}' yourfile.txt

awk reads files line line , processes each record comes across. fields delimited automatically white space. first field $1, second $2 , on. awk has built in variables; here use nf number of fields contained in record, , nr record number being processed.

this script following:

  1. if record number greater 1 (not header) then
  2. loop through each field (separated white space here) until find field has "pdf" in ($i!~/pdf/). store find until field in variable called firstrec separated space (firstrec=firstrec" "$i).
  3. print out firstrec, print out whatever field stopped iterating on (the 1 contains "pdf") $i, , print out last field in record, $nf (print firstrec,$i,$nf)

you can direct file:

awk 'nr>1{for(i=1; $i!~/pdf/; ++i) firstrec=firstrec" "$i} nr>1{print firstrec,$i,$nf}' yourfile.txt > outfile.txt

sed may cleaner way of going here since, if pdf file has more 1 space separating characters, lose multiple spaces.


Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more