topic Re: How do I extract only the text that is between quotation marks in Discussions

How do I extract only the text that is between quotation marks

fionaweston — Fri, 09 Jun 2023 22:08:49 GMT

I have a column containing 1000's of Machine Error Codes which are typed in by an operator at the machine.

Most of the errors do not have quotation marks but for those that do I would like to be able to extract what is between the quotation marks.

For other special characters I can use the escape character but I'm having problems using this with the quotation marks.

Thanks in advance

Fiona

Example 1: *******The unit is giving a “no scanner connection” error. Unit is INOP.
Example 2: ********P1-“Waiting for system authentication”, unable to run ******* Area C
Example 3: *********Now reads “X-ray error"

Re: How do I extract only the text that is between quotation marks

jthi — Thu, 18 Mar 2021 17:03:19 GMT

There seems to be at least three different kinds of quotes in the example dataset (“ " ”).

Example script here should handle at least all of those.

Names Default To Here(1);
dt = New Table("Error Codes Quotations",
	Add Rows(3),
	Compress File When Saved(1),
	New Column("Error Code",
		Character,
		"Nominal",
		Set Values(
			{
			" ****  The unit is giving a “no scanner connection” error.  Unit is INOP.",
			"P1-“Waiting for system authentication”, unable to run  ******* Area C",
			"Now reads “X-ray error\!""}
		)
	)
);

dt << New Column("BetweenQuotes_Regex", Character, Nominal, << Formula(
	Regex(:Error Code, "[“|\!"|'](.*?)[”|\!"|']");
));
dt << New Column("BetweenQuotes_Word", Character, Nominal, << Formula(
	Word(2, :Error Code, "”“\!"")
));

Re: How do I extract only the text that is between quotation marks

fionaweston — Thu, 18 Mar 2021 17:11:04 GMT

Thank you. This works great!!