Forum Replies Created

Viewing 25 posts - 51 through 75 (of 80 total)
  • Author
    Posts
  • in reply to: Random Sort of data in CSV mode? #23827
    David
    Participant

    Yes, I means “shuffle lines randomly”. I know a tool “Sublime Text” has this function.

    in reply to: Question of Regular Expression for matching multi-row #23636
    David
    Participant

    Mr KT. It works very well. A lot Thanks!

    in reply to: Question of replace string via macro #23555
    David
    Participant

    Hello, 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&apos;é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&apos;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>
    in reply to: Question of replace string via macro #23553
    David
    Participant

    Hello,Yutaka sung, Stefan
      Thanks for your reply.
      I had tried the solutions you both offered, however, the semi-column still be replaced. Very strange.

    in reply to: Software wish – Enhance filter function #23469
    David
    Participant

    Hello, 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.

    in reply to: Find and Replace dialog box suggestions #22935
    David
    Participant

    For 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.

    David
    Participant

    Hello, Stefan. It works very well. Thank you!

    in reply to: Question of "User menu 1-9"? #22726
    David
    Participant

    Hello, Patrick
    Thank you! Now I understand how to use it!

    in reply to: Freeze Pane Request #22672
    David
    Participant

    Yeah, 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. ^_^

    David
    Participant

    Hello, Patrick! Thank you very much!

    in reply to: [Ask Help]Two questions regarding CSV mode #22646
    David
    Participant

    Problem 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.

    David
    Participant

    Thanks!

    in reply to: Version [17.2] Question regarding Autofill #22571
    David
    Participant

    Works very well!Thank you so much!

    David
    Participant

    Hello, 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!

    David
    Participant

    Thank you ,Yutaka Sang!

    David
    Participant

    If 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.

    David
    Participant

    Hello, Yutaka sang,
    Thanks for your reply. I have done as your suggestion. But it seems same as before.

    David
    Participant

    Hello,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>

    David
    Participant

    Hello,Stefan! Thank you again!
    Hello,LTT. Your macro works very well. Thank you too!

    David
    Participant

    Thank 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~~~

    David
    Participant

    Yes. It works after checking “Enable Multiple Selections”. EmEditor is really very nice.

    David
    Participant

    Thank 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.

    in reply to: Option to lock first line when using CSV / TSV / DSV mode #18723
    David
    Participant

    Yes, 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.

    in reply to: How to delete empty lines by macro? #18385
    David
    Participant

    Now it works ver well!
    document.selection.Replace("\\n$","",eeFindNext | eeFindReplaceRegExp | eeReplaceAll);

    Thanks again!

    in reply to: How to delete empty lines by macro? #18383
    David
    Participant

    Sorry, please copy the link to your address bar of IE explorer and then open it. Click directly will get en error!

Viewing 25 posts - 51 through 75 (of 80 total)