Comma as Thousand Separator in File Layout?

Payables was going to be rolled out to a new country and they were happy to use an existing interface to send Vouchers as CSV files to PeopleSoft. To get them started with it, We had given a template to set the format in which CSV files would be structured.

Then they sent us some sample interface files generated from the third-party system and we tried loading them. The App Engine that loaded the file went into Error – not a big surprise for a first run. Upon investigation it was found that the file had a comma as a decimal separator in the Merchandise Amount field.

Our File Layout had not been configured to accept commas as a decimal separator for amount fields. But now that the business needs such functionality, we will have to do a simple tweak in the File Layout field properties to make this happen – “Strip Characters” is what we are interested in here.

Strip Characters in File Layout Field Properties

Strip Characters in File Layout Field Properties

“Strip Characters” is the place where we specify what needs to be removed from the input buffer. This can not only be used to remove thousand separators but any character that you think is unnecessary. You can also specify multiple characters to be removed. For example, specifying :- would remove all : as well as -.

Tags: ,
Subscribe to Comments RSS Feed in this post
6 Responses
  1. Exactly what I’m looking for. Thanks!

  2. what if i want to strip a string like in a date time field i wan to remove ‘000000’ from it not single zeroes. cani achive it through this

  3. I have a string field (address) with comma. in that case how to handle it when we don’t have qualifier in the input csv file.

  4. How can I strip a carriage return/new line using Strip Characters?

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*