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.
Nameagesalary
Address*Street
*City State Country
DepartmentDivisionProject
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).
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.
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.
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 ?
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.