INNOV-AI

Innovation and Research from Réunion Island, France

Back   Home

Parse a text file from remote connection @ CONNECT - Connections @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

Click on 'CONNECT' tab, open 'Remote file', right click on 'demo_cm_file' and select 'GEN > PARSE TEXT FILE'

MQL INPUT
script create post "demo.file.parse_text" false 1 
  (param
  	(var "[fileName]" {true} "The file name" is_null:false is_empty:false "test.txt")
  ;) 
  "Parse a text file" 
{

	#Load the connection id;
	json load "cm" (cm get "demo_cm_file");
	-> "[localDir]" (json select "cm" /localDir);

	#Open a reader;
	file reader_open "r1" (concat [localDir] "/" [fileName]) TEXT "utf-8";

	try {

		#Parse the file;
		while (is not null (-> "[line]" (file reader_get_line "r1"));) {
	
			log trace (concat "line=" [line]);
	
		};

		#Close the reader;
		file reader_close "r1";
	
	} {

		#Close the reader;
		try {file reader_close "r1";} {} "[sub_err]";

		#Generate an error;
		exception (1) ([err]);
	
	} "[err]";

;} "Return 1";
start: 2026-01-17   end: 2026-01-31   v_start: 401   v_end: