I have a csv file that include the information below:
name1="value1" name2="value2" ..... nameN="valueN"
I would like to create 2 new column containing the data as below:
Name | Value |
name1 | value1 |
name2 | value2 |
... | |
nameN | valueN |
Thanks for reading!
Solved! Go to Solution.
Hi @hungdm
Bit of regex for you. First split by row and then split to columns. It cleans up all white space within the regex so no need for data cleansing tool.
You actually just need two text to columns to parse out your data. Given that each "group" is separated by a space, you can use a space with the text to rows function. After that, the name and values are separated by an equals, so you can use that as a delimiter to create two columns.
I added a data cleansing to remove the quotation marks and a select to rename the fields.