List/Grid

Tag Archives: Reading file

File Layout Field Properties: Amout as Char

Comma as Decimal Separator in File Layout?

Your interface that uses File Layout and App Engine to load CSV files into PeopleSoft starts receiving Numbers that use comma as decimal separators. The interface will normally fail – here’s a simple technique to address this situation.

Strip Characters in File Layout Field Properties

Comma as Thousand Separator in File Layout?

When using a File Layout, there could be instances when you need to strip out certain unnecessary chracters from a field before loading data into PeopleSoft. This post explains how to do this in a simple way.

Record used in the example graphic

SQR: Reading from Flat File and Updating a Record

This post is in response to Fred’s request on ToD. He had asked for an SQR program that would read from a flat file and update the values to a… Read more »