Transpose text in rows into two columns (Notepad++, Excel, ASAP Utilities)

drkhateeb

  • Newbie
  • *
    • Posts: 31
    • Gender:Male
Hi all
 How can I convert a text file with this format :

Code: [Select]
Accelerated cargo
شحنة مستعجلة<br>


 Accommodation note
سند مجاملة أذني<br>


 Aggregate figures
بيانات إجمالية<br>


 All time low
هبوط بلا مقدمات<br>

convert it to TAB delimited like

Code: [Select]
Accelerated cargo شحنة مستعجلة<br>


 Accommodation note سند مجاملة أذني<br>


 Aggregate figures بيانات إجمالية<br>


 All time low هبوط بلا مقدمات<br>

in order to open it in Excl , tow columns ,TAB delimited

how to do that in EmEditor or NotePAd++

Best Regards

« Last Edit: 09 May, 2018, 20:41:20 by spiros »


spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 834388
    • Gender:Male
  • point d’amour


ASAP Utilities for Excel - Format » Transpose column in multiple steps... - ASAP Utilities, description of our Excel tools (English)

Or in Notepad++ (with regular expressions selected)

Find: \n\n
Replace: \n
(Repeat a few times so that there are no empty rows)

And then (with regular expressions selected)

Find: ^(.*)\R(.*)
Replace: $1\t$2

Or in Emeditor or other programs
Find: ^(.*)\n(.*)
Replace: \1\t\2
« Last Edit: 29 Jan, 2022, 09:40:05 by spiros »



drkhateeb

  • Newbie
  • *
    • Posts: 31
    • Gender:Male

 

Search Tools