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
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 743 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 15 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive