PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

how to read csv file through App engine peoplecode which has one field having values with comma.

edited Jun 28, 2019 4:46PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 9 commentsAnswered
Hi All,

I am trying to read a .csv file and load that into peoplesoft table. 
file has one amount field(character type) which can have comma(e.g. 2,400,00.00). I want my program to read this field value load into table.

Currently while reading the file as soon as it see first comma in amount field it takes rest all values in next field and program errors out.

file is coming from a place outside our control, and we cannot therefore change the format of the input file. also data in the file can have large number of rows so it is not efficeint to place quotes(" ") around the amount field manually and then do the processing. 

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center