Page 1 of 1
Checking CSV File data before loading
Posted: Tue Mar 23, 2010 6:30 am
by appleglaze28
I was wondering I have a cube that a user needs to write a string. I'm gonna extract it before I load it to create a dimension. What syntax can I use to check the elements or column in CSV wehn it comes to the # of character. That if the data is beyond or less than 6 digit it won't load the element to the dimension.
Re: Checking CSV File data before loading
Posted: Tue Mar 23, 2010 7:28 am
by Alan Kirk
appleglaze28 wrote:I was wondering I have a cube that a user needs to write a string. I'm gonna extract it before I load it to create a dimension. What syntax can I use to check the elements or column in CSV wehn it comes to the # of character. That if the data is beyond or less than 6 digit it won't load the element to the dimension.
You can use the Long() rules function to check the length of a string variable.