# How to use CRLF in flatfile field **URL:** \ **Category:** Forum\ **Tags:** EDI\ **Created:** [October 20, 2005, 6:35pm UTC](https://techcommunity.softwareag.com/t/how-to-use-crlf-in-flatfile-field/107136 "2005-10-20T18:35:11Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![shiva\_res](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@shiva\_res](https://techcommunity.softwareag.com/u/shiva_res)\ **Post date:** [October 20, 2005, 6:35pm UTC](https://techcommunity.softwareag.com/t/how-to-use-crlf-in-flatfile-field/107136/1 "2005-10-20T18:35:11Z")
We have a problem in creating a flat file schema for a kind of flat file data, where both record level and field level delimiters (carriage return line feed) are same for some of the records. The data given below resembles the kind of flat file data we are dealing with. Name_age_salary Address\*Street \*City _State Country DepartmentDivision_Project In the above sample data - Name, Address & Department are the three records, and Street,City,State & country are fields of Address record. While the fields of other two records(Name & Department) appear on the same line, the fields of Address go into the next lines as well. Though we were successful in creating a schema that generates the output in the same format as the sample data, we are unsure about the accuracy of such created schema. Can anyone help us out in creating a schema for this kind of data, where record level delimiter is "CRLF” (carriage return line feed) and field level delimiter is ‘\*’?. after every fields of address record there is a separate field holding "CRLF” (carriage return line feed). Regards, shiv ---
**Author:** ![shiva\_res](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@shiva\_res](https://techcommunity.softwareag.com/u/shiva_res)\ **Post date:** [October 21, 2005, 12:14am UTC](https://techcommunity.softwareag.com/t/how-to-use-crlf-in-flatfile-field/107136/2 "2005-10-21T00:14:09Z")
I think I should try with URLDecode service with input “%0D%0A”. The output variable might contain the CRLF pair, that can be mapped to required field. Regards, Shiv ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [October 21, 2005, 3:02pm UTC](https://techcommunity.softwareag.com/t/how-to-use-crlf-in-flatfile-field/107136/3 "2005-10-21T15:02:00Z")
Hi shiva, I am not too clear with your problem can you explain it little bit clear.you say that for address record there is CRLF for each field then why is the street in the same line of the Address it self,since address which is the first field in the record and the second field street should go to new line naaaaaaa. ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [October 21, 2005, 3:14pm UTC](https://techcommunity.softwareag.com/t/how-to-use-crlf-in-flatfile-field/107136/4 "2005-10-21T15:14:10Z")
Hi guys I have one problem here. while reading a flat file i have to verify if there are any foreign charecters like german,french etc , i mean i have to throw error if there any other charecters apart from english.Can i do this in ff schema defnition are is there any other means of verifying this ? ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [October 24, 2005, 1:19pm UTC](https://techcommunity.softwareag.com/t/how-to-use-crlf-in-flatfile-field/107136/5 "2005-10-24T13:19:05Z")
Developer, If ffschema if the encoding is UTF-8 it doesnt support latin based languages like german, french and throws exception. ISO-8858-1 support languages like frencg, german etc. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:04pm UTC](https://techcommunity.softwareag.com/t/how-to-use-crlf-in-flatfile-field/107136/6 "2021-04-02T15:04:41Z")