I am trying to identify if the amount entered is in correct format and also if it is Blank or not. In order to achieve that I am importing the amount in both text and numbered line item.
- Below are the different results we get when we import the amount in different formats in text and numbered line
AMT_Text | AMT_Number |
12,3/45 | 12345 |
12,345.46 | 12345.46 |
64,36 | 6436 |
A | 0 |
12A | 12 |
0.1A | 0.1 |
//1//\ | 1 |
AS123 | 123 |
//0.987 | 0.987 |
Ab//76 | 76 |
;'/1 | 1 |
we342 | 342 |
12//32 | 1232 |
12345 | 12345 |
12//// | 12 |
12//13 | 1213 |
//12.234 | 12.234 |
0.98 | 0.98 |
.//98 | 0.98 |
,87,89 | 8789 |
123.234 | 123.234 |
0.7764 | 0.7764 |
12,23,4.45 | 12234.45 |
1,34,235.66 | 134235.7 |
12..13 | 0 |
12>>13 | 1213 |
0 |
Can someone please share some idea on how to identify the invalid entries from the valid ones?
Hi @nildutta
First point here is Amount should always be imported in a number formatted line item . That is why you are seeing some texts and characters in text formatted line item .
If u want to make out which are entered correctly , my doubt is what type of number(Amount) you would like to see .
only Whole number or decimal is also Ok for you .
You can get rid of Decimal points in format itself . While selecting number format you can opt out Decimal point to be zero .
and if u have not added any amount , the number format line item still would take 0 or blank depending upon the format you were selected (Zero Format) .
You can get to know if the numbers are blank or not is by having boolean line item and check for value "0" or Blank . and can be entered correct value from registry(if you have data) for those in a separate line item . If only finding out is OK means Boolean is enough .
and also while importing , it imports only correct formatted amount only .
Let me know any further assistance is needed on this .
Regards,
Puneeth HP
Hi @nildutta
In that case you can do like this .
Text line item is import as you mentioned.
Number line item is a number formatted line item with formula = VALUE(Text) . which gives only valid numbers .
Correct is boolean . formula = IF Number > 0 then FALSE else TRUE ... If you want zero value to be opt out here then you change the condition >= 0 .
Hope this helps .
Regards,
Puneeth HP
Yes @nildutta Thank you . I am aware of this .
Anyway to avoid this, minimal data manipulation should happen is what my concern .
We can still achieve this by taking out Comma and it will be adding more complexity to data is what I feel .
Thanks,
Puneeth HP