Name parsing issue (text to column)

Question

Hi all,

I have an issue with the text to column tool.

Before I was always lucky enough the delimiters that should not be delimited were within quotes or parentheses, but not this time.

The format is like

{value1=470,type=370,work=House,city=Paris,name=Jack Ripper,loyalty=Yes, ... , ..., etc.}

Now the issue is that the name field sometimes contains , (comma's) as well which is used as the separator. So how can I make sure the fields are parsed correctly and not end up with a different amount of columns per row?

{value1=470,type=370,work=House,city=Paris,name=Jack Ripper,loyalty=Yes}
{value1=12322,type=32270,work=Houses,city=Amsterdam,name=Ron , Jans,loyalty=Yes}
{value1=1322,type=3220,work=App,city=Amsterdam,name=Mr , double, comma name,loyalty=No}
{value1=470,type=370,work=House,city=Paris,name=Testing test,loyalty=Yes}

Merci!

Christina_H · Accepted Answer

This was an interesting one!  I've used the = to find the headings, assuming each heading is only one word.  This won't work for multi-word headings without some modification.

atcodedog05 · Accepted Answer

Hi @Pingu

If you already know the column names you can use Regex to prase the values out which is next to column name like below.

Hope this helps : )