UltraEdit, UltraCompare, UEStudio forums

Hi Mofi, I need your expert advise. I need to merge all rows into one column which is in Excel format using UltraEdit. Each and every row must contain the header when merged. Please find attachment for you attention. TQ

Hi Mofi, If my id number is in the first column, how do I change the script: var sSearch = "^(?:[^\\r\\n|]*\\|){2}" + asIDs[nID] + "\\|.+$"; IDNO|OLDIDNO|NAME|ADDRESS1|ADDRESS2|ADDRESS3|STATE|MOBILE| 440521065029|3532232|MUHAMAD BIN KACHA|L |KG BUKIT LEPAS|SARANG TIONG|TIOMAN|ROMPIN|0197416284 45052...

Hi Mofi.. You were right. It is taking a long time to run the script. I have tried with 50k per script run and after almost 10 hours it is still running. I have 6 million data to be sorted out. Is there any other way to do this task? Anyway how do I combine data. I have hundreds folders of data with...

Hi Mofi. It work well with the data I posted. When I run with other data an error occurred, read as below: Running script: J:\SERVER FILE\Script\test.js ======================================================================= An error occurred on line 13: �� Script failed. [hr] I tried the script wit...

Hi Mofi I follow your instruction, I open a first file with 30m data, then I open second file with 6m ID no only. I open third file copied the script and run active script. I also did execute form the script menu. The second file ID NO was highlighted in blue but nothing happens. Did I do it correct...

Hi Mofi, I'm using UltraEdit Professional Text/HEX Editor Version 19.00.0.1022 The task: I have a CSV file open in UltraEdit which contains fields as below: MOBILE_NO|NAME|NEW_IC|OLD_ID|OTHER_IC|ADD1|ADD2|ADD3|CITY|STATE|POSTCODE 0198183831|CHUNG MIANG POH|450226135249|K570346||LOT 886 JALAN GUBAH B...

Hi Mofi. Thanks for the info. Sorry, I'm not sure if you got me right. I have 50 million database with field name as below: ACCOUNT|MOBILENO|NAME|ADD1|ADD2|ADD3|CITY|ZIP|STATE|NEWID|BUSREG|OTHERID|OLDID|REGDATE|STATUS|GENDER|BIRTHDATE|RACE|EMAIL 10100801|0192168465|MRS RAJESWARY A/P BHASKARAN|NO 42|...

Hi Mofi. Thanks for the guidance so far. Assuming I have 50 million data with different fields name as below: ACCOUNT|MOBILENO|NAME|ADD1|ADD2|ADD3|CITY|ZIP|STATE|NEWID|OTHERID|OLDID|REGDATE|STATUS|GENDER|BIRTHDATE|RACE|EMAIL 10100801|0192168465|MRS RAJESWARY A/P BHASKARAN|NO 42|KG PINANG||HULU BERNA...