Forum Replies Created
- AuthorPosts
- DavidParticipant
Hello Yutaka, Thanks for your feedback. It works!
Dear Patrick, also thanks to you.
DavidParticipantHello,Mr KT! Your macro works very well on my computer. Thank you!
DavidParticipantYes, I means “shuffle lines randomly”. I know a tool “Sublime Text” has this function.
August 29, 2018 at 8:17 am in reply to: Question of Regular Expression for matching multi-row #23636DavidParticipantMr KT. It works very well. A lot Thanks!
DavidParticipantHello, Stefan,
The original file looks like the following format:<?xml version="1.0" encoding="utf-8" ?> <partsmanagement count="1" length-unit="mm" weight-unit="kg" type="PartsManagement" build="136.22" database="part001.mdb"> <part P_ARTICLE_PARTTYPE="1" P_ARTICLE_PARTNR="FES.543861" P_ARTICLE_CAN_BE_LINED_UP="0" P_ARTICLE_CERTIFICATE_CE="0" P_ARTICLE_CRAFT_COOLING="0" P_ARTICLE_CRAFT_COOLINGLUBRICANT="0" P_ARTICLE_CRAFT_ELECTRICAL="1" P_ARTICLE_CRAFT_FLUID="0" P_ARTICLE_CRAFT_FLUID_UNDEFINED="0" P_ARTICLE_CRAFT_GASTECHNOLOGY="0" P_ARTICLE_CRAFT_HYDRAULICS="0" P_ARTICLE_CRAFT_LUBRICATION="0" P_ARTICLE_CRAFT_MECHANICS="0" P_ARTICLE_CRAFT_PNEUMATICS="0" P_ARTICLE_CRAFT_PROCESS="0" P_PART_CREATE="fstn / 25.06.2014 09:42:45" P_ARTICLE_DEPTH="0" P_ARTICLE_SPACING_FRONT="0" P_ARTICLE_SPACING_REAR="0" P_ARTICLE_DESCR1="cs_CZ@čidlo;de_DE@Näherungsschalter;en_US@Proximity Sensor;es_ES@Sensor de proximidad;fr_FR@Capteur de proximité;hr_HR@Beskontaktni prekidač;hu_HU@Közelítéskapcsoló;it_IT@Sensore di finecorsa;ja_JP@近接スイッチ;ko_KR@근접 센서;lt_LT@Priartėjimo jutiklis;lv_LV@Tuvuma devējs;nl_NL@Naderingsschakelaar;pl_PL@Czujnik zbliżeniowy;pt_PT@Sensor de proximidade;ru_RU@Датчик положения;sk_SK@bezdotykový spínač;sl_SI@Mejno stikalo;tr_TR@Yaklasim sensörü;zh_CN@接近开关;zh_TW@近接感測器;sv_SE@Induktiv givare;da_DK@Cylindersensor;pt_BR@Sensor de proximidade;" P_ARTICLE_DESCR3="de_DE@00991619;en_US@00991619;es_ES@00991619;fr_FR@00991619;nl_NL@00991619;sv_SE@00991619;da_DK@00991619;ru_RU@00991619;zh_CN@00991619;pl_PL@00991619;pt_BR@00991619;cs_CZ@00991619;it_IT@00991619;hu_HU@00991619;pt_PT@00991619;ko_KR@00991619;ja_JP@00991619;lt_LT@00991619;lv_LV@00991619;sk_SK@00991619;sl_SI@00991619;tr_TR@00991619;hr_HR@00991619;zh_TW@00991619;" P_ARTICLE_DISCONTINUED="0" P_ARTICLE_DISCOUNT="0" P_ARTICLE_EXTERNAL_DOCUMENT_1="http://www.festo.com/catalogue/543861 cs_CZ@Katalog výrobků;de_DE@Produktkatalog;en_US@Product Catalogue;es_ES@Catálogo de productos;fr_FR@le catalogue produit;hr_HR@Katalog proizvoda;hu_HU@Gyártmánykatalógus;it_IT@Catalogo prodotti;ja_JP@製品カタログ;ko_KR@제품 카탈로그;lt_LT@Produktų katalogas;lv_LV@Produktu katalogs;nl_NL@Productcatalogus;pl_PL@Katalog produktów;pt_PT@Catálogo Eletrônico;ru_RU@Каталог продукции;sk_SK@Katalóg produktov;sl_SI@Katalog izdelkov;tr_TR@Ürün Kataloğu;zh_CN@产品样本;zh_TW@產品型錄;sv_SE@Produktkatalog;da_DK@Produktkatalog;" P_ARTICLE_EXTERNAL_DOCUMENT_2="http://www.festo.com/accessory/543861 cs_CZ@příslušenství;de_DE@Zubehör;en_US@Accessories;es_ES@Accesorios;fr_FR@Accessoires;hr_HR@Pribor;hu_HU@Tartozék;it_IT@Accessori;ja_JP@アクセサリ;ko_KR@액세서리;lt_LT@Priedai;lv_LV@Piederumi;nl_NL@Accessoires;pl_PL@Osprzęt;pt_PT@Acessórios;ru_RU@Принадлежности;sk_SK@príslušenstvo;sl_SI@Pribor;tr_TR@Aksesuarlar;zh_CN@辅件;zh_TW@配件;sv_SE@Tillbehör;da_DK@Tilbehør;pt_BR@Acessórios;" P_ARTICLE_EXTERNAL_DOCUMENT_3="http://www.festo.com/net/SupportPortal/start.aspx?q=543861 cs_CZ@katalog náhradních dílů;de_DE@Ersatzteilkatalog;en_US@Spare parts catalogue;es_ES@Catálogo de repuestos;fr_FR@Catalogue des pièces de rechange;hr_HR@Katalog zamjenskih dijelova;hu_HU@Pótalkatrész katalógus;it_IT@Catalogo parti di ricambio;ja_JP@スペアパーツカタログ;ko_KR@교체 부품 카탈로그;lt_LT@Atsarginių dalių katalogas;lv_LV@Rezerves daļu katalogs;nl_NL@Wisselstukkencatalogus;pl_PL@Katalog części zamiennych;pt_PT@Catálogo de peças de reposição;ru_RU@Каталог запасных частей;sk_SK@Katalóg náhradných dielov;sl_SI@Katalog nadomestnih delov;tr_TR@Yedek parça kataloğu;zh_CN@备件样本;zh_TW@零件型錄;" P_ARTICLE_EXTERNAL_PLACEMENT="0" P_ARTICLE_GROUPNUMBER="E-P-SEN" P_ARTICLE_GROUPSYMBOLMACRO="$(MD_MACROS)\FESTO\0099xx\V1_00991619.ems" P_ARTICLE_HEIGHT="0" P_ARTICLE_SPACING_ABOVE="0" P_ARTICLE_SPACING_BELOW="0" P_ARTICLE_INSTALLATION_DEPTH="0" P_ARTICLE_IS_ACCESSORY="0" P_PART_LASTCHANGE="EPL / 16.06.2016 13:45:09" P_ARTICLE_MANUFACTURER="FES" P_ARTICLE_MOUNTINGSITE="0" P_ARTICLE_MOUNTINGSPACE="0" P_ARTICLE_NOTE="cs_CZ@spínaný výstup: s kontaktem, bipolární funkce spínaného prvku: spínač rozsah provozního napětí DC: 5 ... 30 V elektrické připojení: kabel s konektorem M8x1 3 piny otočný závit ;de_DE@Schaltausgang: kontaktbehaftet bipolar Schaltelementfunktion: Schließer Betriebsspannungsbereich DC: 5 ... 30 V Elektrischer Anschluss: Kabel mit Stecker M8x1 3-polig drehbares Gewinde ;en_US@Switch output: with contact, bipolar Switching element function: Normally open contact Operating voltage range DC: 5 ... 30 V Electrical connection: Cable with plug M8x1 3-pin Turnable threads ;es_ES@Salida: bipolar, con contacto Función del elemento de conmutación: contacto de trabajo Margen de tensión de funcionamiento DC: 5 ... 30 V Conexión eléctrica: Cable con conector M8x1 3 contactos Rosca giratoria ;fr_FR@Sortie TOR: bipolaire à contact Fonction d'élément de commutation: Normalement ouvert Plage de tension de service CC: 5 ... 30 V Connexion électrique: Câble avec connecteur mâle M8x1 à 3 pôles Taraudage mobile ;hr_HR@Uklopni izlaz: s kontaktom, bipolarno Funkcija sklopnog elementa: Uklopnik Područje pogonskog napona DC: 5 ... 30 V Električni priključak: Kabel s utikačem M8x1 3-polni okretljivi navoj ;hu_HU@Kapcsoló kimenet: érintkezőkhöz rendelt bipoláris Kapcsoló elem funkció: Záró érintkezők Üzemi feszültségtartomány DC: 5 ... 30 V Elektromos csatlakozás: Kábel, dugóval M8x1 3 sarkú elfordítható menet ;it_IT@Uscita di commutazione: A contatto, bipolare Funzione elemento di commutazione: Contatto Normalmente Aperto Intervallo tensione d'esercizio CC: 5 ... 30 V Connessione elettrica: Cavo con connettore M8x1 3 poli Filetto orientabile ;ja_JP@出力スイッチ: 両極性接点 スイッチング機能: ノーマルオープン接点 使用電圧範囲(DC): 5 ... 30 V 配線方式: ケーブル付プラグ M8x1 3ピン 回転可能ネジ ;ko_KR@스위치 출력: 접점 포함, 양극 스위칭 부품 기능: 초기상태 열림 접점 작동 전압 범위 DC: 5 ... 30 V 전기 연결: 플러그 포함 케이블 M8x1 3-핀 회전 가능한 나사산 ;lt_LT@Jungiklio išėjimas: Su kontaktu, dvipolis Komutavimo elemento funkcija: Normaliai atviras kontaktas Nominalus DC įtampos lygis: 5 ... 30 V Elektrinis pajungimas: Jungtis su kabeliu M8x1 3-poliai Sukamas sriegis ;lv_LV@Komutācijas izeja: ar kontaktu, bipolārais Komutācijas elementa funkcija: Normāli atvērts kontakts Darbības sprieguma diapazons DC: 5 ... 30 V Elektriskais savienojums: Kabelis ar spraudni M8x1 3-kontaktu Pagriežama vītne ;nl_NL@Schakeluitgang: met contact bipolair Schakelelementfunctie: NO-contact (maakcontact) Bedrijfsspanningsbereik DC: 5 ... 30 V Elektrische aansluiting: Kabel met stekker M8x1 3-polig roteerbare schroefdraad ;pl_PL@Wyjście dwustanowe: Stykowe, bipolarne Funkcja elementu przełączającego: Styk normalnie otwarty Zakres napięcia roboczego DC: 5 ... 30 V Przyłącze elektryczne: Kabel z wtyczką M8x1 3-pin Możliwość obracania gwintu ;pt_PT@Saída de comutação: com contato, bipolar Função do elemento de comutação: Contato normalmente aberto Faixa de tensão operacional c.c.: 5 ... 30 V Conexão elétrica: Cabo com conector M8x1 de 3 pinos Rosca giratória ;ru_RU@Выход переключателя: с контактом, биполярный Функция переключающего элемента: Нормально разомкнутый контакт Диапазон рабочего напряжения DC: 5 ... 30 V Электрическое подключение: Кабель с разъемом M8x1 3-пин Поворотные резьбы ;sk_SK@Spínací výstup: kontaktný, bipolárny Funkcia spínacieho prvku: spínač Rozsah pracovného napätia DC: 5 ... 30 V Elektrická prípojka: kábel so zástrčkou M8x1 3-pólový otočný závit ;sl_SI@Izhod stikala: z bipolarnim kontaktom Stikalni element: Vklopni kontakt Območje obratovalne napetosti DC: 5 ... 30 V Električni priključek: Kabel z vtičem M8x1 3-polni vrtljiv navoj ;tr_TR@Anahtarlama çıkışı: kontakt zorunlu, çift kutuplu Anahtarlama elemanı fonksiyonu: Normalde açık kontakt Çalışma gerilimi aralığı DC: 5 ... 30 V Elektriksel bağlantı: Soketli kablo M8x1 3-pinli Dönebilir dişler ;zh_CN@开关输出: 接触式, 双极性 切换元件功能: 常开触点 工作电压范围 DC: 5 ... 30 V 电连接: 带插头电缆 M8x1 3针 可旋转螺纹 ;zh_TW@開關輸出: 具觸點, 雙極性 切換元件功能: 常開觸點 工作電壓範圍 DC: 5 ... 30 V 電氣連接: 具插頭電纜 M8x1 3-pin 可旋轉螺紋 ;" P_ARTICLE_ORDERNR="543861" P_ARTICLE_PACKAGINGPRICE_1="0" P_ARTICLE_PACKAGINGPRICE_2="0" P_ARTICLE_PACKAGINGQUANTITY="1" P_ARTICLE_PICTUREFILE="$(MD_IMG)\FESTO\9440k_2.jpg" P_ARTICLE_PIECETYPE="1_1_1_1" P_ARTICLE_PRICEUNIT="0" P_ARTICLE_PRODUCTGROUP="8" P_ARTICLE_PRODUCTSUBGROUP="1" P_ARTICLE_PRODUCTTOPGROUP="1" P_ARTICLE_PURCHASEPRICE_1="0" P_ARTICLE_PURCHASEPRICE_2="0" P_ARTICLE_SALESPRICE_1="0" P_ARTICLE_SALESPRICE_2="0" P_ARTICLE_SNAPHEIGHT="0" P_ARTICLE_MIDDLEOFFSET="0" P_ARTICLE_SUPPLIER="FES" P_ARTICLE_REF_TERMINAL_OFFSET_X="0" P_ARTICLE_REF_TERMINAL_OFFSET_Y="0" P_ARTICLE_TYPENR="SME-8M-DS-24V-K-0,3-M8D" P_ARTICLE_WEIGHT="0" P_ARTICLE_WIDTH="0" P_ARTICLE_SPACING_LEFT="0" P_ARTICLE_SPACING_RIGHT="0" P_ARTICLE_EXTERNAL_DOCUMENT_4="http://www.festo.com/cad/543861 de_DE@CAD;en_US@CAD;es_ES@CAD;fr_FR@CAD;nl_NL@CAD;sv_SE@CAD;da_DK@CAD;ru_RU@CAD;zh_CN@CAD;pl_PL@CAD;pt_BR@CAD;cs_CZ@CAD;it_IT@CAD;hu_HU@CAD;pt_PT@CAD;ko_KR@CAD;ja_JP@CAD;"> <variant P_ARTICLE_VARIANT="1" P_ARTICLE_ADJUSTRANGE="0" P_ARTICLE_ASSEMBLY_POS_PLACE_SPREADED="0" P_ARTICLE_CABLELENGTH="0" P_ARTICLE_DOORDEPTH="0" P_ARTICLE_DOORHEIGHT="0" P_ARTICLE_DOORMOUNTINGSPACE="0" P_ARTICLE_DOORWIDTH="0" P_ARTICLE_FLOW="0" P_ARTICLE_INTRINSICSAFETY="0" P_ARTICLE_PANELDEPTH="0" P_ARTICLE_PANELHEIGHT="0" P_ARTICLE_PANELMOUNTINGSPACE="0" P_ARTICLE_PANELWIDTH="0" P_ARTICLE_PLCISBUSCOUPLER="0" P_ARTICLE_PLCISBUSDISTRIBUTOR="0" P_ARTICLE_PLCISCPU="0" P_ARTICLE_PLCISPOWERSUPPLY="0" P_ARTICLE_PRESSURE="0" P_ARTICLE_SHORTCIRCUITRESISTANT="0" P_ARTICLE_WIRECROSSSECTION_UNIT="0"> <functiontemplate functiondefcategory="603" functiondefgroup="99" functiondefid="1" hasled="0" hasplugadapter="0" intrinsicsafety="0" plcbussystem="0" pos="1" safetyrelevant="0" terminalfunction="0"/> <functiontemplate connectiondescription="BN" connectionDesignation="1" functiondefcategory="1302" functiondefgroup="1" functiondefid="1" hasled="0" hasplugadapter="0" intrinsicsafety="0" plcbussystem="0" pos="2" safetyrelevant="0" terminalfunction="0"/> <functiontemplate connectiondescription="BU" connectionDesignation="3" functiondefcategory="1302" functiondefgroup="1" functiondefid="1" hasled="0" hasplugadapter="0" intrinsicsafety="0" plcbussystem="0" pos="3" safetyrelevant="0" terminalfunction="0"/> <functiontemplate connectiondescription="BK" connectionDesignation="4" functiondefcategory="1302" functiondefgroup="1" functiondefid="1" hasled="0" hasplugadapter="0" intrinsicsafety="0" plcbussystem="0" pos="4" safetyrelevant="0" terminalfunction="0"/> <functiontemplate functiondefcategory="6003" functiondefgroup="1" functiondefid="1" hasled="0" hasplugadapter="0" intrinsicsafety="0" plcbussystem="0" pos="5" safetyrelevant="0" terminalfunction="0"/> </variant> </part> </partsmanagement>
The Macro as your suggestion is:
function ClearShortCuts() { document.selection.Replace("(de_DE|en_EN|zh_CN|fr_FR|it_IT|ko_KR|ru_RU|pl_PL|es_ES|nl_NL|tr_TR|hu_HU|da_DK|cs_CZ|pt_PT|sv_SE|fi_FI|hr_HR|ja_JP|lt_LT|lv_LV|sk_SK|sl_SI|zh_TW|pt_BR)@(.+?);","",eeReplaceAll | eeFindReplaceRegExp,0); }
The result is the following. All semi-comma have been deleted:
<?xml version=1.0 encoding=utf-8 ?> <partsmanagement count=1 length-unit=mm weight-unit=kg type=PartsManagement build=136.22 database=part001.mdb> <part P_ARTICLE_PARTTYPE=1 P_ARTICLE_PARTNR=FES.543861 P_ARTICLE_CAN_BE_LINED_UP=0 P_ARTICLE_CERTIFICATE_CE=0 P_ARTICLE_CRAFT_COOLING=0 P_ARTICLE_CRAFT_COOLINGLUBRICANT=0 P_ARTICLE_CRAFT_ELECTRICAL=1 P_ARTICLE_CRAFT_FLUID=0 P_ARTICLE_CRAFT_FLUID_UNDEFINED=0 P_ARTICLE_CRAFT_GASTECHNOLOGY=0 P_ARTICLE_CRAFT_HYDRAULICS=0 P_ARTICLE_CRAFT_LUBRICATION=0 P_ARTICLE_CRAFT_MECHANICS=0 P_ARTICLE_CRAFT_PNEUMATICS=0 P_ARTICLE_CRAFT_PROCESS=0 P_PART_CREATE=fstn / 25.06.2014 09:42:45 P_ARTICLE_DEPTH=0 P_ARTICLE_SPACING_FRONT=0 P_ARTICLE_SPACING_REAR=0 P_ARTICLE_DESCR1=en_US@Proximity Sensor; P_ARTICLE_DESCR3=en_US@00991619; P_ARTICLE_DISCONTINUED=0 P_ARTICLE_DISCOUNT=0 P_ARTICLE_EXTERNAL_DOCUMENT_1=http://www.festo.com/catalogue/543861 en_US@Product Catalogue; P_ARTICLE_EXTERNAL_DOCUMENT_2=http://www.festo.com/accessory/543861 en_US@Accessories; P_ARTICLE_EXTERNAL_DOCUMENT_3=http://www.festo.com/net/SupportPortal/start.aspx?q=543861 en_US@Spare parts catalogue; P_ARTICLE_EXTERNAL_PLACEMENT=0 P_ARTICLE_GROUPNUMBER=E-P-SEN P_ARTICLE_GROUPSYMBOLMACRO=$(MD_MACROS)\FESTO\0099xx\V1_00991619.ems P_ARTICLE_HEIGHT=0 P_ARTICLE_SPACING_ABOVE=0 P_ARTICLE_SPACING_BELOW=0 P_ARTICLE_INSTALLATION_DEPTH=0 P_ARTICLE_IS_ACCESSORY=0 P_PART_LASTCHANGE=EPL / 16.06.2016 13:45:09 P_ARTICLE_MANUFACTURER=FES P_ARTICLE_MOUNTINGSITE=0 P_ARTICLE_MOUNTINGSPACE=0 P_ARTICLE_NOTE= M8x1 3 piny otočný závit ;M8x1 3-polig drehbares Gewinde ;en_US@Switch output: with contact, bipolar Switching element function: Normally open contact Operating voltage range DC: 5 ... 30 V Electrical connection: Cable with plug M8x1 3-pin Turnable threads ; M8x1 3 contactos Rosca giratoria ;élément de commutation: Normalement ouvert Plage de tension de service CC: 5 ... 30 V Connexion électrique: Câble avec connecteur mâle M8x1 à 3 pôles Taraudage mobile ; M8x1 3-polni okretljivi navoj ; M8x1 3 sarkú elfordítható menet ;esercizio CC: 5 ... 30 V Connessione elettrica: Cavo con connettore M8x1 3 poli Filetto orientabile ; M8x1 3ピン 回転可能ネジ ; M8x1 3-핀 회전 가능한 나사산 ; M8x1 3-poliai Sukamas sriegis ; M8x1 3-kontaktu Pagriežama vītne ; M8x1 3-polig roteerbare schroefdraad ; M8x1 3-pin Możliwość obracania gwintu ; M8x1 de 3 pinos Rosca giratória ; M8x1 3-пин Поворотные резьбы ; M8x1 3-pólový otočný závit ; M8x1 3-polni vrtljiv navoj ; M8x1 3-pinli Dönebilir dişler ; M8x1 3针 可旋转螺纹 ; M8x1 3-pin 可旋轉螺紋 ; P_ARTICLE_ORDERNR=543861 P_ARTICLE_PACKAGINGPRICE_1=0 P_ARTICLE_PACKAGINGPRICE_2=0 P_ARTICLE_PACKAGINGQUANTITY=1 P_ARTICLE_PICTUREFILE=$(MD_IMG)\FESTO\9440k_2.jpg P_ARTICLE_PIECETYPE=1_1_1_1 P_ARTICLE_PRICEUNIT=0 P_ARTICLE_PRODUCTGROUP=8 P_ARTICLE_PRODUCTSUBGROUP=1 P_ARTICLE_PRODUCTTOPGROUP=1 P_ARTICLE_PURCHASEPRICE_1=0 P_ARTICLE_PURCHASEPRICE_2=0 P_ARTICLE_SALESPRICE_1=0 P_ARTICLE_SALESPRICE_2=0 P_ARTICLE_SNAPHEIGHT=0 P_ARTICLE_MIDDLEOFFSET=0 P_ARTICLE_SUPPLIER=FES P_ARTICLE_REF_TERMINAL_OFFSET_X=0 P_ARTICLE_REF_TERMINAL_OFFSET_Y=0 P_ARTICLE_TYPENR=SME-8M-DS-24V-K-0,3-M8D P_ARTICLE_WEIGHT=0 P_ARTICLE_WIDTH=0 P_ARTICLE_SPACING_LEFT=0 P_ARTICLE_SPACING_RIGHT=0 P_ARTICLE_EXTERNAL_DOCUMENT_4=http://www.festo.com/cad/543861 en_US@CAD;> <variant P_ARTICLE_VARIANT=1 P_ARTICLE_ADJUSTRANGE=0 P_ARTICLE_ASSEMBLY_POS_PLACE_SPREADED=0 P_ARTICLE_CABLELENGTH=0 P_ARTICLE_DOORDEPTH=0 P_ARTICLE_DOORHEIGHT=0 P_ARTICLE_DOORMOUNTINGSPACE=0 P_ARTICLE_DOORWIDTH=0 P_ARTICLE_FLOW=0 P_ARTICLE_INTRINSICSAFETY=0 P_ARTICLE_PANELDEPTH=0 P_ARTICLE_PANELHEIGHT=0 P_ARTICLE_PANELMOUNTINGSPACE=0 P_ARTICLE_PANELWIDTH=0 P_ARTICLE_PLCISBUSCOUPLER=0 P_ARTICLE_PLCISBUSDISTRIBUTOR=0 P_ARTICLE_PLCISCPU=0 P_ARTICLE_PLCISPOWERSUPPLY=0 P_ARTICLE_PRESSURE=0 P_ARTICLE_SHORTCIRCUITRESISTANT=0 P_ARTICLE_WIRECROSSSECTION_UNIT=0> <functiontemplate functiondefcategory=603 functiondefgroup=99 functiondefid=1 hasled=0 hasplugadapter=0 intrinsicsafety=0 plcbussystem=0 pos=1 safetyrelevant=0 terminalfunction=0/> <functiontemplate connectiondescription=BN connectionDesignation=1 functiondefcategory=1302 functiondefgroup=1 functiondefid=1 hasled=0 hasplugadapter=0 intrinsicsafety=0 plcbussystem=0 pos=2 safetyrelevant=0 terminalfunction=0/> <functiontemplate connectiondescription=BU connectionDesignation=3 functiondefcategory=1302 functiondefgroup=1 functiondefid=1 hasled=0 hasplugadapter=0 intrinsicsafety=0 plcbussystem=0 pos=3 safetyrelevant=0 terminalfunction=0/> <functiontemplate connectiondescription=BK connectionDesignation=4 functiondefcategory=1302 functiondefgroup=1 functiondefid=1 hasled=0 hasplugadapter=0 intrinsicsafety=0 plcbussystem=0 pos=4 safetyrelevant=0 terminalfunction=0/> <functiontemplate functiondefcategory=6003 functiondefgroup=1 functiondefid=1 hasled=0 hasplugadapter=0 intrinsicsafety=0 plcbussystem=0 pos=5 safetyrelevant=0 terminalfunction=0/> </variant> </part> </partsmanagement>
DavidParticipantHello,Yutaka sung, Stefan
Thanks for your reply.
I had tried the solutions you both offered, however, the semi-column still be replaced. Very strange.DavidParticipantHello, Yutaka Emura Sung, You’re right. I have just tried Advanced Filter. It can does as my exception and is acceptable. However, if we can type AA BB or AA -BB, it will be more convenient.
For second requirements, I wanna say more. From myself, I like Emeditor very much and have a few experiences on Regular Expression. Almost everyday I use it to write or handle something. Therefore I often recommend it to my colleagues, my friends and my customers…….Some of them understand Regular Expression , but others feel crazy about it. We can’t assume all people are “computer expert” . A good software, should be not only powerful (has many many functions), but also as easier as possible. Then more and more people will like and use it.
For your reference.
DavidParticipantFor first software wish, I have similar requirements. It’s easy to see how many blank I have typed in. But I think other marks (such as wide space) should also be considered.
February 8, 2018 at 4:34 am in reply to: [Ask for Help] Macro for replace the number located at the beginning of a row #22844DavidParticipantHello, Stefan. It works very well. Thank you!
DavidParticipantHello, Patrick
Thank you! Now I understand how to use it!DavidParticipantYeah, this is same idea from my side.
I don’t know if we ‘re correct to push EmEditor to become “light” Excel?! We always want many Excel functions can be used in EE. ^_^November 29, 2017 at 6:44 am in reply to: If possible to move the cursor to next line automatically after pasting? #22661DavidParticipantHello, Patrick! Thank you very much!
DavidParticipantProblem 1 has been solved. Use . (period) in regular expression mode and active “negative” function. It works very well, thanks!
Problem 2, wish to see it in future version.November 21, 2017 at 8:13 pm in reply to: Suggest to add a menu item "repeat last action" in conext menu #22645DavidParticipantThanks!
DavidParticipantWorks very well!Thank you so much!
October 9, 2017 at 10:04 pm in reply to: [Ask for help] Filling the selected cells by progressive number in TSV mode #22475DavidParticipantHello, Meir
Thanks for your suggestion.
I need often to handle CSV/TSV files in my work.Of course I know Excel or other free spreadsheet applications can handle them. But Emeditor has its advantages:
1. In Excel, if open CSV file, several steps is essential for choosing separator. While saving files to CSV/TSV format, I have to consider encode for unicode character. Emeditor is more easy to choose separator and encode.
2. For large CSV files, for example, 10MB. The operating speed of Emeditor is faster significantly than that of Excel.
3. Filter CSV data in EmEditor is very quick and flexible. I can decide to display only filtered rows ,or even their above/down defined rows.
4. Narrow function: Only the rows of selected area are changeable. Others are grayed out. That will avoid unwanted change.
5. Write macro in Emeditor is more simple that in Excel.
……………….
There are many CSV related functions in Emeditor.
I don’t think Emeditor is flawless but it’s really helpful to me.Hello,Yutaka
I will try soon. Thanks!October 8, 2017 at 3:55 pm in reply to: [Ask for help] Filling the selected cells by progressive number in TSV mode #22470DavidParticipantThank you ,Yutaka Sang!
October 1, 2017 at 4:35 pm in reply to: AutoSave or Backup features -> keeping file versions -> is it possible #22455DavidParticipantIf this wish is going to be implemented in future version. I suggest add an option for it. As above mentioned, the option can be called “maximum number of the saved versions”, the number can be from 0 to any of number.
For me, I don’t wish Emeditor creates lots of backup file since the setting of time interval for autosave is only 1 min. Finally I have to delete backup file manually.June 23, 2017 at 10:29 pm in reply to: Question – Unsmooth /Slack operating while opening a 12MB XML file! #21997DavidParticipantHello, Yutaka sang,
Thanks for your reply. I have done as your suggestion. But it seems same as before.June 23, 2017 at 9:13 pm in reply to: Question – Unsmooth /Slack operating while opening a 12MB XML file! #21996DavidParticipantHello,Sky:
Yes. This file has only one row and 12,793,967 columns. It’s generated by a software. The contents are like
<ap:TaskPriority Dirty="0000000000000000" TaskPriority="urn:Prio5"/></ap:TaskPriorityMarker></ap:TaskPriorityMarkers></ap:MarkersSetGroup></ap:Map>
December 3, 2016 at 10:06 pm in reply to: [Ask for help] Question regarding replace string from Regular expression #21413DavidParticipantHello,Stefan! Thank you again!
Hello,LTT. Your macro works very well. Thank you too!December 2, 2016 at 6:04 pm in reply to: [Ask for help] Question regarding replace string from Regular expression #21410DavidParticipantThank you, Stefan! You’re so warm~~
My description is not so clear, sorry for that! What I want is:
FROM:partnr=[1!#10] productgroup=[1!#2] productsubgroup=[1!#3] description1=”zh_CN@”+[1!#15]+”;”+”en_US@”+[1!#16]+”;” note=”zh_CN@”+[1!#17]+”;”+”en_US@”+[1!#18]+”;” assemblyposition count=[1!#4] parentvariant=[1!#5] partnr=[1!#6] pos=[1!#7]
TO:
partnr=[1!#1] productgroup=[1!#2] productsubgroup=[1!#3] partnr=[1!#4] productgroup=[1!#5] productsubgroup=[1!#6] description1=”zh_CN@”+[1!#7]+”;”+”en_US@”+[1!#8]+”;” note=”zh_CN@”+[1!#9]+”;”+”en_US@”+[1!#10]+”;” assemblyposition count=[1!#11] parentvariant=[1!#12] partnr=[1!#13] pos=[1!#14]
Use the function “split” “match” and “replace” of Java script is a good way. If possible to use the function “replace” of Emeditor syntax? If yes, it looks a little simple~~~
June 9, 2016 at 5:54 pm in reply to: Button "Select all" in Find dialog box is grayed out on version 16 beta2?! #20912DavidParticipantYes. It works after checking “Enable Multiple Selections”. EmEditor is really very nice.
June 8, 2016 at 10:19 pm in reply to: Button "Select all" in Find dialog box is grayed out on version 16 beta2?! #20910DavidParticipantThank you, Yutaka! Without old INI files, Button “Select all” works very well. It looks my INI files are defective. I will check that. Since I had customized my Main menu, context menu, menu of tab, toolbar….. I wish to keep them via old INI file.
August 5, 2014 at 5:41 pm in reply to: Option to lock first line when using CSV / TSV / DSV mode #18723DavidParticipantYes, I agree ” locked rows configurable”. Sometimes we only need lock first line, but perhaps others would like to lock two or more lines. It’s better to give users the options to decide how many lines the would like.
- AuthorPosts