Translation - Μετάφραση

Resources, Technical Assistance and Technology News => Translator resources => General technical issues => Topic started by: drkhateeb on 09 May, 2018, 20:01:07

Title: Transpose text in rows into two columns (Notepad++, Excel, ASAP Utilities)
Post by: drkhateeb on 09 May, 2018, 20:01:07
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

Title: Re: Convert TXT to Xslx ,tow columns
Post by: spiros on 09 May, 2018, 20:17:16
https://youtu.be/nmKVCEweyyk

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
Title: Re: Transpose text in rows into two columns (Notepad++, Excel, ASAP Utilities)
Post by: drkhateeb on 10 May, 2018, 14:00:18
Dear spiros
Thank you very much for this great reply .