Community

Correct value in flexilayout

Avatar
Written by Permanently deleted user
  • 2
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...

Was this article helpful?

0 out of 0 found this helpful

Comments

2 comments

Sort by Date Votes
  • Avatar
    Permanently deleted user
    Guillaume,

    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?
    0
  • Avatar
    Permanently deleted user
    You're right, I wasn't looking at the right place, I find a way to replace the commas with dots in the document definition editor (can be set in the field properties)

    thx anyway
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post