This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Sure. You may need to read each workbook individually and union them together, then send them through a formula that applies the regular expreission, but yes - this is certainly possible. If you have sample data, we can help figure out the specifics.
Youn only need to make sure (for make the things easier) that the field that you want to transform with Regex have the same 'field_name' for all the excel files:
The steps will be then (I will put images):
1) Call the excel files with a wildcard(*), I will suggest you to put the files that you need to process together in one folder (only to avoid to call other files) and make sure that the 'sheet' that contain the phones is the same for all the files.
With the (*.xlsx) I will call in my input folder any file with the extension .xlsx
2) Apply the regex formula, this could be using tthe formula tool or the regex tool from the Parse Section, in the picture I'm using a formulatool.
Hope this will help you, attached you will find the module and the excel files.
I'm attaching an excel file that has 3 worksheets, but each sheet must be taken (i could not find a way to upload 3 excel files so I put them all in one) as seperate workbook (ex: sample1=workbook1, sample 2=workbook2, sample3=workbook3
my regex code is :
I want to go through all files (workbook1,2,3) ->find "ZIPCODE" coloumn name -> then apply regex