Author Topic: Transpose text in rows into two columns (Notepad++, Excel, ASAP Utilities)  (Read 801 times)

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: 658859
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
Re: Convert TXT to Xslx ,tow columns
« Reply #1 on: 09 May, 2018, 20:17:16 »


http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=123&utilities=117&lang=en_us

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
« Last Edit: 14 May, 2018, 17:17:44 by spiros »

drkhateeb

  • Newbie
  • *
  • Posts: 31
  • Gender: Male
Dear spiros
Thank you very much for this great reply .