Magic ETL - string operations help
If i have an excel spreadsheet that contains the following column called file path:
FilePath |
BUILDING\200303379 Files\Receipt20181213_20200107_133244.pdf |
BUILDING\200303379 Files\Receipt20181213_20200107_133309.pdf |
BUILDING\200410340 Files\HIDAWAY AVE 27227 (200410340)_CASE DOCUMENT.pdf |
BUILDING\29700587 Files\Receipt20181213_20200107_133333.pdf |
BUILDING\29700587 Files\Receipt20181213_20200107_133350.pdf |
BUILDING\29804878 Files\Receipt_20181213_144740.pdf |
BUILDING\29804878 Files\Receipt_20181213_144805.pdf |
BUILDING\29804878 Files\Receipt_20181213_144809.pdf |
BUILDING\29804878 Files\Receipt_20181213_144810.pdf |
BUILDING\29903009 Files\Receipt_20181204_090007.pdf |
BUILDING\BLD05-04079 Files\Receipt20181213_20191223_095745.pdf |
BUILDING\BLD05-04079 Files\Receipt20181213_20191223_095813.pdf |
BUILDING\BLD06-02296 Files\Receipt20181213_20190523_101859.pdf |
Is there a way to use magic etl string operations to only give me the file name?
FileName |
Receipt20181213_20200107_133244.pdf |
Receipt20181213_20200107_133309.pdf |
HIDAWAY AVE 27227 (200410340)_CASE DOCUMENT.pdf |
Receipt20181213_20200107_133333.pdf |
Receipt20181213_20200107_133350.pdf |
Receipt_20181213_144740.pdf |
Receipt_20181213_144805.pdf |
Receipt_20181213_144809.pdf |
Receipt_20181213_144810.pdf |
Receipt_20181204_090007.pdf |
Receipt20181213_20191223_095745.pdf |
Receipt20181213_20191223_095813.pdf |
Any ideas? Thanks.
1
Comments
-
You can do this with the Split Columns function in the ETL. Assuming your structure has 2 folders and then the filename, it would look like this:
This would result in the following based on your data:
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.3 -
If you don't care about the folders then you can use the Replace Text widget with the following regular expression (and replace with the empty string). It will handle any number of folders.
^.*\\
See the attached screenshot for the configuration options.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive