PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

peoplecode to escape commas when creating csv file to display for excel

edited Aug 31, 2018 12:46PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

Hi,

I am using peoplecode to create a csv file and is facing this issue.

The name portion has a comma in it and must be included. However, when I opened the csv file in excel, it considered the 2nd half of the name a different cell.

eg. ABC,DEF in csv file

      will be

I would like the result to be

What is the code to do that? I cannot use filelayout and I have tried many different methods such as double quotes but nothing works.

Please help!

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT PeopleTools Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center