We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

Extracting Data

nvallem
6 - Meteoroid

fff

4 REPLIES 4
kamanivk
8 - Asteroid

First find the position of : and - in the string.

Use them in substring to find Ticker, Bid and Ask.

 

kamanivk_0-1634015389576.png

 

 

atcodedog05
20 - Arcturus

Hi @nvallem 

 

You can use Regex Parse like below

 

Workflow:

atcodedog05_0-1634018293825.png

 

Hope this helps : )

PhilipMannering
14 - Magnetar
14 - Magnetar

@atcodedog05 The "-" sign doesn't need to be escaped. And a fullstop or period don't need to be escaped when part of a set, so a simpler expression would be,

(.+): ([\d.]+)-([\d.]+)

 

atcodedog05
20 - Arcturus

Hi @PhilipMannering 

 

Interesting, thank you for sharing this info 🙂. This will definitely help me improve my approaches 😀