Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

String Parsing

khanp27
6 - Meteoroid

I am trying to parse the following string to extract database name (highlighted in RED)

 

00:00:00.437 - ToolId 140: Alias Translated to odb:Provide=SQLOLEDB.1; Initial Catalog=ReportingAnalytics;Data Source= XYZ,1234; Use Procedure for prepare=1 ...............................

 

Any leads will be highly appreciated. 

 

Thank you

2 REPLIES 2
Prometheus
12 - Quasar

@khanp27 If the values you're trying to pull from this string are exactly 3 characters followed by a comma and 4 digits, this expression will work for you: .*(.{3}\,\d{4}).*

String Parsing.PNG

 If not, I'd recommend checking out www.regex101.com so you can put in the actual values and find out what works best for you.

binuacs
20 - Arcturus

@khanp27 One way of doing this

image.png

Labels