Hi,
I have a problem with a date formatted like dd.MM.YYYY
sometimes the is recognized as dd,MM,YYYY
I saw two solutions :
- in advanced post search detect comma and then replace commas with dots, I think I find comma with if( not IsNull and Value.Find(",")) but can I replace comma with dots ?
- I created 3 field day, month and year so I have all date parts, hoping to concatenate those 3 fields in a text block, through Expression, so I tried
SearchElements.Header.References.Day.Value + "." + SearchElements.Header.References.Month.Value + "." + SearchElements.Header.References.Year.Value
but obviously it's not the way Expressions work since I have "Error: Error in position 0: Unexpected expression type"
(I use a text field to get the date and really need a date formatted with the pattern dd.MM.YYYY)
Thank for your help...
I have a problem with a date formatted like dd.MM.YYYY
sometimes the is recognized as dd,MM,YYYY
I saw two solutions :
- in advanced post search detect comma and then replace commas with dots, I think I find comma with if( not IsNull and Value.Find(",")) but can I replace comma with dots ?
- I created 3 field day, month and year so I have all date parts, hoping to concatenate those 3 fields in a text block, through Expression, so I tried
SearchElements.Header.References.Day.Value + "." + SearchElements.Header.References.Month.Value + "." + SearchElements.Header.References.Year.Value
but obviously it's not the way Expressions work since I have "Error: Error in position 0: Unexpected expression type"
(I use a text field to get the date and really need a date formatted with the pattern dd.MM.YYYY)
Thank for your help...
コメント
2件のコメント
What does it matter if it picks up , or . in FlexiLayout. I mean FlexiLayout only passes back the region to FlexiCapture. In FLexiCapture, the region is then OCR. This is where you can replace the character if needed. Or maybe I'm not understanding you. Is it just not detecting the date at all? i.e. you are using a Date search element instead of Character string?
thx anyway
サインインしてコメントを残してください。