Handle record separator within field
Is there a way to handle a record separator within the field? I know that field separators can use ‘Quotes Handling’ in Adeptia.
Example: Record separator is Carriage Return/Line Feed
Name, Address, Phone
Homer, 123 Evergreen Terrace, 867-5309
Chris, "Van Down
By The River", 555-5555
How do I treat the second record as one record?
As your data field also contains the record separator then in that case the data after that is considered as next record. Try using below workaround and hopefully this should help resolve your concern:
- Enable Allow Less Fields option with quote handling disabled under Adv properties of Schema.
- In Data Mapper write Custom XSL to combine the separated records. Use " to identify the records that needs to be combined.
Post is closed for comments.