Parse question

[jillv]

Hi folks,

What is the simplest and easiest way to remove the "0.data." and move the numbers to a separate column?

thank you!

Name

0.data.1.figi

0.data.2.name

0.data.3.ticker

0.data.4.exchCode

0.data.5.compositeFIGI

0.data.6.securityType

0.data.7.marketSector

0.data.8.shareClassFIGI

0.data.9.securityType2

0.data.10.securityDescription

expected

Name	Group
figi	1
name	2
ticker	3
exchCode	4
compositeFIGI	5
securityType	6
marketSector	7
shareClassFIGI	8
securityType2	9
securityDescription	10

[Felipe_Ribeir0]

Hi @jillv 

One way of doing this

[flying008]

Hi, @jillv 

Parse by RegEx for you:

[Raj]

This can be done like this as well without writing any expression,I think this is simplest in this case

[grazitti_sapna · Accepted solution]

@jillv , Here are 2 ways to do it with regex and text to columns tool. You can try out any you consider simple.

[Qiu]

@jillv 
The format you have is a typical JSON format, and you only have the JSON_Name column and you should have also JSON_ValueString column.

We have a weekly challenge which has shown how to parse the data. 😁

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-346-Map-Messi-and-Ronaldo-s-Goals-Part-1...