Extract course code from column

[Scott Cowie]

Hi,

I have cells in a column with sentences that include a course code in the format 1234ABC (4 numbers and 3 uppercase letters).
How can I extract this course code to a new column.

Thanks

[Thad Guidry]

Add Column based on this column

Then use GREL:

value.match(/.*(\d\d\d\d[A-Z][A-Z][A-Z]).*/).join("")

The key to this is the Regex Capture Group and the ending empty join to pluck out the value from the array that match() produces.

(I am assuming that you might have characters before or after your pattern... so this uses .*)

More documentation about match() is available here on our wiki, along with more Regex guides: https://github.com/OpenRefine/OpenRefine/wiki/GREL-String-Functions#matchstring-s-regexp-p

Thad

+ThadGuidry

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Scott Cowie]

Thanks Thad, that is exactly what I needed.

Scott.