String Parsing
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
khanp27
6 - Meteoroid
‎09-22-2023
09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to parse the following string to extract database name (highlighted in RED)
00:00:00.437 - ToolId 140: records were written to Cloudera ODBC (db.table_name)
00:00:00.927 - ToolId 228: records were written to XYZ Reporting Analytics SP (dbo.XYZ)
00:00:00.373 - ToolId 273: File successfully uploaded to test.com (file is abc.hyper) 00:00:14.524 - .........
00:00:00.567 - ToolId 238: File successfully uploaded to test1.com(file is xyz.hyper)
Any leads will be highly appreciated.
Thank you
2 REPLIES 2
MilindG
12 - Quasar
‎09-22-2023
09:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎09-22-2023
08:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can also try this @khanp27
.* to (.*\))
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
