Read and modify XML file with execute script operator
Ale
New Altair Community Member
I'm trying to read an xml file without using the ReadXml operator. I want to treat is as a text file and then extract some values from it. I was wondering if this can be done using the execute script operator. This is part of the java code I'm using with the execute script operator. I don't get any error but it's like it doesn't even start the execution.
Thanks a lot.
Would you suggest a better way to do this?
String path="/home/myFolder/file.xml";
String content = new Scanner(new File(path)).useDelimiter("\\Z").next();
//some operations on content
return content;
Thanks a lot.
0
Answers
-
Hi,
this will read a file line by line and create a document. To use the output, you need to create an instance of an IOObject and return that.
Regards,
import com.rapidminer.operator.text.Document;
import com.rapidminer.operator.text.Token;
import java.util.List;
import java.util.LinkedList;
import java.util.Scanner;
import java.nio.file.Paths;
String pathToFile = 'C:/users/boeck/Desktop/test.txt';
Scanner content = new Scanner(Paths.get(pathToFile).toFile());
List<Token> newTokens = new LinkedList<>();
while (content.hasNextLine()) {
newTokens.add(new Token(content.nextLine(), 1.0f));
}
return new Document(newTokens);
Marco0 -
Thank you very much. It's very helpful0