Forum Discussion
How to split column which contains Dot (.) separated values ???
HI , I have a column "MYColumn" which has Dot separated values.My Requirement is to split "Mycolumn" into 3 columns as shown in below image Thanks, Raghav
- Navigate to "Edit query" window.
- Select your table, click on the "MYColumn" header.
- Make sure "Home" tab is selected, click "Split Column" -> "By delimiter",
- Select "Comma" in the dropdown and "At each occurrence of the delimiter" option.
- For each of the resulting columns, on the same "Home" tab select "Replace Values".
- Value To Find: ".", Replace With: ","
- Now you should see your desired result.
Hi,
By your suggestion i am getting 5 columns as below image
but my desigred output is it should be 3 columns and each column should separated with comma values.
Thanks,
Raghav
Sorry - I did not notice you need to select items from each group.