Buy Download WordPipe, ExcelPipe and PowerPointPipe combined demo
This is a collection of frequently asked questions about ExcelPipe.
Use ExcelPipe's SharePoint button to create a SharePoint link for you complete with login details. You can also use the same button for UNC paths. If this does not work for you, you can always map your SharePoint site as a network drive.
Easy. First set the Find What text to
^g
ie literally carat (Shift+6) followed by letter 'g'. Not Ctrl+G. (Astute users will notice that this is the same as with MS Word)
Set the Replace With field to the complete path to the replacement image on disk.
ExcelPipe does this for you.
Check the 'Shapes' Look In location.
You can't - this is an Microsoft Excel limitation. If you can File\Save As the file as CSV (Comma delimited format), then you can apply our TextPipe Pro tool.
Note: EasyPattern wildcards (reference) are only available inside plain text fields, such as hyperlink addresses, OLE links and document properties.
Purpose | Find What and Replace With terms |
Extract filename from a URL and add a new server and path Input: https://intranet.gotafe.vic.edu.au/teaching/course/electro/technology.doc Output: https://newintranet.gotafe.vic.edu.au/documentlibrary/technology.doc |
Find what: [ lineStart, 1+chars, '/', capture(longest 1+ not '/' ), lineEnd ] Replace with: https://newintranet.gotafe.vic.edu.au/documentlibrary/$1 |
Extract filename and part of a path from a UNC server path
and add a new server and path Input: Output: \\newserver\new_share_name\teaching\course\electro\technology.doc |
Find what: [ lineStart, Replace with (note doubling of \) \\\\newserver\\internal\\teaching\\$3\\$4 |
Note: perl regex wildcards (reference) are only available inside plain text fields, such as hyperlink addresses, OLE links and document properties.
Purpose | Find What and Replace With terms |
Extract filename from a URL and add a new server and path Input: https://intranet.gotafe.vic.edu.au/teaching/course/electro/technology.doc Output: https://newintranet.gotafe.vic.edu.au/documentlibrary/technology.doc |
Find what: ^.+/([^/]+?)$ Replace with: https://newintranet.gotafe.vic.edu.au/documentlibrary/$1 |
Extract filename and part of a path from a UNC server path
and add a new server and path Input: Output: \\newserver\new_share_name\teaching\course\electro\technology.doc |
Find what: ^\\\\([^\\]+)\\([^\\]+)\\(.+)\\([^\\]+)$ Replace with: \\\\newserver\\internal\\teaching\\$3\\$4 |
If you open Excel and put your cursor in the date cell, you will find that the date data (which is what ExcelPipe scans through) is different to the formatted date displayed. E.g. 28-Feb-07 is displayed, but the data in the cell is 28/02/2007. You must be very careful to match the actual cell content exactly.
This occurs when Microsoft Excel is trying to display a dialog box, such as for a missing linked document (note: ExcelPipe does NOT pause for missing passwords. If you have not specified the correct password, these files are logged for manual handling). Simply press [Alt+Tab] to get to Microsoft Excel, then clear the dialog box. Once this is done, ExcelPipe will resume at normal speed.
Buy Download WordPipe, ExcelPipe and PowerPointPipe combined demo