Forum Discussion
export data from PB - format
Hi, when exporting data from table in PB, all the data is pushed to single column. Is there any way to export data to seperated columns like the original table in PB?
I'm unable to replicate this issue on my machine.. having no problems with the data being separated regardless of how I export. Have you tried checking the regional setting for list separator?
Control Panel > Region/Language options > Additional settings > List seperator set to comma.
Hi,
I could not find how to navigate to these settings. There are no "additional settings" under languages/region. I also did not find something like that under other categories.
I could not find how to navigate to these settings. There are no "additional settings" under languages/region. I also did not find something like that under other categories.
Windows 7
- Select Control Panel
- Select Region and Language
- Click on Formats Tab
- Click on Additional Settings
- Locate the List separator
- Change the separator from a full stop (.) to a comma (,)
- Then click on Apply then Ok
- Under the Formats Tab click on Apply then Ok
- Test the Excel import again
Windows 8/10
To change regional settings,
- go to Start > Control Panel > Regional and Language Options | (Windows 10 (Start >type Control Panel and press enter > Region))
- Click Additional Settings
- For Decimal Symbol, enter a dot:.
- For List Separator, enter a comma:,