bash - how to find a regular expression of specific string

Question

I have a question related to a regular expression. I have a huge text file like

I want to get an output like this

 ID           DE
1.1      Transformer
1.12     Best bye
1.1.1    Iphone

so basically I want to get ID and DE

what I tried was using awk and sed but with no success. I thought I get the ID and then I get the DE and then I merge them but I still could not figure out how to do that

sed -n ID my.txt

I used -n because By default, each line of input is echoed to the standard output after all of the commands have been applied to it.

Answer 1

EDIT: As OP mentioned in case any de is empty with respective id then print an hyphen, then try following.

awk '
BEGIN{
  OFS="	"
  print "ID		DE"
}
/ID/{
  if(id){
    print id,de?de:"-"
    id=de=""
  }
  id=$2
  next
}
/DE/{
  $1=""
  sub(/^ +/,"")
  de=$0
}
END{
  if(id){
    print id,de?de:"-"
  }
}'  Input_file

---

---

Could you please try following.

awk '
BEGIN{
  OFS="	"
  print "ID		DE"
}
/ID/{
  if(id){
    print id,de
    id=de=""
  }
  id=$2
  next
}
/DE/{
  $1=""
  sub(/^ +/,"")
  de=$0
}
END{
  if(id){
    print id,de
  }
}'   Input_file