Forum Discussion

TimVierhout's avatar
TimVierhout
New Contributor III
3 years ago

Checking for a 1000 separator in the source file

Hi all, In our use case, users are uploading data through files into OneStream. Is there a possibility to check if the file have 1000-seperators in the file and block the upload if this is the case?...
Data Sources
  • franciscoamores's avatar
    franciscoamores
    3 years ago

    Hello,

    there is webinar recording and pdf in Partner Enablement .

    It covers cool staff for international apps. One is how to use BRString in data sources to dynamically manage separators.

    HTH

TimVierhout's avatar
TimVierhout
New Contributor III
3 years ago

Hi Jack,

in general that would work, however we are checking args.value for the amount column. Once it gets into stage it looks like there the decimal symbol is already removed, so in this case it would not work. Also it could be different based on the user.

With kind regards,

Tim