Extract

Extract some part of the text in a cell, and replaced the cell by the extracted text.

Supported Regular Expression and Wildcard. In the Extract Rule, the text in the parentheses will be kept, the others will be deleted.

For Example:

The word in a cell is Tel: 123-123-2323,  If you want to reserve the part of telephone number  123-123-2323, the rest part Tel:  will be deleted.
Apply the Extract Rule (1?[\s-]?\(?(\d{3})\)?[\s-]?\d{3}[\s-]?\d{4}) , the telephone number has just retained.

抽取

 

Caption Extract Regular Expression
ZIP code (US) (\b[0-9]{5}(?:-[0-9]{4})?\b) Yes
Date yy-m-d or yyyy-mm-dd (\b(19|20)?[0-9]{2}[- /.](0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])\b) Yes
Date m/d/y and mm/dd/yyyy (\b(0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])[- /.](19|20)?[0-9]{2}\b) Yes
Date d/m/yy and dd/mm/yyyy (\b(0?[1-9]|[12][0-9]|3[01])[- /.](0?[1-9]|1[012])[- /.](19|20)?[0-9]{2}\b) Yes
Remove non-digits ([0-9]+) Yes
Remove Letters ([^a-zA-Z]) Yes
Remove Numbers ([^0-9]) Yes
Domain From Url ://([\w\-\.]+) Yes
Phone Numbers (1?[\s-]?\(?(\d{3})\)?[\s-]?\d{3}[\s-]?\d{4}) Yes
Numbers (-?\d+(,\d+)*(\.\d+(e\d+)?)?) Yes
Comma Separated Number ([0-9]{1,3}(?:,[0-9]{3})*(?:\.[0-9]+)?) Yes
Floating Point with Exponent ([+\-]?(?:[0-9]*\.[0-9]+|[0-9]+\.)(?:[eE][+\-]?[0-9]+)?) Yes
Floating Point ([+\-]?(?:[0-9]*\.[0-9]+|[0-9]+\.)) Yes
Hex Number (0[xX][0-9a-fA-F]+) Yes
Integer ([+\-]?[0-9]+) Yes
Quoted String(Single Line) ([^\r\n]*(?:\.[^”\r\n]*)*)” Yes
Quoted String(Multiple Lines) ([^\\]*(?:\\.[^”\\]*)*)” Yes
URL (\b(https?)://(?:(\S+?)(?::(\S+?))?@)?([a-zA-Z0-9\-.]+)(?::(\d+))?((?:/[a-zA-Z0-9\-._?,’+\&%$=~*!():@\\]*)+)?) Yes
Email (\b([a-zA-Z0-9%_.+\-]+)@([a-zA-Z0-9.\-]+?\.[a-zA-Z]{2,6})\b) Yes