Hi,   I have a table of data with a column of text for medical information/notes. There is a 8 digit identifier that is used for each patient. An example of one patient information could be "John Smith was called at telephone number (111)-222-3333 he was notified of his update. ID: 1234-5678" I want to be able to pull out all ID information and store it as a new column in the table. however the ID format is not always the same, sometimes there could be a space like "1234 5678" or no space "12345678" or possible hyphens in different spots while always being 8 digits long.   I have been using prxchange but it doesnt seem to be working.   Any help would be greatly appreciated. ... View more

Hi,   I have a library of 100+ datasets each with 10+variables. I was wondering if it was possible to output an excel table that had the table name and the column names to the right kind of like the format below.    Dataset_name1 | variable_1 | variable_2  dataset_name2 | variable_1 | variable_2| ....   Any help would be greatly appreciated. Thank you. ... View more

Hi,   I have a bunch of folders that all have a dataset with the same name in them. folder1, folder2, folder3, folder4. all contain mydata.   i was wondering if it was possible to do a DO LOOP over a list of these folder names and run an extraction macro of these datasets.   So far all the things i've seen online are for looping over files within a folder and not looping over folders/libraries.   any help would be greatly appreciated thanks. ... View more