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

JackLacava's avatar
JackLacava
Honored Contributor
3 years ago

Set the Logical Operator on your Amount column to Complex Expression, then use the Snippets under Common Parsing -> General - in particular, the "Bypass Importing Lines of Data" one looks like a good candidate to detect unwanted characters.

I don't know how you'd abort the load completely, you can try with:

 

 Throw new Exception("Bad file")